[Hiring] Provider Data Applications & Report Developer @TRILLIUM HEALTH RESOURCES

Role Description

Trillium Health Resources has a career opening for a Provider Data Applications & Report Developer to join our team! The Provider Data Applications & Report Developer is responsible for the development and maintenance of the information reporting systems for Trillium’s Provider Analytics and Performance Unit. This involves:

• Development of SSRS, SQL/SSMS reports, Power BI Dashboards, and required documents.
• Development of TP and PIHP required reporting.
• Input into long-range planning for the development, implementation, evaluation, and enhancement of Trillium’s value-based purchasing arrangements and performance improvement projects.
• Assuring compliance with Trillium’s contract requirements.
• Assisting in the development of quality measurement, focusing on outcome-based metrics.

On a typical day, you might:

• Collaborate with business units to understand data needs and translate them into effective reporting solutions.
• Design, develop, maintain, and optimize SSRS reports, including SQL/SSMS, R or Python, and Power BI dashboards.
• Write, optimize, and troubleshoot SQL queries to extract, transform, and analyze data from various sources.
• Ensure data accuracy, consistency, and integrity across all reporting platforms.
• Support ad hoc data requests and provide timely, insightful analysis to Network Management.

Qualifications

• High School Diploma/GED and three (3) years’ experience in any of the following areas:
  • Information Technology / MIS
  • Mathematics (Actuarial/Statistics)
  • Data Analytics
  • Engineering Sciences
  • Business
  • Healthcare Administration
  • Human Service field
  • Healthcare claims environment
  • Reporting development
  • n-tier and web-based system development or support
• Strong technical knowledge in specialized areas of application system programming, including software tools such as:
  • SQL Server 2016 R2 or above
  • SQL
  • Oracle
  • NoSQL
  • MySQL
  • TFS (Team Foundation Server)
  • Microsoft IIS
  • Microsoft .NET framework 2.0 or above
  • Source Control
  • SSRS, SSIS, SSAS, SSMS
  • Visual Studio BIDS, Visual Studio 2016 or above
  • C#
• Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements.
• Must have a valid driver’s license.
• Must reside within North Carolina.
• Must be able to travel within catchment as required.

Requirements

• Recent experience with SQL database management or report development.
• Experience with SPSS, SPSS-X, R, Python, or similar software and/or Microsoft Power BI.
• Experience with standard coding and structures like CPT, ICD, etc.
• Experience in managed care organization/environment or clinical setting.
• Working knowledge of the MH/SU/IDD service array and benefits offered by various funding sources and provided through a network of providers preferred.
• Working knowledge of the HCP-LAN APM Framework.

Benefits

• Typical working hours: 8:30 am – 5:00 pm; flexible work schedules with some roles with management approval.
• Work-from-home options available for most positions.
• Health Insurance with no premium for employee coverage.
• Flexible Spending Accounts.
• 24 days of Paid Time Off (PTO) plus 12 paid holidays in your first year.
• NC Local Government Retirement Pension (defined-benefit plan).
• 401k with 5% employer match and immediate vesting.
• Public Service Loan Forgiveness (PSLF) qualifying employer.
• Quarterly stipend for remote work supplies.

How to Apply

To be considered, submit your application and resume through our ADP Career Center. Your resume must include:

• Employer name, dates of service (month/year), average hours worked per week, and essential job duties.
• Education details (degree type, date awarded, institution, field of study).
• Licensure/certification information, if applicable.

After submission, your resume will be reviewed to ensure it meets the essential criteria for the position. You’ll be notified by HR regarding your application status as appropriate. All applicants will receive a final update once the recruitment cycle closes.

Join our Talent Community through ADP to stay informed about future opportunities. Be sure to keep your resume updated in your profile.

Trillium Health Resources is an Equal Employment Opportunity (EEO) employer and a drug-free workplace. All candidates must pass a drug test as a condition of employment.