Data Engineer - Optum Advisory Board - Remote

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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

At Advisory Board, part of Optum Insight, we've helped health care industry leaders work smarter and faster by providing provocative insights, data and analytics, and practical tools to support execution for over 40 years. Our core products include research and analytics membership, events, expert support, custom research, and sponsorship. Learn more about Advisory Board. The Quantitative Insights team powers the industry-leading data and analytics capabilities core to Advisory Board's value proposition.

In this position within Advisory Board's data team, you will design, develop, test, and deploy enterprise ready data pipelines and architectures to support the Advisory Board's data and analytics research technology projects, ranging from small enhancements to major new projects. You will develop scalable and maintainable ETL processes, ensure data quality/security, and collaborate with data scientists to optimize analytics infrastructure. The position will play a critical role in all data technology initiatives as we continue this amazing journey of modernizing and innovating our data and technology ecosystem in support of our new and exciting business transformation. Data solutions you build will power analytics tools used by providers across the country to improve efficiency and deliver better care.

You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

Primary Responsibilities:

• Pipeline Development: Design, build, and maintain scalable, reliable, and efficient ETL/ELT pipelines using AWS Glue, Python, and SQL. Automate manual processes and optimize PySpark jobs for big data
• Data Lake/Warehouse Management: Architect and manage data lakes (AWS S3), data warehouses (Redshift, S3 Tables) and relational databases (PostgreSQL, SQL Server). Use data modeling best practices to ensure data is accurate, accessible, and organized for efficient reporting and analysis
• Cloud Infrastructure: Utilize AWS services like ECS and Lambda for data ingestion and orchestration tasks, involving a variety of external systems (Kafka, Snowflake, Databricks, custom API, etc.)
• Data Quality & Security: Implement monitoring and troubleshooting measures to ensure data integrity and security, including IAM policies and CloudWatch logging
• Collaboration: Work closely with data scientists and analysts to understand healthcare data and business requirements, and support data-driven decision-making
• Analytics Development: Build data sets and dashboards, configure RLS and user permissions, and optimize dashboard performance on Amazon Quick Suite. Configure parameters for interop with web app embedding
• CI/CD: Leverage GitHub for version control, code review, and automated deployment of pipelines across environments

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.

Required Qualifications:

• 8+ years of solid experience in data engineering using Python or PySpark
• 5+ years of experience with AWS including Glue, Lambda, IAM, Redshift
• 3+ years developing and optimizing PySpark jobs with proven big data experience
• 3+ years of best practices in data analysis and modeling
• Experience optimizing the architecture for big data, query performance, ease of use, and data governance
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Experience working with Cloud technologies (AWS preferred)
• Proven solid expertise in SQL and data modelling with relational databases like SQL Server, Postgres etc.

Preferred Qualifications:

• Experience in Amazon Quick Suite developing datasets and dashboards with support for web app embeddings
• Understanding of health care claims data, including Medicare and commercial datasets
• Proven eagerness and willingness to learn new technologies
• Proven solid analytical, problem solving and decision-making skill
• Demonstrated depth of health care knowledge and expertise
• Proven written and oral communication skills

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

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer 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 us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $91,700 to $163,700 annually based on full-time employment. We comply with all minimum wage laws as applicable.

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.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.