Business Intelligence Developer

Ardent Health is a leading provider of healthcare in growing mid-sized urban communities across the U.S. With a focus on people and investments in innovative services and technologies, Ardent is passionate about making healthcare better and easier to access. Through its subsidiaries, Ardent delivers care through a system of 30 acute care hospitals, 24,000+ team members and more than 280 sites of care with over 1,800 affiliated providers across six states.

POSITION SUMMARY

The Business Intelligence Developer is responsible for the design, development, support, and execution of reports, dashboards, and solutions that support Ardent Health's market and corporate customers. This role is also responsible for understanding the core technical components of Ardent's applications, databases, and developing solutions to drive increased productivity, engagement, and customer satisfaction

• Design, develop, and maintain extracts from Epic's Clarity & Caboodle databases utilizing SSIS and our sFTP program GoAnywhere.
• Participate in agile meetings (e.g. daily scrums, retrospectives, backlog grooming, and sprint planning).
• Complete all tasks in a timely manner with accurate documentation.
• Responsible for gathering requirements, creation, operational stability, tuning, and management of reports and dashboards utilizing Epic reporting tools and PowerBI.
• Participate in Epic upgrades, implementations and other large Epic initiatives.
• Provide corporate and market resources with support and enhancements for Reporting Workbench, SlicerDicer, and PowerBI reporting tools.
• Respond to support tickets in line with established turnaround times.
• On-call support rotation for critical applications and reports.

Education & Experience:

• Bachelor's Degree in Computer/Data Science or equivalent work experience.
• Work experience and certification in Epic Clarity and Caboodle data models.
• Epic certification in the Clinical and/or Access data model tracks, preferred.
• Epic Reporting experience including working with various reporting tools (Reporting Workbench, SlicerDicer, Radar, & PowerBI).
• 3+ years of designing and developing ETL and/or reporting from SQL Server.
• Experience with all phases of the software development lifecycle (requirements gathering, design, development, testing, deployment, support).
• 5+ years of designing and developing ETL and reporting from SQL Server, preferred.
• Experience in the development of ETL processes via SSIS and sFTP, preferred.
• Experience working within the healthcare industry, preferred.
• Experience with Git source control, preferred.
• Experience with PowerBI, preferred.

Knowledge, Skills & Abilities:

• Team player with a can-do approach to solving complex technical problems
• Support Epic application teams by keeping them abreast of new functionality and learning their new build
• Ability to consult with business leaders directly through development of positive working relationships
• High degree of critical thinking along with the ability to be an innovative problem solver who works independently in a fast-paced environment
• Proven track record of developing well-architected solutions that meet or exceed customer expectations