Data Engineer

Mayo Career Site US; Rochester (MN); On-site; USD 90,000 - 120,000; Full time

Job summary

Mayo Career Site US is seeking a Data Engineer to access and analyze data across the organization, translating business requirements into data needs and building scalable data pipelines. You will support developers, architects, and analysts while ensuring reliable data delivery across projects.

The role requires strong SQL skills and a solid understanding of data modeling concepts, with a focus on data quality and cross-functional collaboration.

Qualifications

• Strong knowledge of SQL and ability to write and troubleshoot queries for data mining.
• Understanding of data modeling concepts.
• Experience with data analysis and customer request investigations.
• Ability to work on multiple projects and prioritize effectively.

Responsibilities

• Assemble large, complex data sets satisfying business requirements.
• Develop and optimize data pipelines and data delivery architecture.
• Collaborate with data analysts, engineers, and scientists on data initiatives.
• Improve and customize data solutions to meet functional and non-functional needs.
• Research new data sources to enhance data quality and availability.

Skills

SQL

Data Modeling

ETL

Job description

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.

Core job duties include:

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