Data Analyst - SSIS, Power BI, SQL

Other Jobs To Apply

<p><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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 <strong>Caring. Connecting. Growing together.</strong></span></p><p> </p><p><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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.</span></p><p> </p><p><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><strong>Primary Responsibilities:</strong></span></p><ul><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Collaborate with stakeholders to assess and interpret business needs; translating data business requirements into technical specifications and functional design documents</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Build and maintain scalable, reusable semantic data models using PowerBI, DAX, Power Query (M) that ensure data integrity, security, performance and quality</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Develop, distribute and maintain scalable PowerBI reports and dashboards that ensure data integrity, security, performance, and quality</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Conduct peer code reviews and generate test scripts to validate data accuracy, report functionality and performance across reporting solutions</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Monitor and maintain existing data pipelines to ensure SLA adherence and data reliability</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Own and triage reporting and data-related issues by investigating root cause, resolving defects, communicating status updates to stakeholders and documenting solutions in knowledgebase</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Create new visualizations, KPIs and reporting frameworks to expand analytical capabilities</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Respond to and fulfill ad-hoc data reporting requests, ensuring timely delivery of accurate and relevant data to support urgent business needs</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Document data sources, report logic and development processes for transparency and maintainability</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Stay current with PowerBI and Fabric updates and best practices, applying new features to improve performance and reporting capabilities</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Contribute to continuous improvement efforts by identifying opportunities to streamline reporting workflows and enhance user experience</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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<o:p></o:p></span></li></ul><p class="MsoListParagraphCxSpLast"><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><o:p></o:p></span></p><br><br><p><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><strong>Required Qualifications:</strong></span></p><ul><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Advanced SQL skills for querying and transforming data from structured and semi-structured data sources (4+ years)</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Proficiency in PowerBI Desktop and Service - including report creation, dashboard design, data governance, security, and workspace management and performance optimization (2+ years)</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Proficiency in DAX and Power Query (M) for building calculated columns, measures and transforming data within PowerBI and Excel (2+ years)</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Experience designing and maintaining ELT/ELT pipelines using tools such as Azure Data Factory, SSIS or Databricks leveraging structured and semi-structured data</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Experience creating technical documentation and business-facing user guides</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Solid attention to detail with experience in complex problem solving, technical troubleshooting, and analyzing process improvements</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Proven ability to collaborate effectively across teams with solid interpersonal communication (written and verbal), stakeholder engagement, and relationship-building skills</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">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</span></li></ul><p> </p><p><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><strong>Preferred Qualifications:</strong></span></p><ul><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">5+ years experience with PowerBI, including advanced DAX, M code and performance optimization</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">2+ years experience with scripting languages such as Python, R, Scala for data manipulation, automation, or advanced analytics</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Microsoft Certified: Azure data Fundamentals (DP-900), PowerBI Data Analyst Associate (PL-300) or Fabric Analytics Associate (DP-600)</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Familiarity with a workforce management tools (e.g., NICE IEX, Aspect, Verint, etc.) or experience supporting call center or IT helpdesk environments</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Experience using ALM Toolkit for PowerBI model comparison, deployment and version control</span></li><li><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;">Experience with agile frameworks and analytics development lifecycles, including use of tools like Jira, Rally, or similar</span></li></ul><p> </p><p style="text-align:center;"><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><i>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.</i><o:p></o:p></span></p><p class="MsoListParagraphCxSpMiddle"><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><o:p></o:p></span></p><p class="MsoListParagraphCxSpLast"><span style="font-family:Tahoma, Geneva, sans-serif;font-size:10px;"><o:p></o:p></span></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...