Business Intelligence Data Systems Architect

Trillium Health Resources

Business Intelligence Data Systems Architect responsible for Power BI Reporting Platform development at Trillium Health Resources. Join a mission-driven organization impacting lives through tailored mental health services.

Posted 6/9/2026full-timeRemote • North Carolina • 🇺🇸 United StatesMid-LevelSenior💰 $70,338 - $93,711 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureETL.NETSQLSSIS

About the role

Key responsibilities & impact

Design, build, test, deploy, document, and maintain Power BI reporting solutions and semantic models, including the SQL queries, data pipelines, and dependent systems that power them—continuously assessing platform capabilities, performance, and governance.
Work with IT Leadership, Informatics - Data Management, IT Operations and IT - Business Systems on researching, developing, testing, deploying and documenting new methods and tools for ingestion, processing, sending and sharing of data.
Plan, coordinate and implement security measures (including regular audits) to safeguard information in reporting platforms and computer files against accidental or unauthorized damage, modification or disclosure.
Specify users and user access levels for each segment of the reporting platforms, as needed.
Select, develop and deploy code to monitor reporting platform performance
Develop reference and workflow documents for documentation purposes.
Revise agency definition of data as defined in data dictionary in regards to reporting and visualizations.

Requirements

What you’ll need

Associate’s degree and a minimum four (4) years’ experience in one or more of the following areas: healthcare claims environment and reporting development
demonstrated experience in n-tier development and support including Microsoft SQL database development including relational and star schema data warehouses
ETL, including the following software and tools: Power BI, SQL Server 2008 R2 or above, Visual Studio Professional\Enterprise 2017 or above, Azure Dev Ops, AWS, SSMS, SSRS, SSAS, SSIS, Advanced SQL, C#, .NET, PowerShell
Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements; OR Equivalent combination of education/experience
Two-year degrees require certification
Must have a valid driver’s license

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Power BISQLETLC#Advanced SQL.NETPowerShelln-tier developmentdata warehousingreporting development

Soft Skills

communicationcollaborationplanningcoordinationdocumentationsecurity awarenessperformance assessmentgovernance

Certifications

applicable certification