Sr. Data Engineer – Master Data Management

Role Description:

In this role, you will be part of a high performing team, which includes Master Data Management experts responsible for maintaining high-quality, consistent, accurate and controlled Master Data for the Enterprise. This role involves working with large datasets, developing reports, supporting and executing data governance initiatives and, visualizing data to ensure data is accessible, reliable, and efficiently managed. The ideal candidate has strong technical skills, experience with MDM technologies, and a deep understanding of data architecture and ETL processes

Roles & Responsibilities:

• Recommend best practices to maintain master data across their lifecycle
• Develop and execute Enterprise Master Data Management strategy and roadmap, for Healthcare Customer Master, Affiliations, Product, Plan Payer domains
• Provide expertise for match & merge, survivorship rules, business rules, standards, and other MDM related activities
• Work with data stewards to design match, merge, unmerge rules and exception resolution workflow
• Configure master data rules and analyze UI/workflow requirements
• Configure MDM business and data stewardship user interface
• Configure MDM workflow for exception resolution and task-based routing
• Configure MDM data model, audit trail and security
• Configure and create necessary staging and master data structures
• Define hierarchy structures, attributes and relationships across master data domains and elements
• Support testing and deployment
• Create data pipelines and ensure data quality by implementing ETL processes to migrate and deploy data across systems
• Provide technical leadership and guidance to development teams, ensuring alignment to best practices and standards.
• Work closely with Data Stewards and troubleshoots errors in Informatica MDM and IDQ.
• Participate in project planning, estimation, and risk assessment.
• Mentor junior team members and contribute to knowledge sharing.
• Create comprehensive technical documentation, including design specifications, architecture diagrams, and user guides.
• Follow Agile software development methods to design, build, implement, and deploy.
• Collaborate and communicate effectively with product teams

Basic Qualifications and Experience:

• Doctorate Degree OR
• Masters degree with 4 - 6 years of experience in Computer Science, IT or related field OR
• Bachelors degree with 6 - 8 years of experience in Computer Science, IT or related field OR
• Diploma with 10 - 12 years of experience in Computer Science, IT or related field

Functional Skills:

Must-Have Skills:

• Proficiency in Informatica MDM or Reltio MDM platform
• Proficient in one of the coding languages (Python, Java, Scala)
• Has hands on experience writing SQL using any RDBMS (Redshift, Postgres, MySQL, MongoDB, Oracle, etc.).
• Hands on experience using Databricks/Jupyter or similar notebook environment and AWS Services like EC2, S3, Unity Catalog, Athena, RDS, Lambda, and API gateway
• Experience with Schema Design & Dimensional data modeling.
• Experience with software DevOps CI/CD tools, such Git, Jenkins, Linux, and Shell Script

Good-to-Have Skills:

• Knowledge of data protection regulations and compliance requirements (e.g., GDPR, CCPA)
• Experience with bio-pharma master data and transactional information (commercial, medical, clinical, etc.)
• Experience with pharma/healthcare business processes (commercial, medical, clinical, etc.)
• Experience with software DevOps CI/CD tools, such Git, Jenkins, Linux, and Shell Script
• Experience with Spark, Hive, Kafka, Kinesis, Spark Streaming, and Airflow.
• Strong understanding of data modeling, data warehousing, and data integration concepts
• Experience working with test-driven development and software test automation
• Manage team of diverse skill sets (programmer, cloud analyst, BI developer, reporting, operations, etc.)
• Up to speed with latest technologies related (but not limited to) to cloud platform services, visualization, data management
• Ability to distill complex concepts into easy-to-understand frameworks and presentations

Soft Skills:

• Excellent critical-thinking and problem-solving skills
• Strong communication and collaboration skills
• Demonstrated awareness of how to function in a team setting
• Demonstrated presentation skills