Business Intelligence Data Systems Architect

Job not on LinkedIn

🔥 0 minutes ago

🌲 North Carolina – Remote

🌲 North Carolina – Remote

💵 $70.3k - $93.7k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

⚙️ Systems Engineer

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Trillium Health Resources

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

⚕️ Healthcare Insurance

Healthcare Insurance • Mental Health • Substance Use

Trillium Health Resources is a leading specialty care manager (LME/MCO) for individuals with serious behavioral health, intellectual/developmental disabilities, and traumatic brain injury in North Carolina. The organization is committed to investing in the health and well-being of the communities it serves, providing services such as preventive health screenings, crisis intervention, and tailored care management. Trillium focuses on enhancing access to mental health and substance use services for its members and ensuring support for vulnerable populations.

📋 Description

• 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

• 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

• 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