Provider Data Applications & Report Developer
Job Description
Pay Plan Title: IT Applications/Report Developer
Working Title: Provider Data Applications & Report Developer
Position Number: 80023
FLSA Status: Exempt
Posting Salary Range: $ 72,262 - $ 100,715
Office Location: Remote within North Carolina
POSTING DETAILS:
Make an Impact
Trillium Health Resources is a Tailored Plan and Managed Care Organization (MCO) serving 46 counties across North Carolina. We manage services for individuals with serious mental health needs, substance use disorders, traumatic brain injuries, and intellectual/development (IDD) disabilities. Our mission is to help individuals and families build strong foundations for healthy, fulfilling lives.
Why Work for Us?
Trillium believes that empowering others begins with supporting our team. We offer our employees:
- A collaborative, mission-driven work environment
- Competitive benefits and work-from-home options for most positions
- Opportunities for professional growth in a diverse inclusive culture
Every day, our work changes lives – from children thriving through early intervention and school-based therapies, to adults with severe mental illness living independently and contributing to their communities.
If you are looking for a unique opportunity to make a tangible impact on the lives of others, apply today!
What We’re Looking For
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 the development of SSRS, SQL/SSMS reports, Power BI Dashboards, required documents, development of TP and PIHP required reporting, and input into long range planning for the development, implementation, evaluation, and enhancement of Trillium’s value-based purchasing arrangements and performance improvement projects. This position is also responsible for assuring compliance with Trillium’s contract requirements and will assist 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 by gathering requirements and delivering high-quality data solutions that support operational and strategic goals.
- Design, develop, maintain, and optimize SSRS reports, including SQL/SSMS, R or Python and Power BI dashboards to provide actionable insights for the Provider Analytics and Performance Unit and/or Network Management Department.
- 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.
Employee Benefits:
Trillium knows that work/life balance is essential. That’s why we offer:
- 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) https://www.myncretirement.gov/systems-funds/local-governmental-employees-retirement-system-lgers/lgers-handbook
- 401k with 5% employer match and immediate vesting
- Public Service Loan Forgiveness (PSLF) qualifying employer
- Quarterly stipend for remote work supplies
Qualifications
Required:
- 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 with strong technical knowledge in the 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 and Microsoft .NET framework2.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.; OR
- Associate’s degree in Information Technology/MIS, Mathematics (Actuarial/Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, or Human Service field and one (1) 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 with strong technical knowledge in the 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 and Microsoft .NET framework2.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.; OR
- Equivalent combination of education/experience.
- High School Diploma/GED and Associate’s degrees require certification. Applicable certification(s) including Microsoft data systems certifications, CSTP, ISTQB, ASTQB, MTA, MCSA, MCSD, MCSE, ITIL v3, Power BI, as well as INFORMS, IIBA, AWS, Azure, CSPA, Certified Machine Learning – Specialty (AWS), Predictive Analytics Certificate (SOA), and/or CPHIMS/CAHIMS or equivalent certifications will be accepted.
- Must have a valid driver’s license.
- Must reside within North Carolina.
- Must be able to travel within catchment as required.
Preferred:
- 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.
Deadline for Application: May 14, 2026 at 11:59 pm
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.
#Innovation #Technology #Careers #NorthCarolina #BehavioralHealth