Job Description
**Senior Data Analyst Role Summary:** We are seeking a highly skilled Senior Data Analyst to manage and manipulate complex data sources, create data pipelines, and develop data solutions to store large volumes of data.
Optum is a global organisation that delivers care, aided by technology to help millions of people live healthier lives. Our team is dedicated to improving health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best.
As a Senior Data Analyst, you will be responsible 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. You will work closely with BI developers, data scientists, analysts, and other stakeholders to support their data needs.
**Key Responsibilities:**
- Anticipate customer needs and proactively develop solutions to meet them.
- Serve as a key resource on complex and/or critical issues.
- Solve complex problems and develop innovative solutions.
- Perform complex conceptual analyses.
- Review work performed by others and provide recommendations for improvement.
- Forecast and plan resource requirements.
- Authorize deviations from standards.
- May lead functional or segment teams or projects.
- Provide explanations and information to others on the most complex issues.
- Motivate and inspire other team members.
- Create and maintain data pipelines.
- Create SQL Stored procedures and Functions to perform complex transformations.
- Understand data requirements and design optimal pipelines to fulfill use-cases.
- Create logical and physical data models to ensure data integrity is maintained.
- Code management, CI/CD pipeline creation and automation using GitHub and GIT Actions.
- Tune and optimize data processes.
- Design and build best-in-class processes to clean and standardize data.
- Code deployments to production environment, troubleshoot production data issues.
- Model big volume datasets to maximize performance for our Business Intelligence and Data Science Team.
**Required Qualifications:**
- 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 and BI Solutions.
- Excellent Knowledge of change data capture (CDC), ETL, ELT, SCD etc.
-
Hands-on experience on the following technologies:
- Writing complex SQL queries.
- Building ETL/ELT/data pipelines using SCD logic.
- 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 and GitHub.
- Exposure to DevOps methodology.
- Knowledge of Alteryx.
- Good understanding of Access control and Data masking.
**Preferred Qualifications:**
- 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, PowerBI 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 and GIT Actions.
- Experience developing data pipelines in Azure and Snowflake or other technologies.
At Optum, we believe everyone deserves the opportunity to live their healthiest life. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes.
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.