Data Engineer Analyst

Revenue; Wake Crossroads (NC); Hybrid; USD 71,000 - 88,000; Full time

Benefits offered by this job

Pension plan

Twelve holidays per year

Vacation days increasing with service

Sick days

Parental Leave

Personal Observance Leave

Longevity pay

401K and 457 plans

Public Service Loan Forgiveness

Job summary

North Carolina Department of Revenue seeks a Data Engineer Analyst to support business intelligence initiatives, handling ETL data loads, data quality analysis, and report development. You will collaborate with IT professionals to translate business requirements into effective data solutions and develop end-to-end reports for internal customers.

The role involves end-to-end requirements gathering, testing, and production support, with hybrid or on-site work at the Raleigh headquarters.

Qualifications

• Bachelor's degree in computer science or IT-related field, or equivalent combination with experience.
• Experience with BI data loads, data quality, and reporting is valued.

Responsibilities

• Support BI initiatives with data loads via ETL, data cleansing, and report development.
• Develop and implement data solutions and reports for customers.
• Translate business requirements into technical solutions and present results to stakeholders.
• Create and execute test scripts and document findings.
• Provide daily and nightly support during peak periods.

Skills

SQL

PL/SQL

SAS

ETL

Ad hoc reporting

Windows/Unix

Education

Bachelor's degree in CS/IT or related field

Job description

Agency Dept of Revenue Division TRANSFORMATION MANAGEMENT OFFICE Job Classification Title Applications Systems Analyst I (NS) Position Number 60081369 Grade DT07

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.

This position is subject to federal and state criminal background checks that may include fingerprinting and verification of tax compliance.

To be considered within the most qualified pool of applicants and receive credit for your work history and credentials, you must document all related education and experience on the State of North Carolina application in the appropriate sections of the application form. Any information omitted from the application cannot be considered for qualifying credit.

Applicants eligible for veteran's preference should attach a copy of form DD-214.

Individuals with disabilities requiring disability-related accommodations in the interview process, please call the agency ADA Administrator at 919-986-9688.

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,161 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.

COMPENSATION & BENEFITS

• 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

Minimum Education and Experience

• Bachelor's degree in computer science or an IT related field from an appropriately accredited institution, or Associate degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and one year of experience in business application consulting or development, or High School or General Educational Development (GED) diploma and four years of experience in business application consulting or development; or an equivalent combination of education and experience.

EEO Statement

The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.

Additional Information

All job postings close at 11:59pm the night before the End Date on the posting.