Data Engineer - Optum Advisory Board - Remote

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.

Apply tot his job

Apply To this Job