BI Analyst Senior / Intermediate | TalentAlly · Teeming.ai
TalentAlly
TalentAlly is a recruitment platform that connects diverse talent with inclusive employers, focusing on enhancing workplace diversity and inclusion. The company offers job postings, recruitment…
TalentAlly is a recruitment platform that connects diverse talent with inclusive employers, focusing on enhancing workplace diversity and inclusion. The company offers job postings, recruitment…
Your next opportunity is in here somewhere. Sign up to explore 52,000+ startups and their open roles. No spam. No gamification. Just jobs.
52,000+
Startups
66,000+
Open Roles
1,300+
New This Week
Machine Learning Engineer
Full-timeBerlin, DE
Full-time • Berlin, DE
AI Researcher
Part-timeRotterdam, NL
Part-time • Rotterdam, NL
Product Designer
Part-timeMunich, DE
Part-time • Munich, DE
Frontend Developer
Full-timeJerusalem
Full-time • Jerusalem
Product Designer
Part-timeHaifa
Part-time • Haifa
Backend Developer
Full-timeAustin, US
Full-time • Austin, US
How to Apply
A cover letter is required for consideration for this position and should be attached as the first page of your CV/Resume, along with three references. The cover letter must be the leading page of your CV/resume and should address your specific interest in the position and outline skills and experience that directly relate to this position.
Starting salaries will vary depending upon the qualifications and experience of the selected candidate.
Job Summary
A highly motivated Business Intelligence Analyst (Senior with underfill) to join the Department of Emergency Medicine at Michigan Medicine. This position will focus on designing and maintaining technical data solutions to support Emergency Medicine research, using advanced tools for data mining, statistical analysis, visualization, and interpretation to advance human subjects research within Emergency Medicine. The role emphasizes data development and integration across multiple systems and technologies, with occasional dashboard development as needed. The analyst must also communicate effectively with diverse stakeholders, including clinically educated but non-technical personnel, translating complex data concepts into clear, actionable insights.
Responsibilities include data extraction, organization, and staging for multiple sites and stakeholders; database design and optimization for research workflows; managing data within the EDRESEARCH schema in Clarity and HSDW?including backups, indexing, performance tuning, and security configuration for assigned datasets; application development; and clear communication of data insights. The analyst will also write advanced code for dataset preparation and data mart enhancements and ensure data delivery meets project specifications and quality standards.
The analyst will map, collect, and analyze clinical information from electronic medical records and UMHS data warehouses, and work with external data sources as needed, leveraging departmental resources such as the ED Data Mart to support research initiatives. The role includes managing databases, dashboards and ensuring data quality and security.
The analyst will produce reports for review and evaluation and collaborate closely with the departmental statistician and the Emergency Department Business Intelligence team to share code and leverage existing resources. This collaboration ensures consistency in data governance and development for datasets that support research and, where applicable, quality of care. The successful candidate is expected to be a proactive problem solver who is willing to learn new languages and tools to move projects forward.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
Why Join Michigan Medicine?
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world's most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.
What Benefits can you Look Forward to?
Excellent medical, dental and vision coverage effective on your very first day
2:1 Match on retirement savings
Responsibilities*
Required Qualifications (Senior Level) *
Required Qualifications (Intermediate Level)
Working knowledge of UMHS clinical programs, EPIC MiChart. Cogito Certification. EPIC certification as an informatics programmer. Familiarity with healthcare data models used in research (ohohsdi/omop, pcornet and others), healthcare terminology (ICD, CPT, SNOMED, LOINC) and terminology services (UMLS), clinical text processing, healthcare APIs (i.e. FHIR), application programming in EPIC. Report development experience. Knowledge of Hospital or clinical department policies and procedures, including working with clinical computer supported data systems. Working knowledge of statistics and statistical programs is desired. Working knowledge of medical terminology strongly suggested. Professional communication experience. Comfort with medical environments is desirable, as well as experience with confidential and sensitive information.
Modes of Work
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
Underfill Statement
This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.
Background Screening
Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.
Application Deadline
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
U-M EEO Statement
The University of Michigan is an equal employment opportunity employer.
PDN-a0f70f0a-d03c-4401-942d-7dae1ec2ae07
All items listed in the above summary
Scope, communicate, collaborate and manage deliverables
Design and development of data structures and data extracts to support comprehensive data collection, loading and extraction for complex analysis
Manage, structure and extract clinical data from various databases (structured and unstructured)
Create and maintain a method for data request submission and generation of associated metrics
Leverage software to clean data and prepare it for analysis
Communicate clearly and consult with a variety of clients
Develop statistical reports and insights from data and its derived features
Build & maintain datamarts and datasets derived from Epic EHR data. Target RDBMS is currently Oracle but will be migrating to Azure based SQL server.
Build and support statistical data sets for standardized reporting and presentations
Create ad-hoc data reports and analysis as needed
Identify and lead innovative solutions for data and IT services for various efforts
Report regularly on status of assignments, barrier resolution, and project deliverables
Additional work related tasks, not specifically outlined above, will be required of the candidate. Required Qualifications*
Bachelor's degree quantitative field
Minimum 5 years of related experience
Proficiency or Certification in the Epic EHR Cogito Data and Analytics suite, including the Clarity and Caboodle data models, and familiarity with Epic Reporting Workbench, Slicer-Dicer and Radar Dashboards
Must have proven success with managing IT projects and deliverables
Practical experience with SQL query writing and optimization for MS-SQL server (on prem and Azure based), oracle database (on prem) and PostGres (on prem)
Proficiency in some scripting or analysis language, preferably python or R. MATLAB or other platforms are acceptable but knowledge of python will be required.
Proven experience in developing electronic dashboards, preferably with Tableau and/or PowerBI
Proven experience ETL/ELT processes using low code tools like SSIS, Pentaho or informatica, but also the ability to use SQL, python, R or other programming languages to manage these processes in a granular manner
Ability to manage multiple projects and assignments with a high level of autonomy and accountability for results
Willingness to learn and quickly adjust to new tools and systems
Capable of converting ambiguous problem statements into concrete project requirements
Passion for data-driven results and customer initiatives
Must have excellent interpersonal skills including team leadership, emotional intelligence, self-management, priority management, tact and diplomacy, as well as good interpersonal communication skills
Individual must be organized, attentive to detail, motivated to learn, possess time management skills, and be capable of functioning independently
Excellent verbal and written communication skills including the ability to communicate effectively and professionally with colleagues and stakeholders
Ability to understand and explain technical concepts to non-technical stakeholders
Bachelor's degree quantitative field
3-5 years of related experience
Experience in a clinical environment in any role is desired
Proficiency or Certification in the Epic EHR Cogito suite, including the Clarity and Caboodle data models, and familiarity with Epic Reporting Workbench, Slicer-Dicer and Radar Dashboards
Must have proven success with managing IT projects and deliverables
Demonstrated expertise using MS-SQL Server or Oracle database in a production environment containing sensitive data
Proficiency using relevant tools (such as Python, R, MATLAB, SQL, Excel, Tableau, Power BI OR the ability and willingness to train/certify in areas where you need to gain knowledge
Proven experience with analytics and data extraction design
Proven experience in developing electronic dashboards, preferably with Tableau and/or Power BI
Ability to manage multiple projects and assignments with a high level of autonomy and accountability for results
Willingness to learn and quickly adjust to new tools and systems
Capable of converting ambiguous problem statements into concrete project requirements
Passion for data-driven results and customer initiatives
Must have excellent interpersonal skills including team leadership, emotional intelligence, self-management, priority management, tact and diplomacy, as well as good interpersonal communication skills
Individual must be organized, attentive to detail, motivated to learn, possess time management skills, and be capable of functioning independently
Excellent verbal and written communication skills including the ability to communicate effectively and professionally with colleagues and stakeholders
Ability to understand and explain technical concepts to non-technical stakeholders Desired Qualifications*
