[Hiring] Business Intelligence Data Systems Architect @TRILLIUM HEALTH RESOURCES

Role Description

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.
• Assisting 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.
• Providing technical support around systems capabilities to Information Technology projects.
• Providing 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 SQL queries, data pipelines, and dependent systems.
• 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 data processing.
• Plan, coordinate and implement security measures (including regular audits) to safeguard information in reporting platforms.
• Specify users and user access levels for each segment of the reporting platforms.
• 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.

Qualifications

• 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.
• Experience with relational and star schema data warehouses, ETL, and 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.
• Must have a valid driver’s license.
• Must reside within North Carolina.
• Must be able to travel within catchment as required.

Requirements

• 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 (preferred).
• 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 (preferred).

Benefits

• 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).
• 401k with 5% employer match and immediate vesting.
• Public Service Loan Forgiveness (PSLF) qualifying employer.
• Quarterly stipend for remote work supplies.