Description of Work This is a repost for position 60081335. Candidates remain under consideration and do not need to reapply.
Pay Grade: DT07 Recruitment Range: $64,004.00 - $80,067.00
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 will work with a team of internal and external IT professionals to support customer business intelligence and data analysis initiatives through data gathering, cleansing, loading, quality analysis, application development, and query and report development. The work to be performed is identified and prioritized by the Department’s business divisions and is implemented using a structured software development lifecycle methodology within the ITIL framework.
This position’s primary function is to support and perform application development in a diverse environment that includes 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 analysis needs as well as processing and exploring system data. The position will translate business requirements into analytic methods, build analytics models and packages, develop reports, and present information to customers. The position will create and execute test scripts and document findings. The position will provide daily operational support to customers and other IT initiatives as needed.
About the Department:
At the North Carolina Department of Revenue, our mission is to fund public services benefiting the people of North Carolina. We administer the tax laws and collect taxes due in an impartial, consistent, secure, and efficient manner. Together, we are a SMART organization because we: Safeguard customer information; Maintain a knowledgeable workforce; Achieve a high level of understanding and compliance; Respond with accurate information through innovative services; and Treat our customers fairly. Through modernization efforts in technology, we believe we've set a high standard that other agencies will admire. As an employer, we offer excellent benefits, a stable work environment, competitive salaries, defined career paths, and training programs that will enable you to be successful.Knowledge, Skills And Abilities / Competencies
- Demonstrated knowledge of programming languages, e.g. SQL, Oracle, and JAVA.
- Demonstrated knowledge of Oracle databases.
- ETL experience and expertise with Linux/Unix.
- Thorough knowledge and understanding of business systems theories, processes, rules and regulations and how they apply to technology in the applicable area(s).
- Demonstrated experience in application design, software development, testing, and working with systems processing event-based logs, user logs, and debugging of complex systems.
- Demonstrated experience with design and implementation of systems for providing data to stakeholders, ensuring correctness and consistency.
Minimum Education And Experience Requirements
- 3+ years of experience with SAS, Oracle, or JAVA Development and performing quantitative analysis using SAS Business Intelligence tools.
- Development and support experience in SAS, Windows UNIX environment
- In-depth knowledge of business systems, regulations and processes and their interaction and how they apply to technology in the applicable area(s).
- Experience administering other database platforms such as MSSQL and MYSQL.
- Experience with developing ad hoc reports using SQL, PL/SQL.
- ITIL Foundations certification.
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.
Supplemental and Contact Information
The Department of Revenue seeks to fill positions with the most qualified individuals in its effort to provide taxpayers with the most efficient and effective services possible.
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 to the current calendar year or currently in a non-delinquent payment status with the State of North Carolina on taxes that are currently owed to the state.
If selected for an interview, you may have the option to interview via telephone and/or other method as technology allows.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. NC DOR welcomes attached resumes, cover letters and reference information, but these items will not be used for screening for qualifying credit. Please make sure the application is completed in full. See Resume or See Attachment will NOT be accepted.
Applicants eligible for veteran's preference should attach a copy of form DD-214.
If you are having technical issues logging into your account or applying for a position, please review the Get Help/FAQ's information on the website. If you are still experiencing technical issues with your application, please call the NeoGov Help Line at 855-524-5627.
If you have general questions about the application process, you may contact Human Resources at 919-814-1200 or HumanResources@ncdor.gov . Individuals with disabilities requiring disability-related accommodations in the application and interview process, please call 919-814-1172.
NC Department of Revenue
Human Resources Division