Business Informatics Support Data Engineer

Pay Plan Title:Senior EngineerWorking Title:Business Informatics Support Data EngineerCost Center:4400/Information TechnologyPosition Number:91272FLSA Status:ExemptPosting Salary Range:$92,776 - $114,061Office Location:Remote within the United States.POSTING DETAILS:Make an ImpactTrillium 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 environmentCompetitive benefits and work-from-home options for most positionsOpportunities for professional growth in a diverse inclusive cultureEvery 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 ForTrillium 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 positionsHealth Insurance with no premium for employee coverageFlexible Spending Accounts24 days of Paid Time Off (PTO) plus 12 paid holidays in your first yearNC Local Government Retirement Pension (defined-benefit plan)https://www.myncretirement.gov/systems-funds/local-governmental-employees-retirement-system-lgers/lgers-handbook401k with 5% employer match and immediate vestingPublic Service Loan Forgiveness (PSLF) qualifying employerQuarterly stipend for remote work suppliesQualificationsRequired: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; OREquivalent 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,