Sr. Data Warehouse Specialist / ETL Developer

Key Responsibilities

• Design, build, and maintain complex ETL/ELT data pipelines that extract, transform, and load data from multiple source systems into enterprise data warehouses and data marts.
• Develop scalable data integration workflows to migrate and transform data across platforms and support target systems (e.g., MRT and enterprise data environments).
• Optimize SQL queries and ETL processes to improve performance, efficiency, and execution reliability.
• Ensure data accuracy, quality, and reliability across all data integration processes and data pipelines.
• Support full systems development lifecycle (SDLC) activities, including requirements gathering, design, development, testing, deployment, troubleshooting, and maintenance.
• Execute data migration and transformation activities, including converting data formats and integrating legacy systems into modern data platforms.
• Develop and maintain automated data integration processes using ETL/ELT patterns and emerging approaches such as real-time or near real-time integration when required.
• Provide technical leadership and mentorship to junior team members and enforce best practices across data engineering activities.
• Collaborate with cross-functional teams, including data architects, analysts, and QA personnel, to align data solutions with business requirements.

Required Skills And Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Experience designing and developing ETL/ELT pipelines for large-scale data integration and data warehouse environments.
• Strong SQL expertise, including query optimization and performance tuning.
• Experience with enterprise data integration tools (e.g., IBM DataStage or similar ETL platforms).
• Experience supporting data warehousing and data mart development efforts in complex environments.
• Knowledge of data integration patterns, including ETL, ELT, and data migration across platforms.
• Experience ensuring data quality, validation, and reliability within production data pipelines.
• Ability to support full SDLC activities, including testing, deployment, and operational maintenance.

Desired Skills And Qualifications

• Experience in federal data environments (e.g., USDA FPAC or similar agencies).
• Experience working with large-scale data sets and complex transformation logic.
• Familiarity with real-time or near real-time data integration approaches and data federation techniques.
• Experience supporting enterprise data warehouse modernization or migration initiatives.
• Ability to work in Agile or hybrid SDLC environments supporting federal programs.

Pay

Competitive compensation package.

Schedule

Full-time position.

Benefits

Healthcare benefits that start on your first day, commuter benefits, work-life balance, and the opportunity to work alongside an amazing and growing team.