Data Engineer Analyst

Adult Correction; North Carolina; Hybrid; USD 71,000 - 88,000; Full time

Benefits offered by this job

Health insurance

Pension plans

Paid holidays

Vacation days

Sick days

Parental Leave

Public Service Loan Forgiveness

Job summary

The North Carolina Department of Revenue seeks a Data Engineer Analyst to support BI initiatives. You will work with IT teams to perform data loads, ETL, data quality, reporting, and configuration across SAS, SQL, PL/SQL and UNIX/AIX.

The role includes gathering requirements, developing solutions, and presenting reports to customers. Hybrid or on-site at Raleigh HQ, with daily/nightly support during tax season and a commitment to excellence and customer service.

Qualifications

• Experience with SQL, PL/SQL, SAS in BI/Data Engineering.
• Experience with ETL processes and data cleansing.
• Ability to develop ad hoc reports using SQL/PL/SQL.
• Experience with SAS and Windows/Unix environments.
• Experience handling event-based logs and debugging complex systems.

Responsibilities

• Support BI initiatives through ETL data loads and data quality analysis.
• Develop and implement reports for internal customers.
• Provide daily/nightly support during peak tax periods.
• Translate business requirements into data solutions and end-to-end reports.

Skills

SQL

PL/SQL

SAS

ETL

Ad hoc reporting

Windows/Unix environments

Data analysis

Job description

About Us

The North Carolina Department of Revenue is committed to excellence in tax administration, ensuring secure and efficient collection of revenue to fund vital public services. We are an employer of choice offering excellent benefits, competitive pay, professional development, and career advancement. Our dedicated team provides accurate information, achieves high compliance, and delivers innovative services with integrity and fairness.

DOR is an equal opportunity employer hiring qualified candidates regardless of race, color, gender, national origin, religion, age, disability, or political affiliation.

Description of Work

***PLEASE NOTE: THIS WILL CLOSE AT 11:59 P.M. THE DAY PRIOR TO THE END DATE LISTED ON THIS JOB POSTING***

This position has flexibility and can be full-time telework, hybrid, or on-site at the headquarters building located in Raleigh.

The North Carolina Department of Revenue is seeking a self-starter Data Engineer Analyst to support our Business Intelligence initiatives. The Data Engineer Analyst work with a team of internal and external IT professionals to support customer business intelligence and data analysis initiatives through data loads using ETL processes, data quality analysis, data cleansing, application development, report development, and software installation and configuration. The work to be performed is identified and prioritized by the Department's business divisions and is implemented using structured project and software development lifecycle methodologies within the ITIL framework.

The Data Engineer Analyst's primary function is to support and perform application development in a diverse environment of applications that include SAS, SQL, PL/SQL, JAVA, and UNIX/AIX scripting. The position will participate in end-to-end customer requirements gathering, development and implementation, including identifying data input, data analysis and reporting needs as well as processing and exploring system data. The position will translate business requirements into the appropriate solution, develop the solution, develop reports, and present reports to customers. The position will create and execute test scripts and document findings. The position will provide daily and nightly (during Tax Season) operational support to customers and other IT initiatives as needed.

Knowledge Skills and Abilities/Management Preferences

• Knowledge of programming languages including SQL, PL/SQL, and SAS.
• Experience with extracting, transforming, and loading (ETL) data.
• Demonstrated ability to develop ad hoc reports using SQL and PL/SQL.
• Development and support experience in SAS and Windows/Unix environments.
• Experience working with systems processing event-based logs, user logs, and debugging complex systems.

Recruitment Range:

Recruitment Range: $70,528 and $88,16 1

COMPENSATION & BENEFITS:

The state of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis).

Some highlights include:

• The best funded pension plan/retirement system in the nation according to Moody's Investor's Service
• Twelve paid holidays per year
• Fifteen vacation days per year which increase as length of service increases and accumulates year-to-year
• Twelve sick days/year which are cumulative indefinitely
• Paid Parental Leave
• Personal Observance Leave and Community Service Leave
• Longevity pays lump sum payout yearly based on length of service
• 401K and 457 plans
• Eligibility for the Public Service Loan Forgiveness Program

Effective qualifications and screening

Effective July 1, 2025, candidates now meet the minimum qualifications of a position if they have the minimum education and experience listed from the class specification. The knowledge, skills, and abilities listed in the vacancy announcement should be used as management preferences and be used to screen for the most qualified pool of applicants.

The North Carolina Department of Revenue is committed to excellence in tax administration, ensuring secure and efficient collection of revenue to fund vital public services.

We are an employer of choice offering excellent benefits, competitive pay, professional development, and career advancement.

Our dedicated team provides accurate information, achieves high compliance, and delivers innovative services with integrity and fairness.

DOR is an equal opportunity employer hiring qualified candidates regardless of race, color, gender, national origin, religion, age, disability, or political affiliation.

This position is subject to federal and state criminal background checks that may include fingerprinting and verification of tax compliance. "Tax compliance" is defined as having filed and paid all North Carolina State taxes owed each year leading up t