Overview
On Site
DOE
Contract - W2
Skills
Business Analytics
Management
Data Modeling
Collaboration
Reporting
Data Profiling
Data Quality
Amazon EC2
Data Processing
Documentation
Data-flow Diagrams
Testing
Version Control
Regulatory Compliance
Data Security
Data Engineering
Extract
Transform
Load
IBM DB2
Warehouse
SQL
Stored Procedures
Amazon S3
Performance Tuning
IBM Cognos Analytics
Business Intelligence
Data Governance
Meta-data Management
HIPAA
Shell Scripting
Python
Scripting
Orchestration
Medicaid
Data Warehouse
Data Analysis
Agile
Scrum
JIRA
Confluence
Amazon Web Services
IBM InfoSphere DataStage
Job Details
Job Summary: 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 DataStage, 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 DataStage 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 Required Skills: Minimum 7 years of experience in Data Engineering or Data Warehousing Production experience with IBM DataStage or similar ETL tools Strong proficiency with DB2 Warehouse: complex SQL, stored procedures, schema design Working knowledge of AWS (S3, Glue, Lambda, CloudWatch) 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) Preferred Skills: Experience with Medicaid data or Medicaid Data Warehouses AWS certification (e.g., Data Analytics Specialty or Solutions Architect Associate) IBM DataStage certification Familiarity with Agile/Scrum methodologies, Jira, and Confluence Certifications: AWS and IBM DataStage certifications preferred Education: Bachelors Degree required (in Computer Science, Information Systems, or related field) Years of Experience: Minimum 7 years of relevant experience
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.