MyMichigan Health
Business Intelligence Analyst I
This job is now closed
Job Description
- Req#: 36485
Summary**Position will be hybrid with a chance to be fully remote after 90 day orientation period**
Under direct supervision of senior team members and Innovation Analytics leaders, Business Intelligence Analyst I is responsible for the delivery of analytics solutions to end users that facilitate informed decision making. Promotes data literacy by educating customers to use data as a tool for improving MyMichigan processes, patient outcomes and engagement. Uses development tools to generate reports, dashboards and analytical solutions according to business needs and specifications. Splits time between projects and support activities while adhering to MyMichigan Health’s policies and procedures. Quickly adapts to changing priorities and maintains high quality work. Demonstrates ability to work independently and/or in a team to train, guide, or assist others to perform complex assignments. Performs in-depth analysis of workflows, data collection, report details, and review and testing of software. Provides subject matter expertise for one or more application modules/data models or data analysis tools. Has previous Epic application experience or certification or healthcare analytics experience including use of Excel or a data visualization software such as Tableau. Analysts can turn data into information or insights that assist in answering the business questions or problems. Must complete Epic certification with 120 days of hiring into position.
Responsibilities(40%) Collaborate and support MyMichigan reporting needs. Work with internal customers to identify reporting needs, gather and document requirements, build and test reports, dashboards, and analytical solutions. Designs simple to complex queries or analysis using structured query language and ensures analytic methodologies are followed and makes recommendations where necessary. Assist other technical team members with query and report design. Analysts work to integrate, analyze and interpret large data sets to create insights that drive the accomplishment of MyMichigan Strategic Priorities. Actively engages in required Epic reporting maintenance efforts and responsible for Epic Release and Implementation work required to support MyMichigan growth strategies.
(20%) Leads small support or project initiatives that align with the MyMichigan strategic priorities. Responsible for leading the efforts of small initiatives including planning the work and managing the effort associated with the plan. Leverages support of others in completing the tasks on time and collaborates with Business and Clinical Leaders per project requirements. Coordinates efforts with other Epic application teams as needed and appropriate.
(15%) Collaborates and supports department data consolidation and data warehousing needs. Develop Extract, Transformation, and Load processes from source EMR systems into consolidated healthcare reporting systems utilizing tools like Microsoft SQL Server and SQL Server Integration Services – SSIS or develops and/or collaborates to create interactive data visualizations using Tableau or Epic based tools that are easily consumed by end users and leaders. Activities may also include maintenance or refining of data sources that support Tableau Dashboards and indexing content both within the Epic framework and other external tools.
(15%) Support, troubleshooting and problem solving of reporting tools, processes and reported issues. Support existing portfolio of reports, dashboards, analytical solutions and tune where necessary. Works directly with end users that report problems or errors and executes resolutions. Supports and troubleshoots existing ETL and/content migration processes. Works collaboratively with senior team members, application analysts and Database Administrators when technically complex solutions are required.
(10%) System configuration change implementation and validation. Participates in testing reports and extracts during system or business changes. Participates in product upgrades (Epic, Tableau, or other identified tools) and implementations including occasional weekend or after-hours coverage.
OTHER DUTIES AND RESPONSIBILITIES
Provide excellent customer service to all customers while performing duties.
Lead meetings, prioritize, resolve conflicts, maintain issues lists, and manage a project plan.
Takes notes during meetings and can identify when issue escalation is required.
Demonstrate strong project management and organizational skills.
Communicate effectively with project leadership and subject matter experts.
Continue to learn the software and increase their knowledge over time.
MyMichigan Health is a technology driven organization and employees need to demonstrate competency in Microsoft® Windows.
Employees are required to take a Computer Skills Assessment via the learning management system upon hire.
Based on the results of the assessment, an employee may be required to participate in further learning opportunities offered by MyMichigan Health.
Certifications and LicensuresN/A
Required EducationAssociates Degree with 2-3 years computer related experience required.
Bachelors degree preferred. Degree in IT, business, or health care field preferred.
Other InformationEXPERIENCE, TRAINING AND SKILLS
Preferably one (1) or more years of experience or more years of experience developing applications/reports within Epic, a Business Intelligence tool such as Tableau or, Microsoft SQL Server, Oracle, DB2 or other RDBMS platform.
Preferably proficient in SQL or expertise in analytics tools such as Tableau.
Exposure to reporting tools such as Microsoft SQL Server Reporting (SSRS); Crystal Reports or Business Objects.
Proficiency in data manipulation and extraction techniques.
Exposure to Extract, Transform and Load (ETL) technology, Microsoft SQL Server Integration Services (SSIS) preferred.
Experience with integrating data from heterogeneous systems (flat files, Excel as well as relational database systems.)
Team orientation, problem solving, and communication skills required.
Proficient with Microsoft Excel.
Strong communication skills (written and verbal) with ability to collaborate at multiple organization levels across the health system as required, including both technical and nontechnical staff.
Epic trained and / or certified preferred.
Working knowledge of data models from EMRs and/or healthcare.
PHYSICAL/MENTAL REQUIREMENTS AND TYPICAL WORKING CONDITIONS:
Exposure to stressful situations, including those involving public contact, as well as, trauma, grief and death.
Able to wear personal protective equipment that includes latex materials or appropriate substitute if required for your position.
Is able to move freely about facility with or without an assisted device and must be able to perform the functions of the job as outlined in the job description.
Overall vision and hearing is necessary with or without assisted device(s).
Frequently required to sit/stand/walk for long periods of time. May require frequent postural changes such as stooping, kneeling or crouching.
Some exposure to blood borne pathogens and other potentially infectious material.
Must follow MidMichigan Health bloodborne pathogen and TB testing as required.
Ability to handle multiple tasks, get along with others, work independently, regular and predictable attendance and ability to stay awake.
Overall dexterity is required including handling, reaching, grasping, fingering and feeling.
May require repetition of these movements on a regular to frequent basis.
Physical Demand Level: Sedentary. Must be able to occasionally (0?33% of the workday) lift or carry 0?10 lbs.
EXPERIENCE, TRAINING AND SKILLS
Preferably one (1) or more years of experience or more years of experience developing applications/reports within Epic, a Business Intelligence tool such as Tableau or, Microsoft SQL Server, Oracle, DB2 or other RDBMS platform.
Preferably proficient in SQL or expertise in analytics tools such as Tableau.
Exposure to reporting tools such as Microsoft SQL Server Reporting (SSRS); Crystal Reports or Business Objects.
Proficiency in data manipulation and extraction techniques.
Exposure to Extract, Transform and Load (ETL) technology, Microsoft SQL Server Integration Services (SSIS) preferred.
Experience with integrating data from heterogeneous systems (flat files, Excel as well as relational database systems.)
Team orientation, problem solving, and communication skills required.
Proficient with Microsoft Excel.
Strong communication skills (written and verbal) with ability to collaborate at multiple organization levels across the health system as required, including both technical and nontechnical staff.
Epic trained and / or certified preferred.
Working knowledge of data models from EMRs and/or healthcare.
PHYSICAL/MENTAL REQUIREMENTS AND TYPICAL WORKING CONDITIONS:
Exposure to stressful situations, including those involving public contact, as well as, trauma, grief and death.
Able to wear personal protective equipment that includes latex materials or appropriate substitute if required for your position.
Is able to move freely about facility with or without an assisted device and must be able to perform the functions of the job as outlined in the job description.
Overall vision and hearing is necessary with or without assisted device(s).
Frequently required to sit/stand/walk for long periods of time. May require frequent postural changes such as stooping, kneeling or crouching.
Some exposure to blood borne pathogens and other potentially infectious material.
Must follow MidMichigan Health bloodborne pathogen and TB testing as required.
Ability to handle multiple tasks, get along with others, work independently, regular and predictable attendance and ability to stay awake.
Overall dexterity is required including handling, reaching, grasping, fingering and feeling.
May require repetition of these movements on a regular to frequent basis.
Physical Demand Level: Sedentary. Must be able to occasionally (0?33% of the workday) lift or carry 0?10 lbs.
(40%) Collaborate and support MyMichigan reporting needs. Work with internal customers to identify reporting needs, gather and document requirements, build and test reports, dashboards, and analytical solutions. Designs simple to complex queries or analysis using structured query language and ensures analytic methodologies are followed and makes recommendations where necessary. Assist other technical team members with query and report design. Analysts work to integrate, analyze and interpret large data sets to create insights that drive the accomplishment of MyMichigan Strategic Priorities. Actively engages in required Epic reporting maintenance efforts and responsible for Epic Release and Implementation work required to support MyMichigan growth strategies.
(20%) Leads small support or project initiatives that align with the MyMichigan strategic priorities. Responsible for leading the efforts of small initiatives including planning the work and managing the effort associated with the plan. Leverages support of others in completing the tasks on time and collaborates with Business and Clinical Leaders per project requirements. Coordinates efforts with other Epic application teams as needed and appropriate.
(15%) Collaborates and supports department data consolidation and data warehousing needs. Develop Extract, Transformation, and Load processes from source EMR systems into consolidated healthcare reporting systems utilizing tools like Microsoft SQL Server and SQL Server Integration Services – SSIS or develops and/or collaborates to create interactive data visualizations using Tableau or Epic based tools that are easily consumed by end users and leaders. Activities may also include maintenance or refining of data sources that support Tableau Dashboards and indexing content both within the Epic framework and other external tools.
(15%) Support, troubleshooting and problem solving of reporting tools, processes and reported issues. Support existing portfolio of reports, dashboards, analytical solutions and tune where necessary. Works directly with end users that report problems or errors and executes resolutions. Supports and troubleshoots existing ETL and/content migration processes. Works collaboratively with senior team members, application analysts and Database Administrators when technically complex solutions are required.
(10%) System configuration change implementation and validation. Participates in testing reports and extracts during system or business changes. Participates in product upgrades (Epic, Tableau, or other identified tools) and implementations including occasional weekend or after-hours coverage.
OTHER DUTIES AND RESPONSIBILITIES
Provide excellent customer service to all customers while performing duties.
Lead meetings, prioritize, resolve conflicts, maintain issues lists, and manage a project plan.
Takes notes during meetings and can identify when issue escalation is required.
Demonstrate strong project management and organizational skills.
Communicate effectively with project leadership and subject matter experts.
Continue to learn the software and increase their knowledge over time.
MyMichigan Health is a technology driven organization and employees need to demonstrate competency in Microsoft® Windows.
Employees are required to take a Computer Skills Assessment via the learning management system upon hire.
Based on the results of the assessment, an employee may be required to participate in further learning opportunities offered by MyMichigan Health.
About the company
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.