Data Engineer - Research Business Intelligence
Job Description
The Mayo Clinic is seeking a Data Engineer - Research Business Intelligence to support research and enterprise data needs by building and optimizing data pipelines, data architecture, and data delivery for multiple teams. This hybrid role focuses on assembling large datasets, ensuring data quality, and applying SQL and data modeling to translate business objectives into reliable data solutions.
Responsibilities
- Assemble large, complex datasets that satisfy functional and non-functional business requirements.
- Use strong SQL skills to write, troubleshoot, and refine queries for data mining, including working with multiple joins or unions of tables to identify relevant information sets and subsets.
- Conduct complex data analysis and investigation to address customer requests, explain findings, and provide appropriate recommendations.
- Apply data modeling concepts to support consistent data delivery and improved data structures.
- Use critical thinking to identify improvement opportunities, including error detection, error correction, and root cause analysis.
- Support verification and testing by understanding ETL processes used to validate data.
- Build and maintain processes for data transformation, data structures, metadata, dependency management, and workload management.
- Demonstrate experience manipulating, processing, and extracting value from large disconnected datasets.
- Analyze business objectives and develop data solutions that meet customer needs.
- Participate effectively in multiple concurrent projects.
- Improve and customize existing data solutions to meet business functional and non-functional requirements.
- Research new and existing data sources to support development efforts, improve data management practices, and recommend data quality initiatives.
- Perform periodic data quality reviews for internal and external data.
- Ensure timely resolution of queries and data issues.
- Research potential new information sources to improve how data is collected.
- Collaborate with data and analytics experts to improve the functionality of data systems.
Requirements
- Bachelor’s degree in Computer Science, Engineering, or a related field from an accredited University or College; or an Associate’s degree in Computer Science, Engineering, or a related field from an accredited University or College with 2 years of experience.
- Demonstrated ability to analyze and profile data to address business problems using advanced data modeling, source system databases, or data mining techniques.
- May provide consultative services to departments, divisions, and committees.
- Demonstrated ability to apply problem-solving methodologies, planning techniques, continuous improvement methods, and analytical tools (for example, data analysis, data profiling, and modeling).
- Ability to manage a varied workload with multiple priorities while staying current on healthcare trends and enterprise changes.
- Interpersonal skills and time management skills.
- Strong analytical skills 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 such as Rapid SQL, AQT, Information Analyzer, and Informatics.
Required Technologies
- SQL
- Rapid SQL
- AQT
- Information Analyzer
- Informatics
Schedule
- Full Time (80)
- Exempt
- ADRC hours are 7am - 5pm. Schedules are set individually based on operational and business needs.
- Hybrid position requiring residence within 100 miles of the Mayo Clinic campus in Rochester, MN for on-site expectations of 4 days a week.
- No weekend schedule
Location
Rochester, MN (hybrid)
Compensation
USD 96,179 - 144,331 per year. Education, experience, and tenure may be considered along with internal equity when offers are extended.
Benefits
- Multiple plan options (Medical)
- Delta Dental or reimbursement account for flexible coverage (Dental)
- Affordable plan with national network (Vision)
- HSA and FSAs for eligible expenses (Pre-Tax Savings)
- Competitive retirement package (Retirement)
Additional Information
- Benefits eligible: Yes
- International assignment: No
- Minimum experience: 2 years
Similar Jobs
S