Software Engineering Lead – Power BI, Snowflake, SSIS, Azure, T-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 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.

Primary Responsibilities:

• Design, develop, and maintain Power BI semantic models and reports to provide data insights and visualizations for business users, utilizing Snowflake and Azure Data Warehouse as primary data sources
• 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 – 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
• Design, develop and maintain business intelligence solutions crafting and executing queries upon request for data
• Collaborate with stakeholders to gather and understand requirements, and translate them into technical specifications and data models
• Build and maintain data pipelines using Azure Data Factory (ADF) for data extraction, transformation, and loading (ETL) processes
• Develop and implement data integration solutions leveraging Azure Cloud, Snowflake, and Azure Data Warehouse technologies
• Utilize Python and other programming languages for data manipulation, transformation, and analysis.
• Utilize Databricks for data engineering and advanced analytics tasks
• Ensure data quality and accuracy through data validation and testing methodologies
• Troubleshoot and resolve data-related issues, performance bottlenecks, and system errors
• Stay up-to-date with the latest trends and advancements in data engineering, Power BI, Snowflake, and Azure Cloud technologies
• Collaborate with cross-functional teams, including data scientists, business analysts, and software developers, to deliver end-to-end data solutions
• 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

Required Qualifications:

• Bachelor’s degree in Computer Science, Data Engineering, or a related field
• 8+ years of experience in data engineering roles, with a focus on Power BI, Snowflake, Azure Data Warehouse, and Azure Cloud technologies
• 5+ years of hands-on experience with Power BI including modeling, solid knowledge and hands-on experience with Power BI semantic model creation, report development, and data visualization, using Snowflake and Azure Data Warehouse as primary data sources
• Experience with ETL processes and data integration using Azure Data Factory
• Proficiency in Azure Cloud services, including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Storage, and Azure Analytics
• Solid programming skills in Python, SQL, and other scripting languages
• Familiarity with Databricks for data engineering, advanced analytics, and machine learning tasks
• Understanding of data modeling concepts and relational database systems, with expertise in Snowflake and Azure Data Warehouse
• Proven excellent problem-solving skills and ability to troubleshoot and resolve complex data-related issues
• Solid communication and collaboration skills to work effectively with cross-functional teams
• Ability to adapt to changing priorities and manage multiple tasks simultaneously
• Near real-time data processing, or PBI hybrid table for real-time data
• Solid problem-solving skills, attention to detail, and demonstrated ability to manage multiple tasks and projects simultaneously
• Proven excellent verbal and written communication skills.

Preferred Qualification:

• Microsoft certifications in Power BI, Azure Cloud, Snowflake, or related fields

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.