{bc}
Apply
oracle

Senior Data Engineer

Mayo Clinic
Rochester, USA
Full-time
Senior · 5+ years experience
Onsite
Discovered 4 days ago
airflowazureazure-data-factorybigquerydbtgcp

Full Job Posting

Qualifications

  • A Bachelor's degree in a relevant field such as engineering, mathematics, computer science, information technology, health science, or other analytical/quantitative field and a minimum of five years of professional or research experience in data visualization, data engineering, analytical modeling techniques; OR an Associate’s degree in a relevant field such as engineering, mathematics, computer science, information technology, health science, or other analytical/quantitative field and a minimum of seven years of professional or research experience in data visualization, data engineering, analytical modeling techniques. In-depth business or practice knowledge will also be considered.
  • 5+ 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.
  • 2+ years of production experience with Google BigQuery (partitioning, clustering, cost/slot optimization, scheduled queries, authorized views)
  • Hands-on experience building and maintaining transformation pipelines with Dataform or dbt (modular SQL models, dependency management, testing, documentation, and scheduled runs) using Git-based source control and CI/CD for data assets.
  • Working knowledge of GCP services (IAM, Cloud Storage, Dataflow, Pub/Sub, Managed Airflow).
  • Experience building and maintaining Power BI reports and semantic models, including DAX, row-level security, and dataset refresh/gateway management, with governed, documented metric definitions that serve as a single source of truth for key KPIs
  • Demonstrated experience applying dimensional modeling, data warehousing concepts, and data quality practices.
  • Demonstrated ability to translate ambiguous analytic and reporting requests into well-defined data products
  • Experience leading technical design reviews or establishing engineering and reporting standards for a team.

Preferred Qualifications

  • Experience with a metrics or semantic layer tool (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 their governance requirements (PHI/PII handling, HIPAA, least-privilege access), or experience in healthcare or another regulated industry
  • Experience with NoSQL/document databases, particularly Azure Cosmos DB (partition key design, RU consumption, change feed)
  • Experience with data observability and testing frameworks (Great Expectations, Monte Carlo, or similar) 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 (Azure Data Factory, Synapse, or Microsoft Fabric) and infrastructure-as-code (Terraform) for GCP and Azure
  • Familiarity with Agile/SAFe delivery, 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)

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Mayo Clinic

Dietitian

Mankato, USA

Discovered TodayFull-time

Patient Appointment Coordinator

Jacksonville, USA

Discovered TodayFull-time

Outpatient Registered Dietitian – Integrative Medicine and Health

Jacksonville, USA

Discovered TodayFull-time

Health Unit Coordinator - HUC

Mankato, USA

Discovered TodayPart-time

Histotechnologist - Histology Lab - FLA

Jacksonville, USA

Discovered TodayFull-time

Graduate Research Appointment - supplemental Neurology - Remote - Limited Tenure

Rochester, USA

Discovered TodayPart-time

Cardiovascular Technologist - EP Lab, PRN - CV Tech

Jacksonville, USA

Discovered TodayPart-time

Registered Nurse - Emergency Department, Part-Time - RN

Jacksonville, USA

Discovered TodayPart-time