Overview
Skills
Job Details
Key Responsibilities:
Design, develop, and maintain ETL jobs to ingest, transform, and load data into the DB2 data warehouse for Cognos reporting.
Utilize AWS services (S3, EC2, RDS, Step Functions, etc.) to optimize data processing workflows.
Implement best practices for data modeling to ensure efficient reporting in IBM Cognos Analytics.
Develop and optimize SQL queries, stored procedures, and indexing strategies for DB2.
Support Cognos report developers in structuring data efficiently to meet reporting needs.
Implement security, compliance, and data governance best practices for handling sensitive data.
Qualifications:
Strong hands-on experience with AWS services (S3, RDS, Redshift, etc.).
Proficiency in Python or Shell scripting for automation.
Experience with IBM Cognos Analytics and understanding of reporting structures.
Preferred Qualifications:
Experience in Medicaid and/or Healthcare Plan environment is strongly preferred.
Knowledge of DB2 on AWS Cloud.
AWS Certified Data Analytics Specialty or AWS Certified Solutions Architect is a plus.