Sr Data Management Analyst

MyMichigan Medical Group; Midland, Northern (MI, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

MyMichigan Health is seeking a Senior Data Analyst to lead data governance, ETL operations, and data modeling within the data warehouse environment. You will ensure data accuracy, security, and accessibility across the organization.

The role requires extensive experience with EPIC Cogito, data standards, and cross-functional collaboration to standardize data collection and enable self-serve analytics for clinicians and leaders.

Qualifications

• Bachelor’s degree required in IT, business, or healthcare.
• Master’s degree in data science, analytics, or related field preferred.
• Five+ years in data management, healthcare preferred.

Responsibilities

• Lead data model design and maintenance for the data warehouse.
• Oversee ETL processes from EPIC and other sources with accuracy and timeliness.
• Champion data quality and governance; monitor metrics and audits.
• Serve as EPIC Cogito SME; develop dashboards/reports for clinicians and admins.
• Collaborate across stakeholders to define data needs and ensure usage.
• Drive continuous improvement in data storage, access, and security.

Skills

Data governance

ETL processes

SQL

Data modeling

Data warehousing

Healthcare data standards

EPIC Cogito

Education

Bachelor's Degree in IT, business, or healthcare field

Master's degree in data science, analytics, or related field

Tools

Informatica PowerCenter

SSIS

EPIC Cogito

SQL Server Analysis Services

Job description

Summary

Reporting to senior leadership, the Senior Data Analyst (Data Management) specializes in steering comprehensive data management strategies, emphasizing data governance and the robustness of data within warehouses. This pivotal role orchestrates the acquisition, storage, and meticulous maintenance of extensive datasets to ensure accuracy, accessibility, and security.

Responsibilities encompass designing and maintaining databases/structures, optimizing structures for efficiency and performance. The Senior Data Analyst leads initiatives for stringent data governance, collaborating cross-functionally to standardize data collection methodologies and ensure compliance. Facilitating end-user self-serve access within the data warehouse stands as a significant focus, empowering users to extract insights independently. Additionally, this role serves as the primary support for technical data issues, providing expertise and acting as the subject matter expert for internal EPIC Cogito analytic services. The Senior Data Analyst champions data management best practices, oversees ETL processes, and drives system enhancements to fortify data management capabilities.

Responsibilities

• (25%)* Data Model Design and Maintenance:

  Lead the design and implementation of high-performance, secure data models within the healthcare system's data warehouse, optimized for efficient data queries and analysis.

  Refine and maintain existing data models to accommodate evolving data landscapes and user needs.

  Ensure adherence to healthcare data standards and best practices during data modeling activities.

• (25%)* Data Warehousing and Integration:

  Oversee the ETL (Extract, Transform, Load) processes for loading data from EPIC and other disparate sources into the data warehouse, ensuring accuracy, completeness, and timeliness.

  Collaborate with IT teams to integrate data from diverse healthcare systems and external sources.

  Monitor and troubleshoot data pipeline issues, proactively identifying and resolving data flow inconsistencies and errors.

• (15%)* Data Quality and Governance:

  Champion data quality initiatives by implementing robust cleaning, validation, and error correction measures.

  Develop and enforce data governance policies and procedures to ensure consistency, accuracy, and security of healthcare data.

  Monitor data quality metrics and conduct regular data audits to identify and address potential data integrity issues.

• (15%)* EPIC Cogito Expertise:

  Serve as the subject matter expert for EPIC Cogito services within the organization, providing guidance and support to users on data extraction, reporting, and analysis functionalities.

  Develop and maintain dashboards and reports within EPIC Cogito to track key performance indicators and provide insights for clinicians and administrators.

  Stay informed on the latest EPIC Cogito updates and best practices and advocate for continuous improvement initiatives.

  Participate in testing reports and extracts during system or business changes. Participate in product upgrades and implementations.

• (10%)* Collaboration and Support:

  Collaborate cross-functionally with stakeholders across the healthcare system to understand data needs, define data requirements, and ensure effective data utilization.

  Provide technical support and guidance to data analysts, researchers, and other users on data access, retrieval, and interpretation within the data warehouse.

  Proactively seek opportunities to improve data management processes and communicate potential enhancements to senior leadership.

• (10%)* Continuous Improvement:

  Stay abreast of emerging data management technologies and trends relevant to healthcare.

  Evaluate and recommend new tools and techniques to optimize data storage, access, and security.

  Drive continuous improvement initiatives within the data management function, fostering a culture of data quality and innovation.

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.
• Demonstrate strong project management and organizational skills.
• Assist in the development of, or support of, analytic models and datasets.
• 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 drivenorganization 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 Licensures

N/A

Required Education

Bachelor's Degree in IT, business, or healthcare field required. Master's degree in data science, analytics, or a related field preferred.

Other Information

EXPERIENCE, TRAINING AND SKILLS

• Five or more years of experience in data management roles, preferably within a healthcare setting.
• Two or more years of experience leading complex data management or analysis projects.
• Proven ability to develop and manage ETL processes for large-scale healthcare data.
• Experience with healthcare data standards and regulations (e.g., HIPAA, HITRUST).
• Demonstrated success in implementing data governance policies and procedures.
• Experience working with a healthcare EMR system, ideally EPIC.
• Proficiency in SQL and relational database concepts.
• Experience with data warehouse platforms (e.g., Microsoft SQL Server Analysis Services, Teradata, Snowflake).
• Knowledge of ETL tools (e.g., Informatica PowerCenter, SSIS).
• Familiarity with data extraction tools from healthcare systems (e.g., EPIC Cogito).
• Basic understanding of data visualization tools (e.g., Tableau, Power BI).
• In-Depth experience and competency with EPIC and Cogito applications including (Clarity, Caboodle, Chronicles, Radar, Reporting Workbench, Slicer Dicer, Analytics Catalog).
• Strong communication skills with ability to collaborate at multiple organization levels across the health system as required, including both technical and non-technical staff.

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.