Intermediate Business Intelligence Specialist

Who We AreJPS Health Network is a $950 million, tax-supported healthcare system in North Texas. Licensed for 582 beds, the network features over 25 locations across Tarrant County, with John Peter Smith Hospital -home to Tarrant County's first and only Level I Trauma Center, only psychiatric emergency center, and the largest hospital-based family medical residency program in the nation. The health network employs more than 7,200 people.

Acclaim Multispecialty Group is the medical practice group featuring over 300 providers serving JPS Health Network. Specialties range from primary care to general surgery and trauma. The Acclaim Multispecialty Group formed around a common set of incentives and expectations supporting the operational, financial, and clinical performance

outcomes of the network. Our goal is to provide high quality, compassionate clinical care for every patient, every time.

Why JPS?We're more than a hospital. We're 7,200 of the most dedicated people you could ever meet. Our goal is to make sure the people of our community get the care they need and deserve. As community stewards, we abide by three Rules of the Road:

1. Own it. Everyone who wears the JPS badge contributes to our journey to excellence.

2. Seek joy. Every day, every shift, we celebrate our patients, smile, and emphasize positivity.

3. Don't be a jerk. Everyone is treated with courtesy and respect. Smiling, laughter, compassion - key components of our everyday experience at JPS.

When working here, you're surrounded by passion, diversity, and dedication. We look forward to meeting you!

For more information, visit www.jpshealthnet.org.

To view all job vacancies, visit www.jpshealthnet.org, www.jpshealthnet.org/careers, or www.teamacclaim.org.

Job Title:

Intermediate Business Intelligence Specialist

Requisition Number:

27671

Employment Type:

Full Time

Division:

IT BUSINESS APPLICATIONS, BI & PMO

Compensation Type:

Salaried

Job Category:

Information Technology

Hours Worked:

8:00 AM - 5:00 PM

Location:

JPOC 1400

Shift Worked:

Day

Job Description:

Description: The Intermediate Business Intelligence Specialist has in-depth knowledge of Business Intelligence, Data Analytics, Data Integration, ETL, Relational Database Systems, SQL, SAP Web Intelligence, SAP Xcelcius, Epic Radar Dashboards, Microsoft Power BI and Stored Procedures including acquiring and maintaining an in-depth knowledge of the Epic Clarity Database and Cogito Data Warehouse. This role is also responsible for combining Hospital and ambulatory clinical and operational knowledge with information technology experience to develop complex business intelligence reports and dashboards for customers. Responsible for gathering requirements, specifications, designing and developing solutions, testing, validating, implementing and providing ongoing support of business intelligence solutions and dashboard for hospital and ambulatory executives.

Typical Duties:

1. Analyzes, completes and develops complex business intelligence data, report and dashboard requests.
2. Develops reports for assigned clarity modules and systems by performing workflow assessments, capturing business needs, and analyzing systems to determine functional requirements and capture data while mentoring other analysts.
3. Lead complex projects including designing and developing business intelligence reports and dashboard solutions using SQL, stored procedures, SAP Webi, SAP Xcelcius, Microsoft Power BI, Radar Dashboard and SAP Lumira.
4. Develops enterprise-wide KPIs and delivers data analytics and Business Intelligence solutions including methods to measure them working with executives.
5. Performs complex system configuration changes related to Clarity database, ETL and Cogito Data warehouse upgrades and vendor related fixes and notifications.
6. Performs complex SQL and TSQL programing code changes related to upgrades and vendor related fixes and notifications for Epic Clarity reports and Epic Cogito Data Warehouse .
7. In-depth understanding of Epic EMR workflows for hospital and ambulatory setting delivering accurate reports and solutions within the context of new and existing workflows and applications.
8. Subject matter expert on complex data projects to design and architect solutions, guides the development of test cases and scripts, and ensures projects meet business and IT objectives.
9. Reviews and ensures final product for accuracy and completeness meeting management expectations.
10. Utilizes Reporting Infrastructure, ETL, and leverages BI Tools to develop complex data solutions. (Dashboards, SSIS, Data Marts, Universes and Cubes)
11. Leads complex system configuration changes related to Clarity database, ETL and Cogito Data warehouse upgrades and vendor related fixes and notifications.
12. Follows departmental processes, including but not limited to on call, project prioritization, status reports, security, documentation, change control, RCA, and time tracking.
13. Keeps abreast of industry trends and vendor upgrades, enhancements, and offerings; partnering with customers to recommend and implement solutions as appropriate.
14. Independently takes ownership of tasks and performs all other job related duties as assigned.

Qualifications:

Required Education and Experience:
• Bachelor Degree in Information Technology or a related field of study from an accredited college or university and
• 4 plus years of strong IT relational database and SQL reporting experience.
OR
• Equivalent combination of education and experience in related field.
Preferred Education and Experience:
• 6 plus years of related experience in a healthcare environment.
• Clarity Data Model Certification.
Required Licensure/Certification/Specialized Training:
• Must obtain current proficiency or certification in assigned data model(s). (i.e.) Epic certification in appropriate module(s) required within specified time frame following class completion and analyst who support Epic modules must maintain certification on current version of Epic.

Location Address:

1400 S. Main Street

Fort Worth, Texas, 76104

United States