Data Engineer Analyst

Location: Wake County, NC

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.

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.