Find Your Dream Job Today

Our mission is to help high-achieving LGBTQ+ undergraduates reach their full potential.

BI & Analytics Engineer - Remote - 2231122

UnitedHealth Group

UnitedHealth Group

Data Science
Eden Prairie, MN, USA
Posted on Sunday, June 9, 2024

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.

We are seeking a highly motivated BI /analytics Engineer to join our Optum team. The successful candidate will have strong experience in developing, maintaining, and managing advanced reporting, analytics, dashboards, and other BI solutions. The candidate must possess in-depth knowledge of Power BI, with a track record of utilizing all its facets including modeling, calculated columns, measures, security, and application integration. Experience working with Fabric capacity Lakehouse/Direct Lake, and various data sources such as ADLS, Snowflake, and other big data sources is required.

The BI & Analytics Engineer will help create new Reports and Dashboards, has an understanding of data, IT analysis and organization and the ability to understand the technical manifestation of business concepts, especially related to payer operation, reporting and analytics.

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

Primary Responsibilities:

  • Analyze current business practices, processes and procedures and identify future business opportunities for leveraging data storage and retrieval system capabilities
  • Extract, analyze, aggregate, and interpret data with In-depth knowledge of ETL, OLAP and OLTP concepts
  • Perform quantitative analysis on healthcare operational data (Claim, Eligibility etc.)
  • Develop, review, and analyze detailed data sets leveraged for client reporting/analytics. Using Warehouse data, generate reports to support business decision-making and business performance monitoring
  • Quality Assurance, ensuring strict data quality• Design, develop and maintain business intelligence solutions crafting and executing queries upon request for data.
  • Translate business needs to technical specifications and build high-quality BI applications to meet these needs.
  • Present information through reports and visualizations via ( Power BI preferably) – effective in data storytelling.
  • Integrate BI solutions with Azure services including but not limited to ADLS, Snowflake, and other RDBMS and Big Data sources.
  • Design, develop, and test BI solutions such as reports, dashboards, and ad hoc data explorations.
  • Enforce data security and compliance with all relevant regulations and best practices.
  • Define models for the following: star schema, composite, hybrid, and aggregate
  • Assist with transitioning existing reports to modern data platforms
  • Build dashboards and reports from scratch and also repoint them to newer data sources
  • Follow Agile software development lifecycle

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:

  • 5+ years of experience in the field of Data Analysis, ETL, Reporting, Business Intelligence including source data analysis, profiling, and reporting
  • 5+ years of experience in design, development and/or implementation of sizeable BI/Analytics solutions for healthcare analytics
  • 5+ years of experience in writing SQL queries
  • 3+ years of experience with migrating reports and ETLs (Preferably to Power BI / MicroStrategy/ SAS ) from legacy databases like Hive, Oracle to Snowflake
  • 3+ years of experience in Snowflake
  • Solid hands-on and in-depth understanding on DWH/BI/Analytics concepts and proficient in Data Visualization
  • Able to study, analyze and understand business requirements in context to business intelligence
  • Power BI
    • 5+ years of hands-on experience with Power BI including modeling, calculated columns, measures, DAX, M/PB Power Query transformations, security, and integration
    • Proven experience working with Fabric OneLake Lakehouse/Direct Lake, data storage and databases such as ADLS, Snowflake, and other Big Data sources
    • Near real-time data processing, or PBI hybrid table for real-time data
    • Experience with Power BI Security techniques. This is a healthcare customer and security integral to the success of this initiative
    • Experience with Power BI Embedded and PBI QnA

Preferred Qualifications:

  • 1+ years of exposure to Python and /or Azure machine learning
  • Experience with HIPAA Compliance

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

California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, or Washington Residents Only: The salary range for this role is $88,000 to $173,200 annually. 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.

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

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