Data Engineer - Research Business Intelligence
Job Description
Build and optimize research business intelligence data pipelines and analysis capabilities for Mayo Clinic.
Responsibilities
- Assemble large, complex datasets aligned to functional and non-functional business requirements
- Use SQL for data mining, troubleshooting, and query development; identify information across multiple joins and unions when needed
- Perform complex data analysis and investigation to explain results for customer requests and support recommendations
- Apply data modeling concepts to structure and deliver consistent data
- Improve data solutions by troubleshooting errors, detecting issues, performing root cause analysis, and supporting error correction
- Work with ETL processes to support verification and testing of data
- Build and maintain processes for data transformation, data structures, metadata, dependency management, and workload management
- Demonstrate experience manipulating and extracting value from large disconnected datasets
- Translate business objectives into data solutions that meet customer needs
- Contribute effectively across multiple concurrent projects
- Research new and existing data sources to improve data management and make recommendations for data quality initiatives
- Conduct periodic data quality reviews for internal and external datasets
- Support timely resolution of queries and data issues
- Identify new opportunities to find and collect data by evaluating potential new sources
- Collaborate with data and analytics experts to improve functionality across data systems
Requirements
- Education: Bachelor’s degree in Computer Science, Engineering, or related field (or an Associate’s degree in the same areas with 2 years of experience) from an accredited University or College
- Data analysis and profiling: 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 application of problem-solving and continuous improvement methods and analytical tools (including data analysis, data profiling, and modeling)
- Ability to manage a varied workload with multiple priorities and stay current on healthcare trends and enterprise changes
- Interpersonal skills and time management skills
- Strong analytical skills to identify and recommend solutions, plus advanced computer application skills and commitment to customer service
- Experience with data analysis, quality, and profiling, including data exploration tools such as Rapid SQL, AQT, Information Analyzer, and Informatics
Technologies
- SQL
- Rapid SQL
- AQT
- Information Analyzer
- Informatics
Location and Schedule
- Location: Rochester, MN (hybrid)
- On-site requirement: must be located within 100 miles of the Mayo Clinic campus in Rochester, MN; 4 days a week on-site expectations
- Work arrangement: Hybrid
- Schedule: Full Time; 80 hours
- ADRC hours: 7am to 5pm; schedules fall within this timeframe and are set individually based on operational and business needs
- Weekend schedule: none
Exemption and Compensation
- Exempt position
- Salary: $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 to secure your future (Retirement)
- Benefits eligible: Yes
International assignment: No
Similar Jobs
S