Senior Data Analyst
Optum is a global organisation 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.
About the Role:
In healthcare, evolution doesn’t just happen. It takes innovation, imagination, and a passion for solving problems in new and better ways. And innovation is taking place at a lightning-fast pace every day at Optum.
As the fastest growing part of the United Health Group family of businesses, we’re expanding our team in Ireland and creating excellent opportunities for those who want greater purpose and more impact in their work. We’ll provide the investment, support, and resources to advance your career. You’ll provide the talent, ambition, and drive.
As a Senior Data Analyst, you will be responsible for the management and manipulation of complex data sources and pipelines into our data platform along with other data applications, automation and innovation. The Senior Data Analyst is essential for creating specifications to bring data into a common structure, ensuring data quality and consistency, creating product specifications and models, developing data solutions to store large volumes of data. Work closely with BI developers, data scientists, analysts, and other stakeholders to support their data needs. In addition to having impact on a great team, you'll also discover the career opportunities you'd expect from an industry leader.
Working Schedule:
This is a full-time position with standard working hours of Monday to Friday. Your counterpart team is located in the United States, India and Ireland offices. While there is no requirement to work in shift hours, there might be an occasional call with US team which can require flexible working.
Careers with Optum offer flexible work arrangements and individuals who live and work in the Republic of Ireland will have the opportunity to split their monthly work hours between our Dublin or Letterkenny office and telecommuting from a home-based office in a hybrid work model.
Primary Responsibilities of the Senior Data Analyst:

• Anticipates customer needs and proactively develops solutions to meet them.
• Serves as a key resource on complex and/or critical issues.
• Solves complex problems and develops innovative solutions.
• Performs complex conceptual analyses.
• Reviews work performed by others and provides recommendations for improvement.
• Forecasts and plans resource requirements.
• Authorizes deviations from standards.
• May lead functional or segment teams or projects.
• Provides explanations and information to others on the most complex issues.
• Motivates and inspires other team members.
• Create & maintain data pipelines.
• Create SQL Stored procs and Functions to perform complex transformations.
• Understand data requirements and design optimal pipelines to fulfil the use-cases.
• Creating logical & physical data models to ensure data integrity is maintained.
• Code management, CI/CD pipeline creation & automation using Git Hub & GIT Actions.
• Tuning and optimizing data processes.
• Design and build best in class processes to clean and standardize data.
• Code Deployments to production environment, troubleshoot production data issues.
• Modelling of big volume datasets to maximize performance for our Business Intelligence & Data Science Team.

You will be rewarded and recognised 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 providing development for other roles you may be interested in.
Required Qualifications of the Senior Data Analyst:

• Computer Science bachelor's degree or similar.
• Strong proven industry experience as a Hands-on in Data Analytics.
• Excellent communication skills – Verbal and Written.
• Excellent knowledge of SQL.
• Excellent knowledge of Data warehousing & BI Solutions
• Excellent Knowledge of change data capture (CDC), ETL, ELT, SCD etc.
• Hands on experience on the following technologies:

o Writing complex SQL queries.
o Building ETL/ELT/data pipelines using SCD logic.
o Query analysis and optimization.

• Analytical and problem-solving experience applied to a Big Data datasets.
• Data warehousing principles, architecture and its implementation in large environments.
• Experience working in projects with agile/scrum methodologies and high performing team(s).
• Knowledge of different data modelling techniques such as Star Schema, Dimensional models, Data vault is an Advantage.
• Experience in code lifecycle management and repositories such as GIT & Git Hub.
• Exposure to Dev Ops methodology.
• Knowledge of Alteryx
• Good understanding of Access control and Data masking.

Preferred Qualifications of the Senior Data Analyst:

• Knowledge of Azure Services such as – Blobs, Functions, Azure Data Factory, Service Principal, Containers, Key Vault, etc.
• Knowledge of Snowflake - Architecture, Features, Best practices.
• Knowledge and experience on Terraform, CI CD Pipelines and automation is an advantage
• Automation and orchestration using ADF
• Create real-time analytics pipelines using Snowpipe Streaming
• Experience developing optimized data models for Viz tool E.g. Tableau, Power BI is an Advantage
• Exposure and experience in other programming language such as Python, Spark etc. is an advantage
• Hands-on experience of CI CD Pipelines using GIT & GIT Actions
• Experience developing data pipelines in Azure & Snowflake or other technologies.

Please note you must currently be eligible to work and remain indefinitely without any restrictions in the country to which you are making an application. Proof will be required to support your application.
All telecommuters will be required to adhere to the United Health Group’s Telecommuter Policy.
At United Health 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 marginalised 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: Optum is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to gender, civil status, family status, sexual orientation, disability, religion, age, race, and membership of the Traveller community, or any other characteristic protected by law. Optum is a drug-free workplace. © 2024 Optum Services (Ireland) Limited. All rights reserved.
#RPO