Business Intelligence Data Systems Architect

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/developmental disabilities (IDD). Our mission is to help individuals and families build strong foundations for healthy, fulfilling lives.

About the role

This is a technical and administrative position responsible for the research, development, and maintenance of the Power BI Reporting Platform for Trillium. Responsibilities include configuration, implementation, design, and proactive support and management of the organization’s Power BI Platform. The role involves assessing the organization's reporting needs and helping develop a long-term reporting strategy, leading and coordinating reporting systems development, documentation, and implementation, and providing technical support for IT projects.

Responsibilities

• Design, build, test, deploy, document, and maintain Power BI reporting solutions and semantic models, including SQL queries, data pipelines, and dependent systems. Continuously assess platform capabilities, performance, and governance.
• Work with IT Leadership, Informatics - Data Management, IT Operations, and IT - Business Systems to research, develop, test, deploy, and document new methods and tools for data ingestion, processing, sending, and sharing.
• 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.
• Develop and deploy code to monitor reporting platform performance.
• Create and revise reference and workflow documents, including updates to the agency’s data dictionary for reporting and visualizations.
• Provide training for IT and Trillium staff as needed.

Qualifications

• Associate's degree and four (4) years of experience in information technology, data analytics, or reporting development with knowledge of n-tier development and support, including relational and data warehouse development, extract-transform-load processes, and Structured Query Language (SQL). Requires certification.
• Equivalent combination of education and experience. Two-year degrees require certification.
• Must have a valid driver’s license and reside within the United States.

Preferred Qualifications

• 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 Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, Power BI, as well as INFORMS, IIBA, AWS, Azure, or applicable certification(s).

Benefits

• Typical working hours: 8:30 am – 5:00 pm; flexible work schedules with some roles requiring 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).
• 401k with 5% employer match and immediate vesting.
• Public Service Loan Forgiveness (PSLF) qualifying employer.
• Quarterly stipend for remote work supplies.

Pay

Posting Salary Range: $73,151 - $96,914