Provider Data Applications & Report Developer

TRILLIUM HEALTH RESOURCES

2d•Remote

About The Position

Trillium Health Resources is seeking a Provider Data Applications & Report Developer to join their Provider Analytics and Performance Unit. This role is responsible for developing and maintaining information reporting systems, including SSRS, SQL/SSMS reports, and Power BI Dashboards. The position will also contribute to long-range planning for value-based purchasing arrangements and performance improvement projects, ensuring compliance with contract requirements and assisting in the development of quality measurement with a focus on outcome-based metrics. The work directly impacts individuals and families by supporting services for those with serious mental health needs, substance use disorders, traumatic brain injuries, and intellectual/developmental disabilities.

Requirements

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 with strong technical knowledge in 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.
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 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 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#.
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.

Nice To Haves

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/IDD service array and benefits offered by various funding sources and provided through a network of providers.
Working knowledge of the HCP-LAN APM Framework.

Responsibilities

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.