> Markdown version of [/jobs/ext/543675-business-intelligence-data-systems-architect](https://www.wearedevelopers.com/jobs/ext/543675-business-intelligence-data-systems-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Data Systems Architect - **Company:** Trillium Health Resources - **Location:** United States (Remote available) - **Experience:** Experienced - **Salary:** $70,338.0 - $93,711.0 - **Contract:** Permanent contract - **Skills:** .NET Framework, Amazon Web Services, Microsoft Azure, Business Systems, C Sharp (Programming Language), Data Dictionary, Extract Transform Load (ETL), Data Systems, Data Warehousing, Database Development, DevOps, IT Management, Information Technology Operations, Microsoft Data Access Components, Microsoft Visual Studio, Microsoft SQL Server, Windows PowerShell, Systems Development Life Cycle, Power BI, Software Deployment, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Sql Optimization, Information Technology, Data Analytics, Star Schema, Data Management, Tools for Reporting, SQL Server Management Studio (SSMS), Data Pipelines - **Published:** June 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=ab3c43bbd6ab95c7 ## About the Role Do you have a valid Driver's License license?, Do you have experience in Visual Studio?, Do you have a Associate's degree?, * 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. Preferred: * Degree in Information Technology / MIS, Mathematics (Actuarial/ Statistics), Engineering Sciences, Data Analytics, Business, Human Service field (such as Psychology, Social Work, etc.), and/or Healthcare Administration. * One or more of Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, Power BI, as well as INFORMS, IIBA, AWS, Azure or applicable certification(s) will be accepted. ## Description 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!, Trillium Health Resources has a career opening for a Business Intelligence Data System Architect to join our team! This is a technical and administrative position responsible for the research, development and maintenance of the Power BI Reporting Platform for Trillium. This will include configuration, implementation, design, and proactive support and management of the organization's Power BI Platform, as directed. Assists with assessing the organization's reporting needs and helping in the development of a long-term strategy for reporting. Leading, planning, coordinating, and administering activities relating to reporting systems development, documentation, and implementation. Provide technical support around systems capabilities to Information Technology projects. Provides training for IT and Trillium staff, as needed and directed. On a typical day, you might: * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer)