Data Analyst - Power BI, DAX

Overview

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.

The Business Intelligence Developer will play a key role in transforming data into meaningful insights that drive operational excellence. This role is responsible for designing, developing, testing and deploying data solutions that support business leaders and workforce management analysts. Primarily leveraging tools such as Fabric, PowerBI, DAX, and SQL the developer will own the end-to-end data analytics lifecycle -- from requirements gathering and data acquisition to modeling, visualization, deployment and stakeholder communication -- ensuring solutions are aligned with business goals and deliver measurable impact. The individual will collaborate across teams to maintain and enhance existing data pipelines, ensuring SLA adherence and data reliability. The role also involves innovating new data solutions, introducing new metrics and reporting frameworks to evolve our analytical offerings and improve our ability to deliver timely, accurate and actionable outcomes.

Primary Responsibilities

• Collaborate with stakeholders to assess and interpret business needs; translating data business requirements into technical specifications and functional design documents
• Build and maintain scalable, reusable semantic data models using PowerBI, DAX, Power Query (M) that ensure data integrity, security, performance and quality
• Develop, distribute and maintain scalable PowerBI reports and dashboards that ensure data integrity, security, performance, and quality
• Create and optimize queries for ETL/ELT processes, integrating data from multiple sources such as Azure Data Lake, SQL Server, Snowflake, Databricks, Excel and APIs
• Conduct peer code reviews and generate test scripts to validate data accuracy, report functionality and performance across reporting solutions
• Monitor and maintain existing data pipelines to ensure SLA adherence and data reliability
• Own and triage reporting and data-related issues by investigating root cause, resolving defects, communicating status updates to stakeholders and documenting solutions in knowledgebase
• Create new visualizations, KPIs and reporting frameworks to expand analytical capabilities
• Respond to and fulfill ad-hoc data reporting requests, ensuring timely delivery of accurate and relevant data to support urgent business needs
• Perform explanatory data analysis and data-driven recommendations to business stakeholders to uncover trends, anomalies and opportunities for operational improvement, process enhancements and strategic decisions
• Document data sources, report logic and development processes for transparency and maintainability
• Stay current with PowerBI and Fabric updates and best practices, applying new features to improve performance and reporting capabilities
• Contribute to continuous improvement efforts by identifying opportunities to streamline reporting workflows and enhance user experience
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
  
  

• 4+ years of experience in Advanced SQL skills for querying and transforming data from structured and semi-structured data sources
• 2+ years of proficiency in PowerBI Desktop and Service - including report creation, dashboard design, data governance, security, and workspace management and performance optimization
• 2+ years of proficiency in DAX and Power Query (M) for building calculated columns, measures and transforming data within PowerBI and Excel
• Experience designing and maintaining ELT/ELT pipelines using tools such as Azure Data Factory, SSIS or Databricks leveraging structured and semi-structured data
• Experience creating technical documentation and business-facing user guides
• Solid knowledge of industry best practices and emerging trends in in PowerBI, Microsoft Fabric and the broader analytics ecosystem with experience applying new features and techniques to improve performance, scalability and user experience
• Familiarity with CI/CD practices for BI assets, including version control (e.g. Git, PowerBI Deployment Pipelines, or similar), automated testing and deployment workflows with tools like Git, ALM ToolKit, PowerBI Deployment Pipelines or similar
• Proven solid attention to detail with experience in complex problem solving, technical troubleshooting, and analyzing process improvements
• Proven ability to collaborate effectively across teams with solid interpersonal communication (written and verbal), stakeholder engagement, and relationship-building skills
  
  

• 5+ years experience with PowerBI, including advanced DAX, M code and performance optimization
• 2+ years experience with scripting languages such as Python, R, Scala for data manipulation, automation, or advanced analytics
• Experience using ALM Toolkit for PowerBI model comparison, deployment and version control
• Experience with agile frameworks and analytics development lifecycles, including use of tools like Jira, Rally, or similar
• Familiarity with a workforce management tools (e.g., NICE IEX, Aspect, Verint, etc.) or experience supporting call center or IT helpdesk environments
• Microsoft Certified: Azure data Fundamentals (DP-900), PowerBI Data Analyst Associate (PL-300) or Fabric Analytics Associate (DP-600)