Pay Plan Title: Senior Engineer
Working Title: Business Informatics Support Data Engineer
Cost Center: 4400/Information Technology
Position Number: 91272
FLSA Status: Exempt
Posting Salary Range: $92,776 - $114,061
Office Location: Remote within the 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.
If you are looking for a unique opportunity to make a tangible impact on the lives of others, apply today!
What We’re Looking For
Trillium Health Resources has a career opening for a Business Informatics Support Data Engineer to join our team! The Business Informatics Support Data Engineer is a highly skilled, collaborative, and technical position responsible for the development and maintenance of reporting systems for Trillium. This role is dedicated to supporting business operations through the development of scalable data solutions using SQL, SSRS, and Power BI. This role will be a primary in the design and support of the Data Warehouse. In addition to technical development, this position will be responsible for maintaining up-to-date documentation in the team wiki and providing mentorship and support to other Business Informatics and Business reporting team members, as needed.
On a typical day, you might:
- Participate in the design and support of the Data Warehouse.
- Collaborate with business units to understand data needs and translate them into effective reporting solutions by gathering requirements and delivering high-quality data solutions that support operational and strategic goals.
- Develop, maintain, and optimize SSRS reports and Power BI dashboards to provide actionable insights.
- Write and troubleshoot SQL queries to extract, transform, and analyze data from various sources.
- Ensure data accuracy, consistency, and integrity across all reporting platforms.
- Write and optimize SQL queries for data extraction, transformation, and analysis.
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 any of the following areas: Information Technology/MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Service field, healthcare claims environment and reporting development, n-tier and web-based system development and support with strong technical knowledge in the specialized areas of application system programming, including software and tools including; SQL Server 2016 or above, SQL, My SQL, Azure DevOps, Source Control, SSRS, SSIS, SSMS, Visual Studio 2016 or above, C# and Microsoft.NET Framework 4.0 or above. 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.
- Must reside within United States.
Preferred:
- Degree in Information Technology/MIS, Mathematics (Actuarial/Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, or Human Service field.
- Recent experience with SQL database management and development (i.e. Power BI, Analytical, R, Python, Visual Studio, and/or SSRS).
- Knowledge or experience with one or more of the following technologies: NoSQL, Snowflake, Databricks, Mongo, or Hadoop.
- Applicable certification(s) including Microsoft data systems certifications, CSTP, ISTQB, ASTQB, MTA, MCSA, MCSD, MCSE, ITIL v3, Power BI, as well as INFORMS, IIBA, AWS, Azure, or equivalent certifications will be accepted.
Deadline for Application: August 13, 2026@11:59pm
How to Apply
To be considered, submit your application and resume through our ADP Career Center. Your resume must include:
- Employer name, dates of service (month/year), average hours worked per week, and essential job duties
- Education details (degree type, date awarded, institution, field of study)
- Licensure/certification information, if applicable
After submission, your resume will be reviewed to ensure it meets the essential criteria for the position. You’ll be notified by HR regarding your application status as appropriate. All applicants will receive a final update once the recruitment cycle closes.
Join our Talent Community through ADP to stay informed about future opportunities. Be sure to keep your resume updated in your profile.
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.
#Innovation #Technology #Careers #NorthCarolina #BehavioralHealth
Skills Required
- Associate's degree and four (4) years of relevant experience in IT/MIS, Data Analytics, or related field, or equivalent combination of education/experience.
- Applicable certification required (may substitute for degree/experience); two-year degrees require certification.
- Experience with SQL Server 2016 or above.
- Proficiency in SQL for data extraction, transformation, and analysis.
- Experience with MySQL.
- Experience with Azure DevOps and source control.
- Experience developing and maintaining SSRS reports.
- Experience with SSIS (ETL).
- Experience using SSMS (SQL Server Management Studio).
- Experience with Visual Studio 2016 or above.
- Proficiency in C# and Microsoft .NET Framework 4.0 or above.
- Valid driver's license.
- Must reside within the United States.
- Ability to maintain up-to-date documentation and mentor other team members.
What We Do
Trillium Health Resources manages specialty behavioral health care for North Carolinians across 46 counties. Trillium is committed to transforming lives and building community well-being through partnership, access to services and proven solutions designed to help those we serve reach their fullest potential. Everyone on Trillium’s staff--our care managers, call center, claims agents, project managers, and IT staff--all contribute to this mission. We offer a challenging, engaging work environment where staff take home more than a paycheck. Our performance management plan includes regular check-ins to examine individual employee goals and professional development plan. Our departments work on cross-functional, short-term projects and long ranging initiatives. Every day we see the results of our dedication, in the smiles of children on our accessible playgrounds and pride on the face of an adult cooking a meal for the first time. By joining Trillium, you are doing more than going to work…you are transforming lives. We help those with mental health conditions, intellectual and developmental disabilities, traumatic brain injury, and substance use disorders (Medicaid members and state-funded recipients) get the services they need to improve well-being and live fulfilling lives. We are dedicated to carrying out our mission by investing in the health and well-being of the communities we serve and empowering individuals with access to services, tools and resources to live a fulfilling life. Trillium reserves the right to hide material (comments, images and/or links to other sites) that contains anything vulgar or sexually explicit; is spam; advocates or depicts illegal activity; targets or disparages any ethnic, racial, other type of group; contains personal attacks of any kind; promotes private business ventures, services, or products; campaigns for public office or promotes a political organization; infringes on copyrights or trademarks; or is off topic.
