Develop and maintain the information reporting systems for Trillium's Provider Analytics and Performance Unit.
Development of SSRS, SQL/SSMS reports, Power BI Dashboards, and required documents.
Input into long range planning for the development, implementation, evaluation, and enhancement of Trillium’s value-based purchasing arrangements and performance improvement projects.
Ensure compliance with Trillium’s contract requirements.
Assist in the development of quality measurement, focusing on outcome-based metrics.
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.

High School Diploma/GED and three (3) years’ experience in 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 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.
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.

Provider Data Applications – Report Developer

Key skills