|
Under general supervision of Enterprise Business Intelligence and Analytics Manager, evaluates, designs and maintains existing or proposed systems to structure, access, and maintain relational and multi-dimensional databases and related extract-transform-load (ETL) processes, including the Epic Data Warehouse and Epic Clarity databases and ETLs, designs and maintains SAP BI Business Objects universes, develops SAP Business Objects Crystal reports including Epic Clarity reports and administers the SAP BI platform. Experienced in the areas of Business Intelligence development and implementations, including Data Warehousing and Integration Services, and report development.
Education:
- Bachelor's degree in Computer Science or Management Information Systems, or a discipline stressing analytical skills, with courses in data management.
Licensure:
- 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
Experience:
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. Skills:
* 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.
* SAP Business Objects BI suite experience preferred.
* Epic Clarity ETL and Epic Data Warehouse (Caboodle) experience/certification preferred.
* 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.
Patient & Workplace Safety: Principal Duties and 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.
All roles must demonstrate GBMC Values: I will treat everyone with courtesy. I will foster a healing environment.
Treats others with fairness, kindness, and respect for personal dignity and privacy. Listens and responds appropriately to others' needs, feelings, and capabilities. I will strive for superior performance in every aspect of my work. I will recognize and celebrate the accomplishments of others.
Meets and/or exceeds customer expectations. Actively pursues learning and self-development. Pays attention to detail; follows through. I will be professional in the way I act, look and speak. I will take ownership to solve problems.
Sets a positive, professional example for others. Takes ownership of problems and does what is needed to solve them. Appropriately plans and utilizes required resources for various job duties.
I will be engaged and collaborative. I will keep people informed.
Works cooperatively and collaboratively with others for the success of the team. Addresses and resolves conflict in a positive way. Seeks out the ideas of others to reach the best solutions. Acknowledges and celebrates the contribution of others. I will always act with honesty and integrity. I will protect the patient.
Demonstrates honesty, integrity and good judgment. Respects the cultural, psychosocial, and spiritual needs of patients/families/coworkers. I will set goals and measure outcomes that support organizational goals. I will give and accept help to achieve goals.
Embraces change and improvement in the work environment. Continuously seeks to improve the quality of products/services. Displays flexibility in dealing with new situations or obstacles. Achieves results on time by focusing on priorities and manages time efficiently. Pay Range $72,782.10 - $123,729.56
Final salary offer will be based on the candidate's qualifications, education, experience and alignment with our organizational needs. Equal Employment Opportunity GBMC HealthCare and its affiliates are Equal Opportunity employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity and expression, age, national origin, mental or physical disability, genetic information, veteran status, or any other status protected by federal, state, or local law.
|
Greater Baltimore Medical Center (GBMC)
Dec 20, 2025