Data Engineer

At Mayo Clinic in Rochester, a Data Engineer builds and optimizes data pipelines and data architectures to support analytics across the organization. This role works across cross-functional teams to analyze data, translate business requirements into information needs, and ensure reliable data delivery to stakeholders.

Location

Rochester, MN (onsite)

Salary

USD 102,300 - 143,200 per year

Minimum Experience

2 years

Education

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

Responsibilities

• 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.

Requirements

• Bachelor's degree in Computer Science, Engineering, or related field; or Associate’s degree in Computer Science, Engineering, or related field 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.
• 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.

Technologies

• SQL
• Rapid SQL
• AQT
• Information Analyzer
• Informatics

Benefits

• 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.

Recruiter

Julie Melton