ETL Developer (Ab Initio) || 100% Remote

Job Title: ETL Developer (Ab Initio)

Job Location: Remote

Job Type – Contract

Job Description

We are seeking an experienced Analytics / ETL Developer (Ab Initio) with strong SQL and ETL expertise to support healthcare data warehousing and analytics initiatives. The ideal candidate will have hands‑on experience with enterprise‑scale ETL development (preferably Ab Initio or equivalent), R programming, and deep SQL knowledge, along with a solid understanding of healthcare data domains and compliance standards. This role involves close collaboration with analytics, business, and QA teams in a hybrid work environment.

Responsibilities:

Analytics / ETL Developer
• Design, develop, and maintain scalable ETL pipelines for large healthcare data warehouses
• Develop, optimize, and maintain complex SQL queries, including:
• Stored procedures
• Common Table Expressions (CTEs)
• Nested queries and multi‑table join
• Perform data transformations, validations, and reconciliations to ensure high data quality and accuracy
• Work with structured and semi‑structured healthcare data across RDBMS and analytics platforms Use Unix/Linux shell scripting for automation, job control, and operational support
• Support downstream analytics and reporting use cases for BI and data science teams
• Participate in the full SDLC using Waterfall methodologies
• Collaborate using Agile/SDLC tracking tools such as Rally
• Manage source control and CI/CD processes using GitLab and Jenkins
• Schedule, monitor, and troubleshoot batch jobs using Control‑M or other enterprise schedulers
• Ensure adherence to healthcare compliance and security standards including:
• HIPAA
• SOC 2
• HITRUST

Preferred Skills

Technical Expertise
• Strong SQL expertise (mandatory)
• Stored procedures, CTEs, complex joins, performance tuning
• ETL Development Experience: 5–8 years overall
• R programming experience for analytics and data processing
• Unix/Linux shell scripting
• Solid understanding of: Data warehousing concepts, RDBMS architecture and design, Analytics and reporting pipelines

Ab Initio – Good to have

Candidates without Ab Initio are acceptable if they have strong ETL + R experience
• Enterprise ETL tools (Ab Initio, Boomi, or similar)
• GitLab, Jenkins (CI/CD)
• Control‑M or equivalent job schedulers
• Rally or similar SDLC/Agile tracking tools

• Thanks & regards

Akram Khan