ETL and Reports Developer (Remote)

DMS Vision•Frisco, TX
•Remote

About The Position

The North Carolina Department of Health and Human Services seeks a senior ETL and reports developer to support implementation and maintenance of data extracts, ETL batch jobs, and reports for NC FAST, using the Cúram Software product and Oracle. The role involves business and systems analysis, modeling, design, and programming for FNS/SNAP reporting operations. The developer will analyze reporting requirements for the NC FAST Case Management System and implement recommendations for reports involving business metrics of mid to high complexity. Work includes designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, as well as enhancing existing extracts and reports to meet ongoing business needs. The role requires understanding underlying database sources and translating business requirements into analysis of operational issues and appropriate diagnostic or tracking data through reports and dashboards. Duties include gathering and documenting requirements for new and changed extracts and reports; developing complex queries against large tables containing CLOB/XML data, supporting data structures, and report layouts; and writing effective SQL queries that perform well against large tables. The developer will also analyze existing queries and reports, investigate and resolve issues, extract data, develop and analyze operational performance metrics, and help ensure extract quality and integrity through validation and audit strategies. The position includes responsibility for 24x7 on-call support on a rotation. The role is described as a 12-month contract, located remotely with an expectation of being local to Raleigh, NC and attending onsite once a month or quarterly.

Requirements

  • Experience building data analytics solutions using Azure Synapse serverless SQL pools.
  • Experience with data engineering using Azure Synapse Apache Spark Pools.
  • Experience configuring, designing, developing, and testing Power BI dashboards.
  • Experience using Oracle, Oracle Utilities, and ETL tools.
  • Experience with PL/SQL scripting and relational database modeling.
  • Experience with structured system development methodologies.
  • Ability to develop customer relationships and partnerships, respond to needs with urgency, and independently identify options.
  • Ability to organize, prioritize, and follow complex or detailed technical procedures.
  • Experience with Business Intelligence tools such as Business Objects or BIRT.
  • Experience with Agile development, including Scrum, Kanban, or SAFe.
  • Data warehouse experience.
  • Ability to lead and mentor a team and take ownership.
  • Experience with SQL queries and large tables, including tables storing CLOB/XML data.
  • Availability for 24x7 on-call support on a rotation.

Nice To Haves

  • Familiarity with Amazon RedShift and Tableau.
  • Experience with Dell Boomi.

Responsibilities

  • Analyze and identify reporting requirements for NC FAST Case Management System reports.
  • Implement recommendations for reporting business metrics of mid to high complexity.
  • Design, code, test, debug, and document data interfaces and reporting solutions.
  • Enhance existing data extracts and reports to ensure they continue to meet business needs.
  • Interpret business requirements and analyze operational issues using knowledge of underlying database sources.
  • Develop diagnostic or tracking data through reports and dashboards.
  • Gather and document requirements for new and changed data extracts and reports.
  • Develop complex queries against large tables storing CLOB/XML data, create supporting data structures, and develop report layouts.
  • Write effective SQL queries that perform well against large tables.
  • Analyze existing queries and reports, resolve issues, and extract data.
  • Develop and analyze operational performance metrics and reports.
  • Ensure the quality and integrity of extracts using validation and audit strategies.
  • Lead and mentor a team of technical reporting resources.
  • Provide 24x7 on-call support as part of a rotation.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service