BUSINESS INTELLIGENCE ARCHITECT SENIOR - Care Management - Full Time - Days

The Christ Hospital
Ohio, US
Full-time

Job Description

This role will primarily be responsible for meeting the data needs of ambulatory care to support care delivery, strategic initiatives and improve performance in Value Based Contracts.

Work with leadership to identify and develop success metrics and create data dashboards and other tools to track performance.

This individual will participate in performance improvement activity planning as well as work with TCHP leadership to help develop reporting and analysis to assist in performance of Value Based Contracts.

Responsibilities

Demonstrate data experience in data warehousing in data modeling, ETL architecture and development, reporting and visualizations.

Design staging layer (reporting and visualizations). Author business requirement documentation, functional specifications and technical design documentation.

Leverage innate Epic capabilities and enhance where needed. The Senior Data Architect must review, validate and maintain the Caboodle Warehouse architecture, entity relationship diagrams, data dictionary (definitions and lineage) for accuracy, usability and completeness.

Must design, develop and maintain dimensional and 3NF data models based on business requirements and impact analysis. Must have demonstrated ability of conceptual, logical and physical data modeling in a data warehousing environment

Establish expertise in reviewing design, data development and implementation of current and future data EDW architecture.

Support, monitor & administrate custom build Epic Caboodle, Clarity and Slicer Dicer; This position will be responsible for data profiling, data mapping (source to target) and data flow.

This position will be responsible for reviewing data definitions, data types, integrity constraints, cardinality, keying, indexing, lineage and other documentation and configuration as required.

Ability to review applications in development to ensure conformance to industry best practices. Develop and maintain audit process & reporting, data mapping documents, ERD designs and other documents as required.

Effectively communicate cross departmental, e.g., Infrastructure, Networking, Epic Analysts, & Informatics teams, end users and others.

Collaborate with Bl analysts and internal customers to understand business and functional requirements. Conduct analysis to deliver technical solutions with a focus on usability.

Ability to stay organized and manage tasks for technical projects / deliveries. effectively manage technical projects / deliveries

Apply appropriate testing methodologies and code migration strategies ensuring deliveries meet business requirements, are accurate and minimize iterations.

This position will be responsible for reviewing / validating data accuracy throughout its lifecycle and participates in maintenance and monitoring activities.

Other duties as assigned

Qualifications

KNOWLEDGE AND SKILLS :

Please describe any specialized knowledge or skills, which are REQUIRED to perform the position duties. Do not personalize the job description, credentials, or knowledge and skills based on the current associate.

List any special education required for this position.

EDUCATION : Master's Degree preferred

YEARS OF EXPERIENCE : 5

Minimum 1 year experience with Caboodle development and Caboodle- Clarity development

Minimum 5 years ETL experience with SSIS

Minimum 5 years of Cogito experience

Business Objects experience desired

Project management experience preferred

REQUIRED SKILLS AND KNOWLEDGE :

Proficient in complex T-SQL code, stored procedures writing, analysis and debugging

Ability to analyze, debug and bring existing code up to standard

Strong knowledge of SQL (DDL, DML, TCL, and DCL)

Strong metadata skills including data lineage

Proven ability to architect and engineer business intelligence applications

Experience performing data analysis

Experience working on large system implementation projects

Experience with healthcare data including Epic Clarity Data Models

Experience with healthcare reporting regulations, certifications and compliance

Experience with SFTP application for automated secure transfer of extract files

Experience with SQL Server Administration and security

Experience with SQL Server Agent Administration; jobs, schedules, alerts & security

Dimensional (Star Schema) data modeling experience

Experience with version control software

Experience designing visualizations and dashboards

Data warehouse experience

The candidate must be self-starting, have a strong attention to detail and accuracy, and have a demonstrated knowledge of data architecture / data modeling in a source and warehouse environment.

LICENSES & CERTIFICATIONS :

Caboodle Developer certification required.

Clarity data model certification required

11 days ago
Related jobs
Promoted
Shaker for ChristianaCare Direct
Toledo, Ohio

C has the unique ability to care for patients that require Intermediate stepdown level of care or Transitional stepdown level of care within the same unit. We offer a variety of part time or full-time positions with flexible scheduling to meet the individual needs of our team members. C nurses are h...

Promoted
Kenton Nursing & Rehab Center
Kenton, Ohio

AOM Healthcare is a premier long term care company, operating twenty one long term care facilities throughout the state of Ohio and is now hiring Full-Time and Part-Time Registered LPN's at Kenton Nursing & Rehab Center, located at. ...

Promoted
ProMedica
Westlake, Ohio

Arden Courts ProMedica Memory Care Westlake is hiring a part-time LPN with $5,000 Sign on bonus. This LPN position is a staff position that has direct care responsibilities as well as supervisor responsibility for caregivers. The Licensed Practical Nurse - LPN is responsible for supervising nursing ...

Korzen Health
Akron, Ohio

We are looking to add a full time or parttime physician to our outpatient to help oversee our wound carecenter. Full HealthcareBenefits 401K and retirement plan. PTO dayswhich include all major holidays. Korzen Health is working withFirstHealth Moore Regional Hospital Wound Care & HyperbaricCenter w...

Connect Senior Care
Columbus, Ohio

Vice President of Business Development for a Multi State Senior Care Provider SNF, ALF, IL. The VP of Business Development consulates field Admissions Director and External Care Coordinator for facility team members for assigned to strategic markets (overnight travel may be required. Strong leadersh...

Crossroads Hospice & Palliative Care
Valley View, Ohio

At Crossroads Hospice & Palliative Care, we believe that end-of-life care should never feel transactional, regardless of economic factors. Every person we care for deserves to be treated with dignity, compassion, and respect, no matter the circumstances. Must possess interpersonal skills suffici...

Crossroads Hospice & Palliative Care
Blue Ash, Ohio

End-of-life care should never feel transactional, regardless of economic factors. Every person we care for deserves to be treated with dignity, compassion, and respect, no matter the circumstances. Quick response STNAs play a crucial role in our Even More Care program, responding to urgent physical ...

TriHealth
Cincinnati, Ohio

May perform non-direct patient care activities as assigned, requested, or directed including but not limited to stocking and clerical activities. Performs and documents basic patient care tasks under the direct supervision of an RN. Completes assigned tasks within required timeframe. Reports patient...

American Family Care Harpers Point
Cincinnati, Ohio

AFC Urgent Care Harpers Point is seeking a full-time Advanced Practice Provider (Nurse Practitioner or Physician Assistant) to provide comprehensive care to patients of all ages. AFC Urgent Care Harpers Point is a state-of-the-art clinic dedicated to providing high-quality, efficient, and compassion...

Domino's Franchise
Akron, Ohio

This position is full-time, 4-5 days per week. Make some extra cash now, make it a career later. Many of our team members began their careers as delivery drivers, cashiers, or pizza makers and today are successful Domino's franchise owners. ...