This job has closed.

GBMC HealthCare · 5 hours ago

Data and Enterprise Reporting Administrator EPIC

Baltimore, MD

Full-time

Onsite

Mid Level

$73K/yr - $124K/yr

3+ years exp

GBMC HealthCare is seeking a Data and Enterprise Reporting Administrator EPIC to manage and maintain data systems related to business intelligence and analytics. The role involves evaluating, designing, and maintaining databases, as well as developing reports and administering the SAP BI platform.

Health Care

Responsibilities

Sets up and maintains the Clarity and Caboodle ETL processes including troubleshooting errors

Administers the Clarity and Caboodle databases insuring required information is available to business intelligence developers

Sets up and maintains Epic Caboodle and third party ETLs, including Microsoft SSIS

Administers the Microsoft SQL databases pertaining to the Data Warehouse and SAP BI platform

Develops and maintains SAP BI Business Object universes including on Epic Caboodle

Develops and maintains Web Intelligence and Crystal reports including Epic Caboodle and Clarity model-based reports

Develops and assists in the development of Epic Reporting Workbench reports and Radar dashboards

Administers the SAP BI Business Objects platform including systems configuration, user accounts and access

Coordinates across teams, including technical infrastructure resources, Epic technical resources, analysts, report writers and SMEs in delivering enterprise reporting needs and troubleshooting and resolving issues

Takes on on-call support as primary, clinical or operational support as assigned per IT on-call support schedule

Supports one-on-one and small group report training and the use of report-related tools

Qualification

Data WarehousingETL DevelopmentSQL ServerSAP Business ObjectsEpic ClarityData ModelingAnalytical SkillsTroubleshootingReport DevelopmentUser AdministrationCollaboration

Required

Bachelor's degree in Computer Science or Management Information Systems, or a discipline stressing analytical skills, with courses in data management

3 - 5 years of experience in a medium complex data warehouse environment, hands-on data warehousing project experience and experience in full life cycle Business Intelligence development, implementation, tuning and support, preferably in an Epic and/or SAP BI environment

Hands on experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat files

Hands on ETL development experience, preferably using SSIS and/or including Epic Clarity ETL experience

SQL Server experience required

Strong analytical skills to solve and model complex business requirements, preferably in a health care

Sound understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, SQL skills, data warehouse and reporting techniques, preferably including SAP Business Objects BI tools

Ability to collaborate on a team with Epic Analysts and Technicians, IT Infrastructure resources, and Subject Matter Experts, and clearly communicate solutions to both technical and non-technical team members, including clinical staff

Ability to learn, and develop reports using, SQL, SAP Crystal, SAP BI Web Intelligence, Epic Report Workbench reports and similar tools

Troubleshoot and resolve errors that occur during various ETL processes, including Epic Clarity and Caboodle

Administer the SAP BI Business Objects platform including report scheduling and distribution, and user setup and security

Administer Microsoft SQL and Epic Clarity databases including backups, and performance

Responsible for evaluating, coordinating testing with SMEs, and implementing new releases and upgrades affecting Epic Clarity, Caboodle and SAP BI Business Objects databases and processes

Preferred

Certified Data Management professional (CDMP) preferred

Epic certification in Clarity ETL/DBA, Caboodle, and in one Cogito Clarity Business Intelligence Developer track within set timeframe after date of training established with the reporting manager

SAP Business Objects BI suite experience preferred

Epic Clarity ETL and Epic Data Warehouse (Caboodle) experience/certification preferred