Key skills: Data engineer, Ab Initio, ETL, SQL
Role: Data Engineer
Location: Remote but Preference Hartford, CT is good to be
Position Summary:
We are seeking an Onshore production Support Data Engineer with strong ETL, Ab Initio, data warehousing, and healthcare insurance experience to lead the design, development, implementation, and production support of enterprise data solutions. This role will support large-scale data warehouses, data marts, data repositories, and data pipelines across on-premises and Google Cloud environments. The ideal candidate will combine hands-on technical expertise with leadership skills and will help modernize data workloads while ensuring reliable, secure, scalable, and high-quality solutions.
Key Responsibilities:
- Lead developers in delivering and supporting data transformation solutions for large data warehouses, data marts, data repositories, and cloud/on-premises platforms.
- Design, develop, test, debug, document, and optimize complex ETL workflows and data pipelines using Ab Initio and related technologies.
- Develop and maintain Ab Initio graphs, plans, scripts, reusable components, parameter sets, and Devops/GitHub EMU repository assets.
- Analyze requirements and independently design cost-effective, scalable application and data integration solutions.
- Support modernization and migration of on-premises Ab Initio/DB2 workloads to GCP-native solutions, including Big Query-based processing.
- Write and optimize complex SQL and Python solutions for data transformation, validation, reconciliation, and troubleshooting.
- Perform ongoing system maintenance, production support, incident research, problem resolution, performance tuning, and on-call support.
- Lead unit testing and support integration, system, regression, and User Acceptance Testing to ensure high-quality releases.
- Troubleshoot ETL failures, data-quality issues, batch-processing problems, and production incidents across complex data flows.
- Partner with business stakeholders, data architects, QA, infrastructure, cloud, and support teams throughout the software development lifecycle.
- Follow prescribed engineering, code-asset management, security, documentation, CI/CD, and operational standards.
- Promote reusable frameworks and engineering assets across the organization.
Required Qualifications:
- 5+ years of experience in ETL solution design, data warehousing, software development, and application production support.
- 5+ years of hands-on experience with Ab Initio, including GDE, EME (Enterprise Metadata Environment), graphs, plans, and enterprise ETL development.
- 5+ years of advanced SQL development experience in an enterprise environment.
- 5+ years of experience with Unix/Linux systems and shell scripting.
- 3+ years of experience with programming languages, development tools, databases, and the systems development lifecycle.
- 2+ years of hands-on experience with Google Cloud Platform (GCP), Big Query, and Python.
- Experience designing and supporting enterprise data warehouse/data mart solutions and large-scale batch data processing.
- Strong analytical, troubleshooting, communication, and technical leadership skills.
- Experience working with healthcare insurance data and applications.
Preferred Qualifications:
- Experience migrating Ab Initio or other on-premises ETL workloads to GCP-native services.
- Knowledge of data quality, metadata management, data lineage, performance optimization, and reusable ETL frameworks.
- Experience with CI/CD, GitHub-based development practices, observability, and production operational support.
- Familiarity with healthcare payer data domains such as membership, claims, pharmacy, provider, and care management.
Education:
Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent education/experience required.