Sr. Business Intelligence Specialist

Who We Are JPS 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 MultispecialtyGroup 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, visitwww.jpshealthnet.org, www.jpshealthnet.org/careers,or www.teamacclaim.org. Job Description: Description: The Senior Business Intelligence Specialist leads complex projects and is a subject matter expert in 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 responsible for combining Hospital and ambulatory clinical and operational knowledge with information technology experience to lead highly complex business intelligence and dashboards request for our executives. Responsible for leading team members in developing business cases, gathering requirements, specifications, designing and developing solutions, testing, validation, configurations, implementation plans and overall management of project related activities for business intelligence solutions and dashboard for hospital and ambulatory executives. Typical Duties: Leads and independently analyzes and completes complex business intelligence data, report and dashboard requests and provides support for assigned applications and systems by performing workflow assessments, capturing business needs, and analyzing systems to determine functional requirements while mentoring other analysts. Leads and guides team on 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. 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. Leads the development of enterprise-wide KPIs and delivers data analytics and Business Intelligence solutions including methods to measure them. Leads the development of enterprise architecture recommendations for components relating to the data and analytics space; maintains BI tools & technology roadmaps & strategic vision. Collaborates with senior leadership and industry experts to understand how data needs to be converted, loaded and presented to drive strategic business value. Mentors and guides team members and the business of the capabilities of Business Intelligence; Considered an expert in this field. Leads as a Subject matter expert or PM on complex data projects to design and architect solutions, guides the development of test cases and scripts, manages project resources and ensures projects meet business and IT objectives. Owns the Enterprise Data Governance process, structure and methodologies collaborating with key business owners to drive enterprise decisions. Owns and maintains BI policy, procedure and standards with IT leadership. Leads complex system configuration changes related to Clarity database, ETL and Cogito Data warehouse upgrades and vendor related fixes and notifications. 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. Reviews and ensures final product for accuracy and completeness meeting management expectations. Plans and leads Reporting Infrastructure, ETL, and leverages BI Tools to develop complex data solutions. (Dashboards, SSIS, Data Marts, Universes and Cubes). Qualifications: Required Education and Experience: Bachelors Degree from a 4 year College or University or equivalent 6 plus years of IT strong relational database SQL/T-SQL reporting experience Preferred Education and Experience: 8 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