ETL Developer

Role overview Build and maintain enterprise data integration solutions that bring information from multiple systems into reliable data stores and analytics environments. The role covers batch and near real-time pipelines, data quality, production support, and collaboration with both technical teams and business partners. Work must follow applicable governance, security, and privacy standards.

Responsibilities - Design, develop, test, and maintain ETL/ELT pipelines for data integration and warehousing. - Create mappings, transformations, and validation rules based on source systems and business needs. - Develop data warehouses, operational data stores, and reporting marts, and implement reconciliation and exception handling. - Tune pipeline performance and troubleshoot processing problems, including large-scale workloads. - Work with data architects, database administrators, analysts, and application teams; document designs and operating procedures. - Support production releases and incident resolution while maintaining data quality and compliance.

Requirements - At least six years of hands-on ETL development, data integration, and data warehousing experience. - Experience with an ETL platform such as Informatica, SSIS, Talend, DataStage, or AWS Glue. - Strong SQL skills and experience with relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL. - Knowledge of complex transformations, migration, dimensional modeling, and star or snowflake schemas. - Experience with cloud data services, data quality, governance, metadata, performance tuning, and error handling. - Bachelor’s degree in a relevant field, or four additional years of relevant experience in place of the degree; U.S. citizenship or permanent residency and eligibility to obtain Public Trust clearance are required.

Nice to have - AWS data services, lake or lakehouse architectures, Python, PySpark, shell scripting, CI/CD, or DevOps experience. - Familiarity with analytics tools, regulated environments, data governance or master data management, and technologies such as Spark, Kafka, or Hadoop. - Cloud, data engineering, or database certifications; experience mentoring developers or leading implementations.

Benefits and work setup - No travel is required. The role may include medical, dental, vision, retirement, paid leave, parental leave, disability coverage, tuition support, and professional development benefits. - The listed annual salary range is $113,000–$188,000; compensation depends on experience, skills, location-related factors, and other business needs.