Senior Data Engineer

Mayo Clinic • Rochester, MN

21h • $141,024 - $204,526

About The Position

This analytics engineering role focuses on building Mayo Clinic’s IAM Data Fabric, a trusted source of identity data that supports the Identity and Access Management system. The Fabric consolidates identity, account, entitlement, access, ownership, and risk data from across the enterprise, supporting access certifications, audit evidence, lifecycle automation, and executive reporting.

The primary focus is the Fabric’s reporting and analytics layer: designing BigQuery data products and Power BI semantic models that provide actionable insight to IAM leadership, application owners, Information Security, and Audit. The engineer partners with Identity Management Program teams to understand their questions, model data to answer them, and establish reporting standards. The role may expand into ingestion pipelines and foundational platform components, so a willingness to learn ETL and platform engineering is required. The team uses Google Cloud, BigQuery, Dataform or dbt, Power BI, Cosmos DB, and AI coding assistants such as Claude and Codex.

More broadly, the position develops and deploys data pipelines, integrations, and transformations for analytics and machine learning applications. It requires maintaining knowledge of organizational solutions, coding languages, and tools, and exercising independent judgment. The engineer may provide consultative services to departments, divisions, and leadership committees. The role partners with product owners and Analytics and Machine Learning delivery teams to identify and retrieve data, conduct exploratory analysis, build and validate analytical models, visualize trends, and translate qualitative and quantitative assessments into actionable insights.

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

Requirements

• Bachelor’s degree in a relevant analytical or quantitative field and at least five years of professional or research experience in data visualization, data engineering, or analytical modeling techniques; or an Associate’s degree in a relevant field and at least seven years of such experience. In-depth business or practice knowledge may also be considered.
• At least five years of hands-on experience in analytics engineering, data engineering, or BI development.
• Expert-level SQL, including complex joins, window functions, CTEs, and performance tuning on large analytical datasets.
• Proficiency in Python for data transformation and automation.
• At least two years of production experience with Google BigQuery, including partitioning, clustering, cost or slot optimization, scheduled queries, and authorized views.
• Hands-on experience building and maintaining transformation pipelines with Dataform or dbt, including modular SQL models, dependency management, testing, documentation, and scheduled runs.
• Experience using Git-based source control and CI/CD for data assets.
• Working knowledge of GCP services, including IAM, Cloud Storage, Dataflow, Pub/Sub, and Managed Airflow.
• Experience building and maintaining Power BI reports and semantic models, including DAX, row-level security, and dataset refresh or gateway management.
• Experience creating governed, documented metric definitions that serve as a single source of truth for key KPIs.
• Demonstrated experience with dimensional modeling, data warehousing concepts, and data quality practices.
• Ability to translate ambiguous analytics and reporting requests into well-defined data products.
• Experience leading technical design reviews or establishing engineering and reporting standards for a team.

Nice To Haves

• Experience with a metrics or semantic layer tool such as Looker/LookML, dbt Semantic Layer/MetricFlow, or Dataform-based metric definitions, including Looker Studio alongside Power BI.
• Exposure to identity, security, or compliance datasets and governance requirements such as PHI/PII handling, HIPAA, and least-privilege access, or experience in healthcare or another regulated industry.
• Experience with NoSQL or document databases, particularly Azure Cosmos DB, including partition key design, RU consumption, and change feed.
• Experience with data observability and testing frameworks such as Great Expectations or Monte Carlo, beyond native Dataform/dbt tests.
• Hands-on experience with agentic AI workflows, MCP-based tool integrations, or building LLM-assisted data tooling.
• Familiarity with cross-cloud integration tools such as Azure Data Factory, Synapse, or Microsoft Fabric, and infrastructure-as-code such as Terraform for GCP and Azure.
• Familiarity with Agile/SAFe delivery and Azure DevOps or Jira.
• Certifications strongly encouraged: dbt Analytics Engineering Certification; Google Cloud Professional Data Engineer; Microsoft Certified: Fabric Analytics Engineer Associate (DP-600); Microsoft Certified: Power BI Data Analyst Associate (PL-300).

Responsibilities

• Build Mayo Clinic’s IAM Data Fabric, a trusted enterprise source of identity data.
• Design BigQuery data products and Power BI semantic models for reporting and analytics.
• Translate reporting needs from IAM leadership, application owners, Information Security, and Audit into data models and actionable insights.
• Establish reporting standards for the Identity Management Program.
• Develop and deploy data pipelines, integrations, and transformations for analytics and machine learning applications.
• Partner with product owners and Analytics and Machine Learning delivery teams to identify and retrieve data.
• Conduct exploratory analysis, transform data, identify and visualize trends, and build and validate analytical models.
• Translate qualitative and quantitative assessments into actionable insights.
• Maintain understanding of organizational solutions, coding languages, and tools.
• Provide consultative services to departments, divisions, and leadership committees as needed.

Benefits

• Multiple medical plan options.
• Dental coverage through Delta Dental or a reimbursement account for flexible coverage.
• Vision plan with a national network.
• HSA and FSAs for eligible expenses.
• Competitive retirement package.
• Competitive compensation and comprehensive benefit plans.
• Continuing education and advancement opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior