Senior Data Engineer

Mayo Clinic; Rochester (MN); Sur place; USD 120 000 - 150 000; Plein temps

Résumé du poste

Mayo Clinic is seeking a Senior Data Engineer to join the Analytics Engineering team. You will focus on the Fabric’s reporting and analytics layer, building BigQuery data products and Power BI semantic models to turn identity data into actionable insights for IAM leadership, application owners, security, and audit.

You will work with Google Cloud, Dataform/dbt, and BI tools on a small senior team, charting how data moves from source to report, while expanding into ingestion pipelines and

Qualifications

• Experience designing data products for analytics and reporting.
• Ability to model identity and access data across enterprise.
• Familiarity with ETL processes and cloud data platforms.

Responsabilités

• Develop and deploy data pipelines and analytics models for IAM.
• Collaborate with cross‑functional teams to translate questions into data solutions.
• Build reporting standards and BI semantic models for leadership and audit.

Connaissances

Data modeling

Analytical thinking

Team collaboration

Outils

BigQuery

Power BI

Dataform

dbt

Google Cloud

Cosmos DB

Python

SQL

Description du poste

This is an Analytics Engineering role that will join the team as a Senior Data Engineer focused on building Mayo Clinic’s IAM Data Fabric, a single, trusted source of identity data that the rest of our Identity and Access Management system is built upon. The Fabric brings identity, account, entitlement, access, ownership, and risk data from across the enterprise into one place, giving Mayo Clinic a comprehensive view of who has access to what, how it was granted, and where risk is concentrated. Access certifications, audit evidence, lifecycle automation, and executive reporting all depend on it.

In this role, your primary focus will be the Fabric’s reporting and analytics layer: designing BigQuery data products and Power BI semantic models that turn identity data into clear, actionable insight for IAM leadership, application owners, Information Security, and Audit. You will partner closely with teams across the Identity Management Program to understand their questions, model the data to answer them, and establish reporting standards the broader program can rely on. Over time, you will expand into the ingestion pipelines and foundational platform components that feed the Fabric, so curiosity about how data moves from source to report and a willingness to learn ETL and platform engineering will be required. You will work hands-on with Google Cloud, BigQuery, Dataform or dbt, Power BI, Cosmos DB and AI coding assistants such as Claude and Codex, on a small, senior team where your work directly shapes how Mayo Clinic understands and secures identity.

Develops and deploys data pipelines, integrations and transformations to support analytics and machine learning applications and solutions as part of an assigned product team using various open-source programming languages and vended software to meet the desired design functionality for products and programs. The position requires maintaining an understanding of the organization's current solutions, coding languages, tools, and regularly requires the application of independent judgment. May provide consultative services to departments/divisions and leadership committees. Demonstrated experience in designing, building, and installing data systems and how they are applied to the Department of Data & Analytics technology framework is required. Candidate will partner with product owners and Analytics and Machine Learning delivery teams to identify and retrieve data, conduct exploratory analysis, pipeline and transform data to help identify and visualize trends, build and validate analytical models, and translate qualitative and quantitative assessments into actionable insights.

This vacancy is not eligible for sponsorship/ we will not sponsor or transfer visas for this position. Also, Mayo Clinic DOES NOT participate in the F-1 STEM OPT extension program.