Dice is the leading career destination for tech experts at every stage of their careers. Our client, COOLSOFT, is seeking the following. Apply via Dice today! <> Now Hiring: Data Engineer Medicaid Data Warehouse (AWS Infrastructure) Work Mode: 100% Remote Duration: Long-term (21-month contract) Role Overview We are seeking a senior-level Data Engineer to lead the design and maintenance of a high-performance Medicaid Data Warehouse built on AWS infrastructure. You will develop robust ETL pipelines, manage large-scale data transformation tasks using IBM DataStage, and support reporting teams by ensuring timely, accurate, and secure data delivery for analytics platforms such as Cognos. This role is ideal for someone who thrives in complex healthcare data environments and is experienced in building cloud-native data systems. Key Responsibilities <> ETL & Pipeline Development • Design and implement ETL jobs using IBM DataStage for ingesting and transforming Medicaid-related datasets • Develop batch and incremental data flows to populate DB2 Warehouse targets • Support data transformation logic to meet reporting needs and business rules <> Data Modeling & BI Integration • Partner with BI teams to design schemas that support Cognos reporting • Support data profiling, validation, and cleansing to ensure trust in data quality • Maintain metadata and technical documentation for all pipeline processes <> AWS Integration • Leverage AWS services (e.g., S3, Glue, Lambda, CloudWatch) for data processing and automation • Support cloud data architecture and ensure performance tuning, scaling, and security <> Testing, Compliance & Support • Ensure ETL solutions meet HIPAA and Medicaid data security guidelines • Monitor job performance and perform root-cause analysis when issues arise • Maintain version control and job promotion through DEV/TEST/PROD environments Required Skills & Qualifications • 7+ years of experience in Data Engineering, ETL development, or Data Warehousing • Hands-on expertise with IBM DataStage (or comparable ETL tools) • Strong command of DB2 Warehouse, including complex SQL, stored procedures, and schema design • Proficiency with AWS services used in data engineering (S3, Glue, Lambda, CloudWatch) • Familiarity with Cognos or other BI platforms for data support • Solid grasp of data governance, compliance (HIPAA), and metadata management • Experience in data profiling, quality checks, and performance tuning • Bonus: Knowledge of Python or shell scripting for orchestration Preferred Qualifications • Experience working with Medicaid data and warehouses • AWS Certifications (e.g., Data Analytics Specialty, Solutions Architect Associate) • IBM DataStage Certification • Familiarity with Agile/Scrum methodologies and tools like Jira/Confluence Soft Skills • Excellent communication and teamwork abilities • Self-starter with strong time management across multiple priorities • Highly detail-oriented, with a strong focus on data accuracy and integrity Skills Summary: Data Engineering, ETL, IBM DataStage, DB2 Warehouse, SQL, Stored Procedures, Data Modeling, AWS S3, AWS Glue, AWS Lambda, AWS CloudWatch, Cognos, Data Profiling, Data Validation, HIPAA Compliance, Medicaid Data, Python, Shell Scripting, Metadata Management, Agile, Jira, Confluence Apply now if you're a cloud-savvy, detail-oriented Data Engineer ready to deliver mission-critical healthcare data solutions! Click the link and apply: