Ab Initio Data Engineer

We are seeking a highly experienced Lead Ab Initio Data Architect to design, build, and modernize enterprise-scale data integration, data warehousing, and data governance solutions. The ideal candidate will bring deep expertise in Ab Initio technologies, data architecture, metadata management, and cloud-based data platforms while providing technical leadership across complex transformation initiatives within Healthcare, Insurance, Banking, or Financial Services domains.

• Lead the architecture, design, and implementation of large-scale data warehouse and data integration solutions using Ab Initio.
• Design and develop high-performance ETL/ELT frameworks, reusable components, and metadata-driven solutions.
• Provide technical leadership and guidance to development teams throughout the project lifecycle.
• Develop and maintain data governance, data lineage, metadata management, and data quality solutions using Ab Initio Metadata Hub and DQE.
• Partner with business and technology stakeholders to translate requirements into scalable technical solutions.
• Architect and implement enterprise data quality frameworks, business glossaries, and lineage solutions.
• Design and optimize batch and real-time data processing pipelines.
• Support cloud migration strategies, including modernization of on-premise ETL platforms to AWS-based environments.
• Lead architecture reviews, technical assessments, and proof-of-concept initiatives.
• Drive best practices for performance tuning, code reviews, CI/CD implementation, and operational excellence.
• Develop and maintain RESTful and SOAP service integrations supporting enterprise data services.
• Collaborate with governance and compliance teams to support regulatory initiatives involving data lineage, data quality, and metadata management.
• Mentor engineers and provide technical oversight across multiple projects and programs.

We strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a remote position open to qualified applicants in the United States. Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 15+ years of experience in data warehousing, data integration, and enterprise data architecture.
• Advanced expertise with Ab Initio including:
  • GDE
  • EME
  • Conduct>
    
    It
  • Query>
    
    It
  • Express>
    
    It
  • Metadata Hub
  • DQE/DQA
  • Continuous Flows
• Strong experience designing and implementing enterprise data warehouse solutions.
• Experience building metadata-driven and reusable ETL frameworks using PDL metaprogramming and parameter sets.
• Strong knowledge of data governance, metadata management, data lineage, and data quality implementations.
• Hands-on experience with AWS cloud services and cloud migration initiatives.
• Strong SQL development, query optimization, and performance tuning experience.
• Experience working with Oracle, Teradata, Snowflake, or similar enterprise databases.
• Experience implementing CI/CD practices using tools such as Git Hub and Jenkins.
• Experience leading technical teams and providing architecture guidance.
• Strong understanding of SDLC methodologies including Agile and Waterfall.
• Excellent communication, stakeholder management, and problem-solving skills.

• Experience with in Healthcare, Insurance, PBM, Banking, Investment Banking, or Financial Services industries.
• Experi…