Full Stack Developer II

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 Full Stack Developer II to join our team! The Full Stack Developer II designs, develops, and maintains application solutions and applies independent judgment to implement features and resolve issues. The role contributes to system design, supports integration, and ensures reliable and scalable application performance. On a typical day, you might:

• Develop and maintain complex SQL code including stored procedures, functions, views, queries, and data-processing scripts to support business applications and operational processes.
• Analyze and troubleshoot database issues, including query performance, data discrepancies, failed processes, and production issues, and work with other technical teams to identify and resolve root causes.
• Work closely with Product Owners, Business Analysts, Application Developers, and QA teams to understand requirements, translate business needs into database solutions, and support the development and testing of new functionality.
• Design, modify, and optimize database structures and data processes, including tables, indexes, relationships, ETL/data movement processes, and SQL queries to ensure data integrity, accuracy, and performance.
• Participate in an Agile/Scrum development environment, attending daily stand-ups, sprint planning, backlog refinement, and reviews while managing assigned development work, code reviews, testing, documentation, and deployment activities.
• Develop and maintain API’s, integrations, and data processing components.

Required:

• Associate’s degree and six (6) years of experience in web development, including ASP.NET, C#, JavaScript, HTML, and Cascading Style Sheets (CSS), Azure DevOps, Structured Query Language (SQL), and Microsoft Internet Information Services (IIS) or Microsoft .NET framework. Requires certification; OR
• Equivalent combination of education and experience.
• An applicable information technology certification is required when qualifying through an Associate’s degree pathway.
• Microsoft applications certifications MTA, MCSA, MCSD or equivalent certifications will be accepted.
• Must have a valid driver’s license.
• Must reside within the United States.

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