ETL Developer

Overview

Design, build and maintain enterprise ETL/ELT solutions and data pipelines that integrate data from multiple source systems for batch and near real-time processing.

What you'll do

• Design, develop, test, and maintain enterprise ETL/ELT solutions to integrate data from multiple source systems.
• Develop scalable and high-performance data pipelines for batch and near real-time data processing.
• Build and maintain data integration workflows using modern ETL tools and cloud-based data platforms.
• Analyze source systems and business requirements to create efficient data mapping, transformation, and validation rules.
• Optimize ETL performance, troubleshoot data processing issues, and implement tuning strategies to improve efficiency.
• Collaborate with data architects, database administrators, business analysts, and application teams to deliver reliable data solutions.
• Develop and maintain data warehouses, operational data stores, and reporting data marts.
• Implement data quality checks, reconciliation processes, and exception handling frameworks.
• Create and maintain technical documentation, design specifications, and operational runbooks.
• Support production deployments, incident resolution, and continuous improvement initiatives.
• Ensure compliance with data governance, security, privacy, and organizational standards.

What you'll need

• U.S. Citizenship or Green Card required, with the ability to obtain a Public Trust clearance.
• Bachelor's degree in computer science, cybersecurity, engineering, or a related field; four additional years of relevant experience may be substituted in lieu of a degree.
• Minimum 6 years of hands-on experience in ETL development, data integration, and data warehousing.
• Strong experience with ETL tools such as Informatica, SSIS, Talend, DataStage, AWS Glue, or similar platforms.
• Proficiency in SQL and database technologies including SQL Server, Oracle, PostgreSQL, or MySQL.
• Experience designing complex data transformation, data migration, and integration.
• Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
• Experience working with cloud-based data services and modern data platforms.
• Knowledge of data quality, data governance, and metadata management best practices.
• Experience with performance tuning, error handling, and troubleshooting large-scale ETL processes.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively in Agile development environments and collaborate across technical and business teams.

Nice to have

• Experience with AWS data services such as AWS Glue, S3, Redshift, Lambda, Athena, and Step Functions.
• Experience with modern data lake and lakehouse architectures.
• Knowledge of Python, PySpark, Shell Scripting, or other automation technologies.
• Experience with CI/CD pipelines and DevOps practices for data engineering.
• Familiarity with data visualization and analytics tools such as Power BI, Tableau, or QuickSight.
• Experience supporting federal government or highly regulated environments.
• Industry certifications related to cloud platforms, data engineering, or database technologies.
• Experience implementing master data management (MDM) and data governance frameworks.
• Knowledge of big data technologies such as Spark, Kafka, or Hadoop.
• Experience mentoring junior developers and leading technical implementation efforts.

Details

• Remote (any location in the US).
• Travel: none.
• Clearance: ability to obtain Public Trust.
• Annual salary range: $113,000.00-$188,000.00.
• Position may be eligible for a discretionary variable incentive bonus.