Senior BI/ETL Engineer

Senior BI/ETL Engineer in NASHVILLE, TN

Ready to take your database development career to a new level?

We are one of Nashville's Top Places to Work and are growing rapidly here and in our market facilities. We have an exciting opportunity to join our BI/ETL Engineering team as a Senior Business Intelligence Developer focusing on backend development with SQL, SSIS, SSRS, and other database application development tools in a .Net environment. This is an excellent senior level opportunity that will also be heavily focused and trained on EPIC, our electronic medical records software product solution.

As a Senior BI/ETL Engineer, this position is responsible for the design, development, support, and execution of applications and solutions that support internal and external Ardent Health markets and customers. This role will be responsible for understanding the core technical components of Ardent's applications, database, and interface architectures and developing solutions that drive increased productivity, engagement, and customer satisfaction. The position is also a critical contributor to the support of diverse applications across the Ardent enterprise spanning many technology platforms and serving all business units.

Essential Duties:

  • Design, architect, develop, and maintain SSIS packages and SSIS batch jobs involving complex source data which will be used to drive clinical and patient care decision making requiring the highest degree of quality and accuracy.
  • Participate in Ardent's future state data warehouse development and associated conversions of data from acquired facilities.
  • Responsible for operational stability and tuning / management of developed applications and tools.
  • Estimate projects and enhancements to existing or new interfaces as part of project portfolio initiation process.
  • Mentor other developers as required and act as an SME where required.
  • Support Corporate / Divisional resources with functional support and modification / enhancement requests.
  • Respond to service requests in line with established SLAs and turnaround times.
  • Monitor and recommend required upgrades and enhancements to applications and infrastructure components of supported applications.
  • On-call support for critical applications.


  • Bachelor's Degree in Computer/Data Science or equivalent
  • 7+ Years of relevant experience designing and developing interactive data driven applications.
  • Proven track record of developing well-architected solutions that meet or exceed customer expectations.
  • Experience with all phases of the software development lifecycle (requirements gathering, design, development, testing, deployment, support).
  • Team player with a can-do approach to solving complex technical problems
  • 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 solutions that meet or exceed customer expectations.

Preferred Qualifications:

  • 10+ years of designing and developing interactive data driven applications.
  • Experience with MS SQL Server development
  • Experience in the development of ETL processes, T-SQL (stored procedures, triggers, views)
  • Experience with Visual Studio .NET technologies (MSDN, ASP, C#)
  • Experience with SSIS / SSRS architecture
  • Experience with Epic Systems or other EMR/EHR systems
  • Experience working within the healthcare industry
  • Experience with Windows O/S, TFS
  • Experience with MS SharePoint development
  • Experience in Healthcare IT / HL7 data standards.
  • Understanding of RUP, UML, OOAD, TOAD
  • Familiarity with BizTalk integration services