Share this Job

Senior Programmer Analyst - Data Warehouse - Cincinnati, Ohio

City:  Cincinnati
State:  OH
Job Requisition Number:  270340

Attention current TriHealth employees:

Please apply for this position by submitting an online internal application via SuccessFactors. Please be certain to update your SuccessFactors Employee Profile prior to applying to this position.


TriHealth is actively recruiting for a Senior Programmer Analyst – Data Warehouse for our IT Department in Cincinnati, Ohio.


In this position, you will be the key interface in operationalizing data and analytics on behalf of the business unit(s) and organizational outcomes. This role will require both creative and collaborative working with IT and the wider business. It will involve evangelizing effective data management practices and promoting better understanding of data and analytics. You will also be tasked with working with key business stakeholders, IT experts and subject-matter experts to plan and deliver optimal analytics and data science solutions.


Additionally, you will be expected to collaborate with data scientists, data analysts and other data consumers and work on the models and algorithms developed by them in order to optimize them for data quality, security and governance and put them into production leading to potentially large productivity gains.


Responsibilities and Activities

  • Build data pipelines:
    • Architecting, creating, and maintaining data pipelines will be the primary responsibility
  • Drive Automation through effective metadata management:
    • Responsible for using innovative and modern tools, techniques, and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity. Also need to assist with renovating the data management infrastructure to drive automation in data integration and management. This will include (but not be limited to):
      • Learning and using modern data preparation, integration and AI-enabled metadata management tools and techniques.
      • Tracking data consumption patterns.
      • Performing intelligent sampling and caching.
      • Monitoring schema changes.
      • Recommending — or sometimes even automating — existing and future integration flows.
  • Collaborate across departments:
    • Will need strong collaboration skills in order to work with varied stakeholders within the organization. In particular, work in close relationship with data science teams and with business (data) analysts in refining their data requirements for various data and analytics initiatives and their data consumption requirements.
  • Educate and train:
    • Should be curious and knowledgeable about new data initiatives and how to address them. This includes applying their data and/or domain understanding in addressing new data requirements.
    • They will also be responsible for proposing appropriate (and innovative) data ingestion, preparation, integration, and operationalization techniques in optimally addressing these data requirements.
    • Will be required to train counterparts such as [data scientists, data analysts, LOB users or any data consumers] in these data pipelining and preparation techniques, which make it easier for them to integrate and consume the data they need for their own use cases.
    • Participate in ensuring compliance and governance during data use: Ensure that the data users and consumers use the data provisioned to them responsibly through data governance and compliance initiatives. work with data governance teams (and information stewards within these teams) and participate in vetting and promoting content created in the business and by data scientists to the curated data catalog for governed reuse.
    • Become a data and analytics evangelist: Will be considered a blend of data and analytics “evangelist,” “data guru” and “fixer.”
    • This role will promote the available data and analytics capabilities and expertise to business unit leaders and educate them in leveraging these capabilities in achieving their business goals.


To be qualified for this position, you must meet these minimum requirements:

    • Bachelor's degree in Information Systems or in a related field
    • 3-4 years of experience in Microsoft SQL Server database development, Tableau Dashboard development
    • Strong experience with analytics tools such as R, Python, develop ETL solutions using MS SQL 2014 or later database tools and SSIS in VS 2015 or later
    • Epic Data Model Certification or Net Health (Employee Health & Occupational Medicine) Data Model knowledge will be a plus
    • Tableau Dashboard development, QA testing, VB.NET or C# Web development experience would be a plus





Job Title:  Senior Programmer Analyst - Data Warehouse - Cincinnati, Ohio


Location:  Baldwin

Hourly/Salaried:  Salaried

Employment Status: Full Time Position

Bi-Weekly Hours:80

Shift: Day Shift

Weekend Commitment:  No

Holiday Commitment:  No

On-Call Commitment:  No

Nearest Major Market: Cincinnati

Job Segment: Clinic, Hospice, Palliative, EMR, Healthcare