Data Engineer Analyst
North Carolina Department of Revenue
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
The North Carolina Department of Revenue is seeking a Data Engineer Analyst to support BI initiatives, data loads via ETL, and reporting for internal and external customers. You will work within the ITIL framework and collaborate with IT professionals across teams.
Responsibilities include data analysis, requirements gathering, and building reports. The role offers telework, hybrid, or on-site options at the Raleigh headquarters with a focus on SAS/SQL/PL-SQL development and data quality
Qualifications
- 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.
Responsibilities
- Support BI initiatives through ETL processes, data analysis, and reporting needs.
- Translate business requirements into solutions and develop reports for customers.
- Provide daily/ nightly operational support during tax season as needed.
Skills
Education
Tools
Job description
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.
Dept of Revenue
TRANSFORMATION MANAGEMENT OFFICE
Applications Systems Analyst I (NS)
60081369
DT07
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.
- 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 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: $70,528 and $88,161
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).
- 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
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 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.
Some state job postings say you can qualify by an “equivalent combination of education and experience.” If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details. 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.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
