IT Applications/Report Developer (Data Engineer)

Pay Plan Title: IT Application/Report Developer

Working Title: Data Engineer

FLSA Status: Exempt

Posting Salary Range: $62,221 - $98,220

Office Location: Remote in NC

POSTING DETAILS:

Make an Impact  

Trillium Health Resources is a local governmental agency (LME/MCO) in North Carolina that manages serious mental health, substance use, and intellectual/developmental disability services. Serving in 46 counties, we help individuals and their families strengthen well-being and build foundations for a healthy life.

Join our team as we empower others to live their best lives by providing access to quality healthcare. We offer a challenging, engaging work environment where staff take home more than a paycheck. Every day, we see the results of our dedication – in the smiles of children on our accessible playgrounds and in the pride on the face of an adult cooking a meal for the first time. Working at Trillium Health Resources is more than just a job; it is an opportunity to make a direct impact on the communities we serve.

At Trillium, we know that empowering others begins with supporting and developing our team. That’s why we offer competitive benefits and work-from-home flexibility so that our employees thrive outside of the office. We’re also committed to building a diverse, inclusive culture where all employees have the potential to grow professionally and personally.

What We’re Looking For

This is a technical position responsible for the development and maintenance of the information reporting systems for Trillium. This involves the development of SSRS reports, required documents, stored procedures, and input into long-range planning for the enhancement, upgrade or change in reporting information systems. Employee will be responsible for developing reports, assisting the Trillium data analysts and management. Employee will be responsible for the management of all aspects of reporting including SSRS, SSMS, SSIS, Power BI, and third-party solutions.

On a typical day, you might:

• Design, Develop and Maintain Trillium reports and pertinent Reporting platforms, including SQL/SSRS, Power BI, SSMS/SSRS and third-party solutions.
• Coordinate with Informatics and Data Science staff, as needed.
• Implement Business rules. 
• Will assist with creating reports, data mining and data management.
• Uses various analytical programs such as R or Python to support reporting functionality.
• Test programs or reporting, correct errors and make necessary modifications. 

Employee Benefits:

Trillium knows that work/life balance is important. That’s why we offer our employees competitive benefits and flexibility that is second to none. Take a look at what we have to offer:

• A remote work option available for most positions
• Health Insurance - no premium for employee coverage
• Flexible Spending Accounts
• Paid Time Off (PTO) of 24 days, plus 12 paid holidays within first year of employment
• NC Local Government retirement pension. This is a defined-benefit retirement plan that will pay you a monthly amount upon retirement, for the rest of your life, with as little as five years of service. For more information, go to: https://files.nc.gov/retire/documents/files/Actives/LGERSHandbook.pdf
• 401k with 5% employer match & immediate vesting
• Public Service Loan Forgiveness Qualifying Employer

Qualifications: 

Education: High School (requires certification) / OR Associate’s degree (requires certification)

Experience: 

• High School diploma and three (3) years’ experience in any of the following areas: Information Technology / MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Service or Science fields, healthcare claims environment, reporting development, n-tier and web-based system development or support with strong technical knowledge in the specialized areas of application system programming, including software tools such as: SQL Server 2008 R2 or above, SQL, Oracle, NoSQL, MySQL, TFS (Team Foundation Server), Microsoft IIS and Microsoft .NET framework2.0 or above , Source Control, SSRS, SSIS, SSAS, SSMS, Visual Studio BIDS, Visual Studio 2008 or above, C#. Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements. OR
•  Associate’s degree and a minimum one (1) year experience in any of the following areas: Information Technology / MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Service or Science fields, healthcare claims environment, reporting development, n-tier and web-based system development or support with strong technical knowledge in the specialized areas of application system programming, including software tools such as: SQL Server 2008 R2 or above, SQL, Oracle, NoSQL, MySQL, TFS (Team Foundation Server), Microsoft IIS and Microsoft .NET framework2.0 or above , Source Control, SSRS, SSIS, SSAS, SSMS, Visual Studio BIDS, Visual Studio 2008 or above, C#. Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements. OR
•  Equivalent combination of education/experience.

Preferred Experience (if applicable): Recent experience with SQL database management or report development (Power BI, Analytical, R, Python, Visual Studio and /or SSRS) preferred.

License/Certification:  High School and Associate’s requires certification (as listed below)

Preferred (if applicable): 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.

Must have a valid driver’s license

Must reside in North Carolina to be considered for Remote Status.

Deadline for application: Friday, February 14, 2025 at 11:59 p.m.

To be considered for employment, all candidates are required to submit an application through ADP and upload a current resume.  Your resume must provide your level of education and detailed work experience, including: 

• Employer Name
  1. Dates of service (month & year)
  2. Average number of hours worked per week
  3. Essential duties of the job as related to the position you’re applying for
• Education
  1. Degree type
  2. Date degree was awarded
  3. Institution
• Licensure/certification, if applicable

After submitting your application through our career center in ADP, your resume will be reviewed to ensure that your skills and experience meet the essential criteria for the role you have applied for.

Join our Talent Community through our ADP career center to stay informed about positions you may qualify for. Remember to keep an update resume in the Talent Community profile. 

The diversity of the communities we serve is reflected in our employees. Trillium Health Resources is an Equal Employment Opportunity (EEO) employer.

Trillium Health Resources is a drug-free workplace. Candidates are required to pass a drug test as a condition of employment.

#Innovation  #Technology  #Careers  #NorthCarolina  #BehavioralHealth