Data Analyst - SSIS, Power BI, SQL

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 regard 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

Required Qualifications :

Preferred Qualifications :

Skills Required

Powerbi, Dax, Developing, Visualization