2h 1m ago
ETL Developer
$150k - $250k USD/yr
nifipostgresqlsqlawsgit+1
On-site
|United States of AmericaETL Developer
GRVTY | Defense and national security
2h 1m agoOn-site
Full Time
IC
United States of America
$150k - $250k USD/yr
Title: ETL Developer
Location: McLean, Virginia, United States
What You'll be Owning
GRVTY is seeking an ETL Developer with a TS/SCI + Poly clearance (applicable to this customer) to join one of our top projects in McLean, VA. This role focuses on developing, maintaining, and optimizing data pipelines to ensure reliable data flow into a PostgreSQL database. The ideal candidate will have strong experience in ETL processes, data integration, and working with large, complex datasets, including geospatial data.
- Design, develop and manage ETL workflows using Apache NiFi to support a geospatial visualization platform
- Learn the nuances of the existing NiFi system and the related AWS and PostgreSQL infrastructure in order to monitor and troubleshoot real time issues
- Obtain an understanding of existing NiFi flows with minimal support from others
- Develop new NiFi flows that adopt best practices of existing NiFi flows
- Take feedback on NiFi flows and develop requested changes
- Take direction and communicate status via a ticketing system
- Interface with analysts via email, chat, and in person meetings to comprehend future data flow needs and refine general requirements into specific actions
- Interface with a development cycle using a local development environment of containerized infrastructure and version control via Git and NiFi Registry
- Gain competency in geospatial database design and employ best practices for table creation, indexing, and unique constraints
- Take feedback from analysts on nuances to support application data layers
- Programmatically manipulate and transform data from multiple sources
- Query and analyze large datasets using SQL
- Retrieve and process data from external systems via APIs
- Support data quality, integrity, and performance optimization efforts
- Understand Python and data science frameworks while differentiating between experimental prototypes and enterprise level software requirements
- Develop Python in support of data science related efforts or ETL prototypes
What You Must Have
- Active TS/SCI with Polygraph Clearance
- Bachelor’s degree in Computer Science, Systems Engineering, Geography, or a related technical field (or equivalent experience).
- Minimum 8 years of experience with a Bachelor’s degree; or 7 years of experience with a Masters degree; or 6 years of experience with a Doctorate.
- Experience in developing NiFi flows using existing best practices.
- Strong understanding of ETL concepts and best practices.
- Strong experience with databases for data management.
- Proficiency in SQL for querying large datasets.
- Experience with API integration and data retrieval.
- Demonstrated experience with programmatic data manipulation.
- Competency to rapidly adopt containerized development proficiency.
- Competency to rapidly adopt AWS architecture proficiency.
- Competency to rapidly adopt NiFi registry and Git for code management.
What Would be Nice to Have
- Creativity to experiment and recommend best practice coding improvements.
- Drive to adopt and recommend AI into development processes.
- Ability to design and develop custom NiFi processors using Java.
- Experience with AWS cloud services for data ingestion and processing.
- Strong experience with PostgreSQL for data management.
- Hands-on experience with Apache Airflow.
- Hands-on experience with Apache NiFi.
- Hands-on experience with NiFi registry and Git.
- Hands-on experience with Git and repository actions and pull requests.
- Hands-on experience in Python for data manipulation and API interfacing.
- Experience working with geospatial data and related tools.
- Understanding of basic data science concepts and tools
Pay Range: At GRVTY, we understand that compensation is influenced by many factors—such as geographic location, federal contract labor categories, wage rates, prior experience, skillsets, education, and certifications.
We’re proud to offer a work environment that empowers our team to achieve a strong work-life balance. GRVTY provides competitive pay, comprehensive benefits, and meaningful opportunities for professional growth.
Our benefits package is designed to support the well-being of our employees and their families, and includes coverage in areas such as healthcare, financial wellness, retirement planning, family assistance, continued education, and paid time off.
Virginia Pay Range
$150,000 - $250,000
Pay Range: At GRVTY, we understand that compensation is influenced by many factors—such as geographic location, federal contract labor categories, wage rates, prior experience, skillsets, education, and certifications.
We’re proud to offer a work environment that empowers our team to achieve a strong work-life balance. GRVTY provides competitive pay, comprehensive benefits, and meaningful opportunities for professional growth.
Our benefits package is designed to support the well-being of our employees and their families, and includes coverage in areas such as healthcare, financial wellness, retirement planning, family assistance, continued education, and paid time off.
Virginia Pay Range
$150,000—$250,000 USD
Why Choose GRVTY
The toughest national security challenges demand vision and ingenuity, not just resources. We deliver mission and technical expertise to outpace our adversaries. We’re purpose-built to tackle the most entrenched, systemic national security issues around the world.
We partner with our customers to help them overcome challenges in every corner of technology and defense—including the ones still being explored. Our growing capabilities create complementary advantages, giving on-the-ground operations the edge they need to succeed. We muster everything we have to answer every challenge presented, every day of our lives.
At GRVTY, we believe that when our employees thrive, our company thrives. That’s why we offer a comprehensive and competitive benefits package designed to support your well-being, growth, and work-life balance.
• Robust health plan including medical, dental, and vision
• Health Savings Account with company contribution
• Annual Paid Time Off and Paid Holidays
• Paid Parental Leave
• 401k with generous company match
• Training and Development Opportunities
• Award Programs
• Variety of Company Sponsored Events
EEO Statement
GRVTY, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran and will not be discriminated against on the basis of disability.
Know Your Rights: Workplace Discrimination is Illegal (eeoc.gov)
Please review our current job openings and apply for the positions you believe may be a fit. If you are not an immediate fit, we will also keep your resume in our database for future opportunities.
Required Skills
nifipostgresqlsqlawsgitpython
Required Languages
🇬🇧 English