Data Engineer - Medicaid Data Warehouse

We are seeking a highly experienced Data Engineer to support the development and maintenance of an AWS-based Data Warehouse designed to enable advanced business analytics and reporting in a Medicaid data environment. The role involves end-to-end development and management of ETL pipelines using IBM Data Stage, transforming data for DB2 Warehouse schemas, and ensuring consistent, high-quality data availability to support Cognos reporting.

Job Responsibilities:

• Design, develop, and maintain ETL pipelines using IBM Data Stage to ingest and transform Medicaid data
• Implement both batch and incremental data jobs aligned with reporting requirements
• Support data modeling to meet Cognos reporting needs
• Collaborate with business analysts, report developers, and data stewards to convert requirements into solutions
• Conduct data profiling, validation, and cleansing to ensure data quality
• Use AWS services (e.g., S3, EC2, Glue, Lambda) to enhance data processing
• Monitor ETL performance and troubleshoot job failures to meet SLAs
• Create and maintain documentation and data flow diagrams
• Support testing, deployment, and version control across DEV, TEST, and PROD
• Ensure compliance with HIPAA and Medicaid data security standards

• Minimum 7 years of experience in Data Engineering or Data Warehousing
• Production experience with IBM Data Stage or similar ETL tools
• Strong proficiency with DB2 Warehouse: complex SQL, stored procedures, schema design
• Working knowledge of AWS (S3, Glue, Lambda, Cloud Watch) for data solutions
• Experience with large datasets and performance tuning
• Familiarity with Cognos or similar BI tools for data support
• Knowledge of data governance, metadata management, and HIPAA compliance
• Shell scripting or Python scripting for job orchestration (preferred)

• Experience with Medicaid data or Medicaid Data Warehouses
• AWS certification (e.g., Data Analytics Specialty or Solutions Architect Associate)
• IBM Data Stage certification
• Familiarity with Agile/Scrum methodologies, Jira, and Confluence

AWS and IBM Data Stage certifications preferred

Education:

Bachelor’s Degree required (in Computer Science, Information Systems, or related field)

Years of

Experience:

Minimum 7 years of relevant experience

Email  
* This field is required Please enter valid email

Id.

Cell phone
* This field is required Please enter valid cell phone.

First Name
* This field is required Please enter valid first name.

Last Name
* This field is required Please enter valid last name.