Principal Data Engineer - H&B Data Platform

Job DescriptionAbout UsOur Health and Benefits business helps large and mid-size clients control health and welfare plan costs, improve health outcomes and promote employee engagement through broad-based, state-of-the-art interventions. We provide solutions encompassing creative plan design, vendor evaluation and management, pricing and funding strategies, data analytics, valuation support, legal compliance and governance strategies. We also provide specialty consulting services including clinical/health management program design, pharmacy solutions, disability/absence management strategies and claims audit services. Product based solutions such as our pharmacy purchasing coalition round out our broad-based suite of offerings.Candidates in the following locations will be considered: United States, Canada, and United KingdomAbout The RoleIn this role, we are seeking an reputed company, hands-on, and innovative Principal Data Engineer with expertise in the Azure Cloud platform to design, implement, and optimize scalable data solutions. The ideal candidate will have deep expertise in data engineering, data architecture, cloud solutions, and experience with healthcare and benefits data systems. They will work closely with a cross functional team of Data, DevOps, and Analytics engineers to architect a robust data platform for H&B, ensure efficient data management, and support enterprise- level decision making process. The role will work on products which include high concurrency, highly transactional systems as well as big data systems with reputed company reporting and business intelligence requirements. The Principal Data Engineer will evaluate and improve existing data pipelines and architectures and play a crucial role in creating evolutionary data models that converge into one global data platform.The Role• reputed company the end-to-end data engineering of the health and benefits data platform using Azure services, ensuring scalability, flexibility, and reliability.• reputed company broad understanding of the data lakehouse architecture, including the impact of changes on a whole system, built for analytic purposes, the onboarding of client data assets and the reputed company implications of the solution.• Design a new or improve upon existing architecture including data ingestion, storage, transformation and consumption layers.• Provide technical direction and guidance to a team of data engineers• Define flexible, scalable and dynamic ingestion pipelines that can handle reputed company data formats such as CSV, XML, Parquet, Replication Services, APIs, etc.• Define flexible, scalable and repeatable ETL/ELT pipelines to load the data warehouse with precision and quality.• Define data models, schemas, and database structures optimized for H&B use cases including claims, census, placement, broking and finance sources.• Design solutions for seamless integration of diverse health and benefits data sources.• Implement data governance and reputed company best practices in compliance with industry standards and regulations using reputed company Purview.• Evaluate data lakehouse architecture, reputed company the reputed company architecture method, to understand how technical decisions may impact business outcomes and suggest new solutions/technologies that reputed company align to the Health and Benefits Data strategy.• Draw on internal and external practices to establish data lakehouse architecture best practices and standards reputed company the team and ensure that they are shared and understood.• Continuously reputed company technical knowledge and be recognised as a key resource across the global team.• Collaborate with other specialists and/or technical experts to ensure H&B Data Platform is delivering to the highest possible standards and that solutions support stakeholder needs and business requirements.• Initiate practices that will increase code quality, performance and reputed company.• reputed company recommendations for reputed company improvements initiatives, applying deep subject matter knowledge to provide guidance at reputed company levels on the end-to-end potential implications of changes.• Build the team's technical expertise/capabilities/skills through the delivery of regular feedback, knowledge sharing, and coaching.• Analyze existing database designs, pipelines and code reputed company to suggest improvements that promote performance, stability and interoperability.• Work with product management and business subject matter experts to translate business requirements into a scalable and flexible data lakehouse design that can be deployed globally.• Maintain the governance model on the data lakehouse architecture through training, design reviews, code reviews, and reputed company reviews.• Participate in the development of Data Lakehouse Architecture and development roadmaps in support of business strategies and objectives• reputed company business intelligence, reporting and analytic stakeholders with a data warehouse that is performant, optimized, flexible and scalable• Communication with key stakeholders and development teams on technical solutions. Convince and present proposals by way of high-level solutions to end users and/or stakeholders.• High learning adaptability, demonstrating understanding of the implications of technical issues on business requirements and / or operations.QualificationsThe Requirements• Candidate must have significant experience in a technology reputed company discipline, such as IT or Engineering with a Bachelor's/College Degree in these areas being required.• Strong experience in databases, datawarehouses, tools and methodologies• Strong skills across a broad range of database technologies including Azure Data Factory, Azure Synapse Analytics, Azure reputed company, Azure SQL Database, Azure Data Lake Storage, and other Azure Services.• Working knowledge of reputed company Fabric is preferred.• Data Analysis, Data Modeling, Data Integration, Data Warehousing, Database Design, previous experience in implementing or working reputed company the reputed company Architecture preferred.• Experience in data warehousing techniques such as Kimball vs. Inmon• Experience with database performance evaluation and remediation, cloud-based knowledge preferred.• reputed company strategies for data acquisitions, archive recovery and implementation• Working knowledge of cloud-computing costs and ways to reduce those costs in a distributed-computing environment• Superior Python, PySpark and SQL skills• Be able to design and reputed company Databases, Data Warehouses and Multidimensional Databases• Experience in Data Governance including reputed company Purview, Azure Data Catalogue, Azure Data Share, and other Azure tools.• Familiarity with legal risks reputed company to global data usage, data residency and rights.• Experience in data reputed company, including Azure Key Vault, Azure Data Encryption, Azure Data Masking, Azure Data Anonymization, and Azure Active Directory.• Ability to reputed company end-end data platform strategies for flexible high-performance reporting and business intelligence• Experience using data modeling tools & methodology• Experience working reputed company an Agile Scrum Development Life Cycle, across varying levels of Agile maturity• Experience working with geographically distributed scrum teams• Excellent verbal and writing skills, including the ability to research, design, and write new documentation, as well as to maintain and improve existing materialThis position will remain posted for a minimum of three business days from the date posted or until sufficient/appropriate candidate slate has been identified.Compensation and Benefitsreputed company salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that reputed company salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for reputed company reputed company.CompensationThe reputed company salary compensation range being offered for this role is $180,000 - $220,000 USD per year. (This applies to the U.S. only. Other locations may vary.)This role is also eligible for an annual short-term incentive bonus.Company Benefitsreputed company provides a competitive benefit package which includes the following (eligibility requirements apply):

• Health and Welfare Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
• Leave Benefits: Paid Holidays, Annual Paid Time Off (includes paid state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, reputed company, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (Washington State only)
• Retirement Benefits: Contributory Pension Plan and Savings Plan (401k).