Senior Analytics Engineer,
Indexed description
As part of a fast-paced innovation and incubation team, you will have the opportunity to work on some of the most challenging and ambiguous data problems in the organisation, helping shape future products and capabilities before they enter formal delivery.
We are seeking an experienced Senior Analytics Engineer who combines solid technical engineering capabilities with an investigative, hypothesis-driven analytical mindset. This role is ideal for someone who enjoys exploring complex datasets, identifying patterns and anomalies, validating business assumptions and transforming raw data into actionable insights. Rather than focusing solely on building production pipelines, this role sits earlier in the product lifecycle where experimentation, discovery and rapid iteration are critical to success.
You will work closely with business stakeholders, product teams, data analysts and engineering teams to evaluate new opportunities, assess feasibility and translate ambiguous requirements into evidence-based recommendations.
The successful candidate will leverage Databricks, SQL and Python to perform exploratory analysis across large and disparate enterprise datasets, producing reusable notebooks, visualisations and supporting artefacts that inform product direction and feature development.
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.
What You Will Do
Data Exploration & Analysis
- Investigate large, complex and often disparate data sources to uncover trends, patterns and business opportunities
- Perform data profiling, validation and quality assessment activities
- Clean, transform and prepare datasets for exploratory and analytical use
- Identify data anomalies, inconsistencies and potential business risks
- Validate assumptions and challenge hypotheses using data-driven evidence
- Map data flow across multiple layers of the application and across separate systems
- Apply an iterative test, learn and refine approach to problem solving
- Design and execute exploratory analyses to support product discovery and innovation initiatives
- Develop proof-of-concepts and analytical experiments that inform business decisions
- Translate ambiguous business questions into analytical approaches and measurable outcomes
- Support feasibility assessments for new products, features and strategic initiatives
- Partner with business analysts, product managers and subject matter experts during the ideation phase of initiatives
- Facilitate conversations that help clarify requirements, assumptions and success criteria
- Present analytical findings in a manner suitable for both technical and non-technical audiences
- Provide clear recommendations supported by quantitative evidence
- Develop maintainable SQL and Python notebooks within the Databricks ecosystem
- Create reusable analytical assets and accelerators
- Contribute to creation of semantic layer for AI enablement
- Leverage version control and engineering best practices to manage analytical code
- Contribute to the evolution of analytical and data engineering standards
- Support the transition of validated concepts and requirements into downstream engineering delivery teams
- Produce well-structured notebooks that combine code, narrative explanations, assumptions, findings and recommendations
- Create visualisations and analytical artefacts that can be consumed as part of intake and feature definition processes
- Generate documentation suitable for solution design, planning and implementation teams
- Support creation of intake-ready analytical artefacts that complement business requirements and Aha! feature submissions
What You Will Bring
- Bachelor's degree in Computer Science, Data Science, Engineering, Mathematics, Statistics, or a related discipline, or equivalent professional experience
- Proven extensive experience in Analytics Engineering, Data Engineering, Data Analysis, or a related discipline
- Proven experience working with enterprise-scale data warehouses, data marts, and analytical platforms
- Demonstrated advanced SQL expertise, including complex joins, window functions, aggregation strategies, and query optimization
- Demonstrated ability to utilize GitHub Actions and version control repositories
- Demonstrated solid Python proficiency, including experience using notebook-based development environments
- Proven experience working within the Databricks ecosystem
- Proven experience analyzing large and complex datasets from multiple source systems
- Proven ability to work independently with ambiguous or incomplete requirements
- Demonstrated solid verbal and written communication skills
- Proven ability to explain complex technical concepts to business stakeholders
- Proven experience with Databricks Lakehouse Architecture, Delta Lake, and Unity Catalog
- Proven experience building semantic models or semantic layers
- Demonstrated familiarity with healthcare, insurance, or other highly regulated industries
- Demonstrated experience with data quality assessment and observability concepts
- Demonstrated knowledge of data modeling principles and analytical data structures
- Proven experience with Git, version control workflows, and collaborative development practices
- Demonstrated familiarity with business intelligence and data visualization tools such as Power BI
- Demonstrated exposure to machine learning, statistical analysis, or experimentation frameworks
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search