Principal Data Engineer

Mayo Clinic; Rochester (MN); On-site; USD 148,000 - 215,000; Full time

Benefits offered by this job

Medical plans and flexible coverage

Dental and vision plans

Pre-tax savings: HSA/FSAs

Competitive retirement package

Job summary

Mayo Clinic in Rochester, MN seeks a Principal Data Engineer to architect and optimize data platforms for clinical research and operations. You will lead the design of ETL pipelines, data models, and data delivery across interdisciplinary teams.

The role requires advanced knowledge of SQL, Python, cloud platforms (GCP/Azure), and Airflow, plus strong communication and leadership to guide projects.

Qualifications

• Master's degree in a relevant field and at least five years of data science experience.
• Strong leadership, communication, and project management skills.
• Demonstrated experience with data modeling and large-scale data delivery.

Responsibilities

• Design, implement, document, and test databases containing clinical data.
• Build ETL pipelines using cloud technologies such as Google Cloud or Microsoft Azure and Airflow.
• Collaborate with informaticists, clinicians, software engineers, and data scientists to ensure data quality and availability.
• Develop data architecture and optimize databases for reliability and scalability.
• Lead multiple projects, guide team members, and communicate with stakeholders across Mayo Clinic.

Skills

SQL

Python

ETL pipelines

Data modeling

Airflow

Cloud platforms (GCP/Azure)

Data architecture

Leadership

Communication

Education

Master's degree in engineering, mathematics, computer science, health science

PhD in CS/Engineering (preferred)

Tools

Google Cloud

Microsoft Azure

Apache Airflow

SQL

Python

Job description

Why Mayo Clinic

Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic.

Why Mayo Clinic

Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic.

Benefits Highlights

• Medical: Multiple plan options.
• Dental: Delta Dental or reimbursement account for flexible coverage.
• Vision: Affordable plan with national network.
• Pre-Tax Savings: HSA and FSAs for eligible expenses.
• Retirement: Competitive retirement package to secure your future.

Responsibilities

Principal Data Engineers at Mayo Clinic are expected to be subject matter experts in building ETL pipelines, working with heterogenous data using different technologies, and database design and optimizations. The data they work with are required to support a different analyses and applications that serve both internal and external partners. As the position requires strong data, technical, and functional skills, the right candidate must be able to understand business requirements, translate them into information needs, and implement those requirements using available data. The hire will be responsible for creating new data architecture, optimizing existing databases, designing data collection and flows for cross functional teams. The ideal candidate is an data engineer who has extensive experience working with clinical data and collaborating across diverse teams to ensure the data provided is accurate, the data pipelines reliable, and the resulting databases are fit for a variety of purposes.

The Principal Data Engineer will work with informaticists, clinicians, software engineers, and data scientists to serve as a subject matter expert in data engineering best practices and will ensure optimal data delivery architecture is consistent throughout ongoing projects. The position will also be responsible for the management of data related projects and oversee the tasks of other team members when relevant.

Core Job Duties

• Expert in data modeling concepts,
• Responsible for designing, implementing, documenting and testing databases containing clinical data.
• Leverage SQL, Python and other programming languages
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Build ETL pipelines from varying data sources and technologies using cloud technologies such as Google Cloud or Microsoft Azure and implemented with Apache Airflow or similar products
• Problem solving with the initiative to think critically to identify improvement opportunities.
• Provide direction on best practices for data transformation, structure, and workflows.
• Ability to effectively participate in multiple, concurrent projects
• Research new and existing data sources in order to contribute to new development, improve data management processes, and make recommendations for data quality initiatives.
• Perform periodic data quality reviews for internal and external data.

Qualifications

A Master's degree in a relevant field such as engineering, mathematics, computer science, health science, or other analytical/quantitative and a minimum of five years of professional or research experience in data science

The successful candidate will need to have both technical and business background/experience along with strong leadership skills. Good written and oral communication skills are required. Deep expertise in the use of scientific computing and data management packages. Ability to prioritize, organize, and delegate various tasks on projects. Demonstrated initiative in administration, education (seminars, training), software development, and technical reports. Demonstrated success in project management and communication skills. Demonstrated ability to develop predictive and prescriptive models on large-scale datasets to address various business problems through leveraging advanced statistical modeling, machine learning, or data mining techniques. Demonstrated ability to provide consultative services at an institutional or enterprise level to departments/divisions and committees from any Mayo entity requesting assistance is preferred. Demonstrated application of several problem-solving methodologies, planning techniques, continuous improvement methods, project management methods, and analytical tools and methodologies (e.g. machine learning, statistical packages, modeling, etc.) required. Incumbent must have ability to independently manage a varied workload of projects with multiple priorities and stay current on healthcare trends and enterprise changes. Excellent interpersonal skills to include presentation, negotiation, persuasion, and written communications skills are required. Exceptional time management is required. In addition, requires excellent analytical skills, consulting skills, ability to identify and recommend solutions, advanced computer application skills and a commitment to customer service. Experience with data modeling and date exploration tools.

Preferred Experience

Advanced degree (Ph.D, M.Sc) in Computer Science, Engineering or quantitative field from an accredited University or College with 5+ years of experience. 10+ years of experience preferred.

Requirements

• Demonstrated ability to analyze and profile data as a means to address various business problems through leveraging advanced data modeling, source system databases, or data mining techniques.
• Demonstrated application of several problem-solving methodologies, planning techniques, continuous improvement methods, and analytical tools and methodologies (e.g. data analysis, data profiling, modeling, etc.).
• Incumbent must have ability to manage a varied workload of projects with multiple priorities and stay current on healthcare trends and enterprise changes.
• Interpersonal skills and time management skills are required.
• Strong analytical skills and the ability to identify and recommend solutions, advanced computer application skills and a commitment to customer service.
• Experience with data analysis, quality, and profiling.
• Proficient in SQL and one other programming language commonly used in data engineering (Python, Scala, etc).
• Experience in working with one or more cloud technologies: Amazon Web Services, Google Cloud Projects, or Microsoft Azure

Exemption Status

Exempt

Compensation Detail

$148,100 - $214,700 / year

Benefits Eligible

Yes

Schedule

Full Time

Hours/Pay Period

80

Schedule Details

Monday – Friday; 10%+ travel may be required 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.

Weekend Schedule

Not Applicable

International Assignment

No

Site Description

Just as our reputation has spread beyond our Minnesota roots, so have our locations. Today, our employees are located at our three major campuses in Phoenix/Scottsdale, Arizona, Jacksonville, Florida, Rochester, Minnesota, and at Mayo Clinic Health System campuses throughout Midwestern communities, and at our international locations. Each Mayo Clinic location is a special place where our employees thrive in both their work and personal lives. Learn more about what each unique Mayo Clinic campus has to offer, and where your best fit is.

Equal Opportunity

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, protected veteran status or disability status. Learn more about the "EOE is the Law" . Mayo Clinic participates in E-Verify and may provide the Social Security Administration and, if necessary, the Department of Homeland Security with information from each new employee's Form I-9 to confirm work authorization.