Sr Technical Specialist - II_Data Engineering

Meritore Technologies is seeking a highly experienced Senior Data Engineer to support enterprise data platforms in the Healthcare domain. The role focuses on designing Snowflake-based data warehouses, developing ETL/ELT pipelines, implementing Medallion Architecture, ensuring data quality and governance, and leading client-facing solution design and delivery.

Responsibilities:

• Design and implement scalable Snowflake-based data warehouse solutions
• Build and maintain Medallion Architecture (Bronze, Silver, Gold) data platforms
• Develop and optimize complex SQL queries, data transformations, and performance tuning strategies
• Work extensively with Healthcare data, preferably Provider Data, ensuring accuracy, consistency, and compliance
• Collaborate with business users, architects, and cross-functional teams to deliver data-driven solutions
• Establish and enforce best practices for data engineering, governance, and quality
• Perform data analysis, reconciliation, and validation using advanced Excel techniques
• Lead client discussions, architecture reviews, and technical solution presentations
• Support implementation of modern data engineering practices and cloud-based data platforms

Requirements:

• 10-12+ years of overall experience in Data Engineering and Data Warehousing
• 5+ years of hands-on experience with Snowflake (mandatory), SQL
• Strong Provider domain experience (mandatory) , Provider Data Management
• Experience working with Provider Data, Provider Network
• Expert-level SQL development, optimization, and performance tuning
• Deep understanding and implementation experience of Medallion Architecture (Bronze, Silver, Gold layers)
• Experience designing and developing scalable ETL/ELT pipelines
• Strong Data Modeling and Data Warehousing expertise
• Advanced Excel skills for data analysis, reconciliation, and validation
• Client-facing experience with strong stakeholder management and communication skills
• Ability to lead technical discussions, requirement gathering, and solution design workshops
• Experience with data quality, governance, lineage, and best practices
• Git Experience - Expert knowledge of Git workflows including branching strategies, pull requests, merge conflict resolution, rebasing, code reviews, and release management
• Master Data - Experience designing Master Data Management solutions, reference data structures, crosswalk tables, source-to-target mapping strategies
• Data Modeling - Strong expertise in dimensional modeling, natural and surrogate key strategies, referential integrity, uniqueness enforcement, and scalable schema design
• Azure Data Factory (ADF)
• Databricks
• dbt
• Python
• Azure Cloud Services
• CI/CD implementation experience
• Agile/Scrum delivery methodology
• Experience in Healthcare Analytics and Reporting
• Team leadership and mentoring experience