Data Engineer

Mayo Foundation for Medical Education and Research; Rochester (MN); On-site; USD 102,300 - 143,200; Full time

Benefits offered by this job

Medical plans

Dental coverage

Vision plan

HSA/FSAs

Retirement package

Job summary

Mayo Clinic is seeking a Data Engineer to access data across the organization, analyze data, and support data-driven decision making. You will work with software developers, database architects, data analysts and data scientists to optimize data delivery and architecture across cross-functional teams.

The role requires strong SQL knowledge, data modeling understanding, and experience with ETL processes. You will contribute to improving data quality and expanding data systems to meet business

Qualifications

• Bachelor's degree or 2 years of related experience with data analysis, profiling and modeling.
• Ability to analyze and profile data to address business problems using data mining techniques.
• Experience with data quality, ETL concepts and data delivery architectures.

Responsibilities

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Strong knowledge of SQL required; write, troubleshoot and optimize queries for data mining.
• Perform complex data analysis and investigation to explain results and make recommendations.
• Understand data modeling concepts and build data solutions for business needs.
• Participate in multiple concurrent projects and improve existing data solutions.
• Research new data sources to support development and data quality initiatives.

Skills

Analytical mindset

Data modeling concepts

Time management

Communication

Education

Bachelor's degree in Computer Science, Engineering, or related field

Associate’s degree in Computer Science, Engineering, or related field with 2 years experience

Tools

Rapid SQL

AQT

Information Analyzer

Informatics

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.

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

Data Engineer gains access to data across the organization and provides ongoing analysis of the data by monitoring, profiling and analyzing databases. Requires a mix of functional, data and technical skills. The right candidate must be able to understand business requirements, translate them into information needs and implement those requirements using data available. The hire will be responsible for expanding and optimizing data architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems. The Data Engineer will support our software developers, database architects, and data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Strong knowledge of SQL required. Ability to identify sets and subsets of information across multiple joins or unions of tables is preferred in addition to writing and troubleshooting SQL queries for data mining
• Perform complex data analysis and investigation for customer requests to explain results and to make appropriate recommendations.
• Strong understanding of data modeling concepts
• Problem solver with the initiative to think critically to identify improvement opportunities (error detection, error correction, root cause analysis)
• Understand ETL that will aid in verification and testing of data
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Analyze business objectives and develop data solutions to meet customer needs.
• Demonstrated ability to effectively participate in multiple, concurrent projects
• Improve and customize current data solutions to meet business functional and non-functional requirements.
• 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.
• Ensure timely resolution of queries and data issues.
• Look for new ways to find and collect data by researching potential new sources of information.
• Work with data and analytics experts to strive for greater functionality in our data systems.

Qualifications

Bachelor's degree in Computer Science, Engineering, or related field from an accredited University or College; OR an Associate’s degree in Computer Science, Engineering, or related field from an accredited University or College with 2 years of experience. 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, is required. May provide consultative services to departments/divisions and committees. 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.) required. 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. Requires 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; including data exploration tools including but not limited to Rapid SQL, AQT, Information Analyzer, and Informatics.

Exemption Status

Exempt

Compensation Detail

$102,300 - $143,200 / year

Benefits Eligible

Yes

Schedule

Full Time

Hours/Pay Period

80

Schedule Details

Monday - Friday, Business Hours, 10%+ travel 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-Verifyand 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.