IT Applications/Report Developer (Data Engineer) (Remote)

Pay Plan Title: IT Applications/Report Developer

Working Title: Data Engineer

FLSA Status: Exempt

Posting Salary Range: $51,000 - $80,505

Office Location: Remote and/or with office location in Wilmington, 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 28 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

Trillium Health Resources is transforming public health in North Carolina by managing the health needs of many of the state’s most vulnerable populations. After successfully implementing managed care for mental health, substance use, and intellectual/developmental disabilities in the early 2010s, we’re currently implementing a groundbreaking new type of Medicaid health plan that focuses on people’s physical health needs, as well as factors like housing and food insecurity that can affect health.

We’re seeking a Data Engineer who wants to grow their IT career by helping us implement this new model. You’ll work directly with team members from all parts of our organization, on everything from Medicaid claims processing, to finance and accounting, to quality improvement and population health management.

On a typical day, you might:

• Use SQL to:
  1. Create a report that helps assess the health of our provider network
  2. Create a report that identifies pregnant members and directs them to targeted prenatal services
• Use R/R-Studio, Python, or Power BI to design an interactive COVID-19 dashboard
• Help onboard a new 3rd-party reporting tool by conducting end-user testing and creating a maintenance plan
• Use Azure DevOps, TFS, or other software development/project management tools to:
  1. Respond to requests from internal partners,
  2. Document and track your progress on outstanding work
  3. Maintain version control for reports and other code
• Develop a data dictionary for a new line of business, such as physical or pharmacy claims data
• Customize a data set(commercial or open) to fit Trillium’s requirements
• Plan, coordinate, and implement a new set of security measures to safeguard HIPAA-protected member data

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:

• Flexible Work Schedules. Remote work was a strong part of our culture prior to COVID-19, and currently, employees may work remotely 100% of the time, with an in-office option available for those who prefer that.
• Paid Time Off (PTO) of 23 days per year, plus 10 paid holidays both in first year of employment
• Health Insurance - no premium for employee coverage
• 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
• Flexible Spending Accounts

Qualifications:

Education: Associate’s degree. Major: Information Technology / MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, or Human Service field. Applicable certification(s) may be substituted to equivalent degree requirements. 2-year degrees require certification.

Experience: Minimum of four (4) years’ 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, 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# or equivalent of higher education or higher education/experience.

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

License/Certification: Two year degrees require certification.

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 NC

Deadline for application: Closes at 11:59 p.m. Monday, November 28, 2022.

To be considered for employment, all candidates are required 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.

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.