Azure Data Engineer

Optum; Austin (TX); Remote; USD 71,000 - 120,000; Full time

Job summary

A leading healthcare organization is seeking a Data Engineer to support the full data engineering lifecycle. This role involves designing, developing, and maintaining data management solutions, ensuring data quality, and collaborating with analytics teams. The ideal candidate will have extensive experience in data engineering, particularly with Azure technologies, and a strong background in healthcare data.

Benefits

Comprehensive benefits package

Incentive and recognition programs

401k contribution

Qualifications

• 5+ years of combined experience in data engineering.
• 5+ years of experience with relational and non-relational data storage systems.
• 3+ years of experience using Azure cloud.

Responsibilities

• Support the full data engineering lifecycle including design, development, testing, and maintenance.
• Lead data acquisition efforts to gather data from various source systems.
• Implement and maintain data integration efforts that improve data efficiency.

Skills

Data Engineering

ETL/ELT

Data Quality

Data Management

Data Integration

Data Transformation

Analytics

Data Pipeline Monitoring

Education

Bachelor's Degree in Information Technology, Engineering, Math, Computer Science, or related field

Tools

Azure Databricks

Azure Data Factory

Synapse Analytics

Airflow

SSIS

SQL

Python

PySpark

Job description

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.



You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges.



Primary Responsibilities:

• Support the full data engineering lifecycle including research, proof of concepts, design, development, testing, deployment, and maintenance of data management solutions


• Utilize knowledge of various data management technologies to drive data engineering projects


• Lead data acquisition efforts to gather data from various structured or semi-structured source systems of record to hydrate client data warehouse and power analytics across numerous health care domains


• Leverage combination of ETL/ELT methodologies to pull complex relational and dimensional data to support loading DataMart's and reporting aggregates


• Eliminate unwarranted complexity and unneeded interdependencies


• Detect data quality issues, identify root causes, implement fixes, and manage data audits to mitigate data challenges


• Implement, modify, and maintain data integration efforts that improve data efficiency, reliability, and value


• Leverage and facilitate the evolution of best practices for data acquisition, transformation, storage, and aggregation that solve current challenges and reduce the risk of future challenges


• Effectively create data transformations that address business requirements and other constraints


• Partner with the broader analytics organization to make recommendations for changes to data systems and the architecture of data platforms


• Support the implementation of a modern data framework that facilitates business intelligence reporting and advanced analytics


• Prepare high level design documents and detailed technical design documents with best practices to enable efficient data ingestion, transformation and data movement


• Leverage DevOps tools to enable code versioning and code deployment


• Leverage data pipeline monitoring tools to detect data integrity issues before they result into user visible outages or data quality issues


• Leverage processes and diagnostics tools to troubleshoot, maintain and optimize solutions and respond to customer and production issues


• Continuously support technical debt reduction, process transformation, and overall optimization


• Leverage and contribute to the evolution of standards for high quality documentation of data definitions, transformations, and processes to ensure data transparency, governance, and security


• Ensure that all solutions meet the business needs and requirements for security, scalability, and reliability

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Qualifications - External

Required Qualifications:

• Bachelor's Degree (preferably in information technology, engineering, math, computer science, analytics, engineering or other related field)


• 5+ years of combined experience in data engineering


• 5+ years of combined experience working with industry standard relational, dimensional or non-relational data storage systems


• 5+ years of experience in designing ETL / ELT solutions using tools like Azure Databricks, Synapse Analytics, Azure Data Factory, Airflow and SSIS


• 3+ years of experience using Azure cloud


• 3+ years of experience in managing data assets using PySpark, SQL and Python querying/coding language


• 1+ years of experience working with healthcare data or data to support healthcare organizations

Preferred Qualifications:

• Experience working with Health Catalyst product offerings, including data warehousing solutions, knowledgebase, and analytics solutions


• Experience in creating Source to Target Mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts


• Depth of experience and proven track record creating and maintaining sophisticated data frameworks for healthcare organizations


• Experience supporting data pipelines that power analytical content within common reporting and business intelligence platforms (e.g. Power BI, Tableau, etc.)


• Experience supporting analytical capabilities inclusive of reporting, dashboards, extracts, BI tools, analytical web applications and other similar products


• Experience contributing to cross-functional efforts with proven success in creating healthcare insights


• Experience and credibility interacting with analytics and technology leadership teams


• Exposure to Azure, AWS, or google cloud ecosystems


• Exposure to Azure Databricks, Synapse Analytics, Data Factory, ADLS v2, Blob and Airflow


• Proven desire to continuously learn and seek new options and approaches to business challenges


• Proven willingness to leverage best practices, share knowledge, and improve the collective work of the team


• Proven ability to effectively communicate concepts verbally and in writing


• Willingness to support limited travel up to 10%

*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy



The salary range for this role is $71,600 to $120,000 annually based on full-time employment. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.



Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.



At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.





UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.