Business Intelligence Data Systems Architect

CL 10dcd17e b903 4bb0 a0c9 b6c8c64ce1dd; United States; Remote; USD 73,000 - 97,000; Full time

Benefits offered by this job

Work-from-home options

Health Insurance with no premium

401k with 5% employer match

PTO + holidays

Job summary

Trillium Health Resources in the United States is seeking a Business Intelligence Architect to lead the design, development and maintenance of the Power BI reporting platform. This role focuses on configuration, implementation, and governance to deliver actionable insights.

You will collaborate with IT leadership and data teams, implement security measures, define user access, and produce documentation and training to empower staff and improve reporting across the organization.

Qualifications

• Associate's degree and 4 years in IT, data analytics, or reporting development with SQL and data warehousing.
• Equivalent combination of education and experience.
• Must reside within the United States.

Responsibilities

• Design, build, test, deploy, document Power BI reports and models, including SQL queries and data pipelines.
• Collaborate with IT leadership and data teams to research, test, deploy, and document new data ingestion and processing methods.
• Plan and implement security controls to protect reporting data and access.
• Define user access rights for reporting platforms.
• Develop and deploy code to monitor Power BI platform performance.
• Create reference/workflow documents for governance and documentation.
• Review data definitions in the data dictionary for reporting.

Skills

Power BI

SQL

Data analytics

Data modeling

ETL

Education

Associate's degree

Tools

Power BI

Job description

Pay Plan Title: Business Intelligence Architect

Working Title: Business Intelligence Architect

Position Number: 13002

FLSA Status: Exempt

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

Office Location: Remote within United States

POSTING DETAILS:

Make an Impact

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.

What We’re Looking For

Trillium Health Resources has a career opening for a Business Intelligence 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.

Employee Benefits:

Trillium knows that work/life balance is essential. That's why we offer:

• Typical working hours: 8:30 am - 5:00 pm; flexible work schedules with some roles with 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) https://www.myncretirement.gov/systems-funds/local-governmental-employees-retirement-system-lgers/lgers-handbook
• 401k with 5% employer match and immediate vesting
• Public Service Loan Forgiveness (PSLF) qualifying employer
• Quarterly stipend for remote work supplies

Qualifications

Required:

• 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; OR
• Equivalent combination of education and experience.
• Two-year degrees require certification.
• Must have a valid driver's license.
• Must reside within the United States.

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.

Deadline for Application: October 2, 2026 at 11:59 pm

Trillium Health Resources is an Equal Employment Opportunity (EEO) employer and a drug-free workplace. All candidates must pass a drug test as a condition of employment.