UNITE HERE HEALTH serves 190,000+ workers and their families in the hospitality and gaming industry nationwide. Our desire to be innovative and progressive drives us to develop impactful programs and benefits designed to engage our participants in managing their own health and healthcare. Our vision is exciting and challenging. Please read on to learn more about this great opportunity!
The Senior Data Engineer II will work with the Analytics and data engineering team to build a scalable data delivery platform to drive the use and adoption of a distributed data technology using a Cloud environment. The Sr Data Engineer will help deploy distributed technologies, automate technologies, upgrade paths, and monitor production implementation of healthcare data platform. The position is responsible for defining, developing and maintaining the modernization of data architecture, ETL processes, and data platform and solutions.
ESSENTIAL JOB FUNCTIONS AND DUTIES
- Drives research, design, and development of a secure, resilient, and self-healing data architecture foundation, including data warehouse/mart, data integration pipelines, and data-specific software components.
- Works alongside the Principal Data Architect to define and implement best practices, standards, and processes for development, analysis, testing, and tuning of big data solutions.
- Leads the creation, maintenance, and optimization of ELT data pipelines from development to production.
- Develops and enforces data integration and data quality standards across all development initiatives, adhering to the organization’s information services policies and best practices.
- Executes and oversees the analysis and remediation of root causes, including technological, procedural, or resource capability deficiencies.
- Operates in an agile model alongside architects, data engineers, data scientists, data analysts, business partners, and other developers in the delivery of data solutions.
- Provides technical guidance and mentorship to less experienced Data Engineers, fostering a culture of education and skill development.
- Introduces and helps to understand new technologies to solve business problems, creating relevant prototypes where appropriate.
- Design, build, and maintain modern cloud-based data platforms using technologies such as AWS, GCP, or Azure.
- Ensures the ethical use, safety, and privacy of UHH and customer/patient data.
- Maintains and enhances Data Warehouse ETL, management, data quality and analytics processes.
- Interfaces with users and management regarding requirements, testing, and implementation
ESSENTIAL QUALIFICATIONS
- 5 ~ 7 years of direct data engineering experience, ideally with healthcare benefits management organization.
- Experience doing development work involving medical claims, pharmacy claims, and eligibility data
- Demonstrated experience with a variety of relational and NoSQL technologies (e.g., Azure SQL Server, PostgreSQL, Cosmos DB).
- Experience in a cloud platform (preferably Azure) and its related technical stack (e.g., Azure Data Factory, Synapse, dbt, Fivetran, Snowflake, Databricks, dremio, Airflow, NiFi).
- Extensive Azure Data Technology design and implementation experience: ADF, Azure SQL, Azure Data Bricks, Azure Analysis Services, Data Lakes and Power BI
- Strong technical understanding of data modeling, data mining, master data management, data integration, data architecture, data virtualization, data warehousing, and data quality techniques.
- Strong knowledge in SQL, modern programming languages (e.g., Python, R), and common data pipeline/data science libraries.
- Experience with Git repositories, CI/CD (preferably Azure DevOps), and software development tools, including incident tracking, version control, release management, and testing tools.
- Experience working with data governance and data security – specifically in moving data pipelines into production with appropriate data quality, governance, and security standards, and certification.
- Experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
- In-depth understanding of Data Warehouse/ODS, ETL concept and modelling structure principles, Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modelling.
- Experience with Healthcare EDI transactions (837, 835, etc.) and/or Lab Data is strongly preferred
- Bachelor's degree in Computer Science or related field or equivalent work experience required
Salary range for this position: Salary $100,800 - $131,000. Actual base salary may vary based upon, but not limited to: relevant experience, qualifications, expertise, certifications, licenses, education or equivalent work experience, time in role, peer and market data, prior performance, business sector, and geographic location.
Work Schedule (may vary to meet business needs): Monday~Friday, 7.5 hours per day (37.5 hours per week) with potential for hybrid work-from-home arrangement.
We reward great work with great benefits, including but not limited to: Medical, Dental, Vision, Paid Time-Off (PTO), Paid Holidays, 401(k), Pension, Short- & Long-term Disability, Life, AD&D, Flexible Spending Accounts (healthcare & dependent care), Commuter Transit, Tuition Assistance, and Employee Assistance Program (EAP).
#LI-Remote
