Business Intelligence Analyst II

Under general supervision of the Senior Analytics team members and Analytics leadership team Business Intelligence Analyst II 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 My Michigan processes, patient outcomes and engagement. Uses development tools to generate reports, dashboards and analytical solutions according to business rules and specifications.

Splits time between projects and support activities while adhering to My Michigan Health's policies, procedures, and business operations. Able to quickly adapt to changing priorities and maintain high quality work. Demonstrated 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 reviews and tests software.

Provides subject matter expertise for two or more application modules/ data models or data analysis tools. Has previous healthcare EMR application experience or certification or healthcare analytics experience including use of Excel, SQL or a data visualization software. Understands exploratory data versus explanatory data and can present data findings to a wide variety of audiences. Analysts can turn data into information or insights that assist in answering the business question or problem.

(35%)* Collaborate and support My Michigan 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, report design, and analysis design.

Assists in cross training team members and users. Proactively shares knowledge with other team members. Communicate with third-party vendors and regulatory organizations to understand and manage data requirements and deliverables and facilitates information sharing with other team members.

(15%)*Leads medium to large support or project initiatives. Responsible for leading the efforts of medium to large initiatives including planning the work and managing the effort to the plan. Leverages support of others in completing the tasks on time.

(30%)* Support, Trouble-shooting and Problem solving. Support existing portfolio of reports, dashboards, analytical solutions and tune where necessary. Support and troubleshoot existing ETL processes and complex data development needs. Leads efforts to resolve identified data integrity issues and communicates identified issues with collaborating teams, Business and Clinical leaders. Responsibility in assisting with process optimization. Leads collaborative communication with Database Administrators when technically complex solutions are required.

(10%)* Collaborate and support department data consolidation and expanding/extending data warehousing to meet organizational 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 data visualizations using Tableau or an Epic based tool that are easily consumed by end users and leaders.

(10%)* System Configuration Changes and Modifications Participate in testing reports and extracts during system or business changes. Participate in product upgrades and implementations including occasional weekend or after-hours coverage.

Provide excellent customer service to all customers while performing duties.

Development and adherence to communication plans.

Lead meetings, prioritize, resolve conflicts, maintain issues lists, and manage a project plan.

Takes notes during meetings and is able to 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.

Expected that Epic Certifications are maintained and expanded over time.

My Michigan Health is a technology driven organization and employees need to demonstrate competency in Microsoft Windows.…