Data Engineer Analyst
About The Position
The North Carolina Department of Revenue is seeking a self-starting Data Engineer Analyst to support business intelligence initiatives. The position works with internal and external IT professionals to support customer business intelligence and data analysis through ETL data loads, data quality analysis, data cleansing, application and report development, and software installation and configuration. Work is prioritized by the Department’s business divisions and carried out using structured project and software development lifecycle methodologies within the ITIL framework. The role primarily supports and performs application development across a diverse environment that includes SAS, SQL, PL/SQL, Java, and UNIX/AIX scripting. The Data Engineer Analyst participates in end-to-end customer requirements gathering, development, and implementation; identifies data inputs, analysis, and reporting needs; and processes and explores system data. The position translates business requirements into solutions, develops those solutions and reports, presents reports to customers, and creates and executes test scripts while documenting findings. It also provides daily and, during tax season, nightly operational support to customers and other IT initiatives as needed. The position may be full-time telework, hybrid, or on-site at the headquarters in Raleigh. Employment is subject to federal and state criminal background checks, which may include fingerprinting and verification of tax compliance.
Requirements
- Knowledge of programming languages including SQL, PL/SQL, and SAS.
- Experience 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 that process event-based logs and user logs, and debugging complex systems.
- Bachelor's degree in computer science or an IT-related field from an appropriately accredited institution; or an associate degree in computer science, an IT-related field, or a related technical degree and one year of experience in business application consulting or development; or a high school or GED diploma and four years of experience in business application consulting or development; or an equivalent combination of education and experience.
Responsibilities
- Support business intelligence and data analysis initiatives through ETL data loads, data quality analysis, data cleansing, application development, report development, and software installation and configuration.
- Support and perform application development using technologies including SAS, SQL, PL/SQL, Java, and UNIX/AIX scripting.
- Participate in end-to-end customer requirements gathering, development, and implementation.
- Identify data input, data analysis, and reporting needs, and process and explore system data.
- Translate business requirements into appropriate solutions and develop those solutions.
- Develop reports and present them to customers.
- Create and execute test scripts and document findings.
- Provide daily and, during tax season, nightly operational support to customers and other IT initiatives as needed.
Benefits
- Health insurance options
- Standard and supplemental retirement plans
- NCFlex program with pre-tax benefits
- Twelve paid holidays per year
- Fifteen vacation days per year, increasing with length of service and accumulating year to year
- Twelve sick days per year, cumulative indefinitely
- Paid parental leave
- Personal observance leave
- Community service leave
- Annual longevity pay as a lump-sum payout based on length of service
- 401K and 457 plans
- Eligibility for the Public Service Loan Forgiveness Program
- Professional development and career advancement
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
