Data Engineer
Arts In Wilmington, Raleigh, NC, United States
**Agency**Dept of Health and Human Services**Division**SEC OFFICE - INFO TECH - NC FAST**Job Classification Title**Applications Systems Analyst II (NS)**Position Number**60038103**Grade**DT09The North Carolina Department of Health and Human Services (DHHS) is one of the largest, most complex agencies in the state, and has approximately 17,000 employees. It is responsible for ensuring the health, safety, and well-being of all North Carolinians, providing human service needs for special populations including individuals who are deaf, blind, developmentally disabled, and mentally ill, and helping poor North Carolinians achieve economic independence.**Description of Work**The primary purpose of this position is to provide business analysis, system analysis, programming, and production support for complex applications and data systems within the organizational unit. This position is responsible for designing, developing, enhancing, and supporting enterprise applications, integrations, and data pipelines across both Microsoft-based systems and modern cloud data platforms.
This role performs technical duties including leading requirement-gathering sessions; developing functional and technical requirements; designing new complex programs; analyzing and modifying existing systems; building and optimizing data pipelines; performing system administration and configuration; writing detailed specifications; developing and executing test plans; and monitoring application performance to prevent avoidable production interruptions.
The position works closely with stakeholders across Product, Operations, and Engineering to translate business needs into automated solutions, governing data models, and decision-grade reporting delivered through Power BI or similar BI tools. Work includes diagnosing data issues, reconciling multi-source systems, and validating data quality.**Knowledge Skills and Abilities/Management Preferences**## **Salary Grade Range: $81,504.00 - $122,256.00**## **Recruitment Range: $81,504.00 - $95,000.00***Candidates now meet the minimum qualifications of a position if they meet the minimum education and experience listed on the vacancy announcement.**The Knowledge, Skills, and Abilities (KSAs)/ Management Preferences are not required. Applicants who possess the following skills are preferred:** Demonstrated experience delivering full SDLC solutions—including requirements, design, programming, testing, implementation, documentation, and production support—for complex or interrelated applications and data services.* Advanced SQL and data modeling experience, including designing relational/dimensional schemas, writing complex SQL/T SQL queries, building transformations using tools such as dbt, and supporting databases such as SQL Server, Redshift, Oracle, Big Query, Snowflake, or Azure Synapse.* Proven ability to build and support automated data pipelines and integrations using API-driven workflows; ability to diagnose ingestion failures, reconcile datasets, and implement data quality checks.* Experience designing and supporting reporting solutions using Power BI, SSRS, Crystal Reports, including KPI definition, semantic modeling, and stakeholder-facing reporting.* Knowledge and proven experience in Python and Jupyter notebook## ***The Posting Will Close At 11:59 P.M. The Night Before The End Date***## ***This Position Is Funded In Part Through Federal Funds***## **This Role Is Eligible To Be Hybrid And Requires Onsite Reporting Located Within Raleigh, NC**## **About the Office of the Secretary**The Office of the Secretary serves as the executive leadership arm of the North Carolina Department of Health and Human Services (NCDHHS), guiding the Department’s mission to improve the health, safety, and well-being of all North Carolinians. Through strategic oversight and collaborative leadership, the Secretary’s Office supports the effective coordination of over a dozen core divisions, ensuring that agency-wide priorities are aligned, resources are used responsibly, and services are delivered with equity and impact.## **About the NC DHHS Information Technology Division**In collaboration with our partners, the North Carolina Department of Health and Human Services (DHHS) protects the health and safety of all North Carolinians and provides essential health and human services. The IT division (ITD) is one of the divisions that report to the Operational Excellence portfolio. The ITD division comprises four sections: Implementation and Operations, Strategy and Workforce, Enterprise Technology, and Vendor and Finance. ITD offers the following services but not limited to implementations, operations, project/portfolio management, infrastructure, consulting, business division liaison, digital transformation, IT strategy, enterprise technology, IT contract and vendor management, and data office services.## **Compensation and Benefits**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). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees. Visit website for .## **Supplemental Contact Information**The North Carolina Department of Health and Human Services (DHHS) is an Equal Opportunity Employer that embraces an Employment First philosophy, which consists of complying with all federal laws, state laws, and Executive Orders.
We are committed to reviewing requests for reasonable accommodation at any time during the hiring process or while on the job.
For more information about DHHS:
.DHHS uses the Merit-Based Recruitment and Selection Plan to fill positions subject to the State Human Resources Act with the most qualified individuals.
Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.In accordance with the Governor’s , our agency supports second-chance employment for individuals who were previously incarcerated or justice-involved.
We invite all potential applicants to apply for positions for which they may be qualified.
Application Process**Be sure to complete the application in its entirety.**
*Resumes will not be accepted in lieu of completing this application.** Information should be provided in the appropriate areas, to include the following: Education, including high school and all degrees obtained, Work Experience, and Certificates & Licenses. It is critical to our screening and salary determination process that applications contain comprehensive candidate information.* Applications must be submitted by 11:59 PM the day before the closing date.* Applicants may be subject to a criminal background check. All candidates selected for positions considered "Positions of Trust" will be subject to a criminal background check.* Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account.
Upon the closing date, applications are "Under Review" and will be screened by Human Resources for qualified applicants. The hiring process may take several weeks.* Degrees must be received from appropriately accredited institutions.
Transcripts and degree evaluations may be uploaded with your application. The State of North Carolina/Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent.* For a list of organizations that perform this specialized service, please visit the NACES membership website at .Degree/College Credit
#J-18808-Ljbffr
This role performs technical duties including leading requirement-gathering sessions; developing functional and technical requirements; designing new complex programs; analyzing and modifying existing systems; building and optimizing data pipelines; performing system administration and configuration; writing detailed specifications; developing and executing test plans; and monitoring application performance to prevent avoidable production interruptions.
The position works closely with stakeholders across Product, Operations, and Engineering to translate business needs into automated solutions, governing data models, and decision-grade reporting delivered through Power BI or similar BI tools. Work includes diagnosing data issues, reconciling multi-source systems, and validating data quality.**Knowledge Skills and Abilities/Management Preferences**## **Salary Grade Range: $81,504.00 - $122,256.00**## **Recruitment Range: $81,504.00 - $95,000.00***Candidates now meet the minimum qualifications of a position if they meet the minimum education and experience listed on the vacancy announcement.**The Knowledge, Skills, and Abilities (KSAs)/ Management Preferences are not required. Applicants who possess the following skills are preferred:** Demonstrated experience delivering full SDLC solutions—including requirements, design, programming, testing, implementation, documentation, and production support—for complex or interrelated applications and data services.* Advanced SQL and data modeling experience, including designing relational/dimensional schemas, writing complex SQL/T SQL queries, building transformations using tools such as dbt, and supporting databases such as SQL Server, Redshift, Oracle, Big Query, Snowflake, or Azure Synapse.* Proven ability to build and support automated data pipelines and integrations using API-driven workflows; ability to diagnose ingestion failures, reconcile datasets, and implement data quality checks.* Experience designing and supporting reporting solutions using Power BI, SSRS, Crystal Reports, including KPI definition, semantic modeling, and stakeholder-facing reporting.* Knowledge and proven experience in Python and Jupyter notebook## ***The Posting Will Close At 11:59 P.M. The Night Before The End Date***## ***This Position Is Funded In Part Through Federal Funds***## **This Role Is Eligible To Be Hybrid And Requires Onsite Reporting Located Within Raleigh, NC**## **About the Office of the Secretary**The Office of the Secretary serves as the executive leadership arm of the North Carolina Department of Health and Human Services (NCDHHS), guiding the Department’s mission to improve the health, safety, and well-being of all North Carolinians. Through strategic oversight and collaborative leadership, the Secretary’s Office supports the effective coordination of over a dozen core divisions, ensuring that agency-wide priorities are aligned, resources are used responsibly, and services are delivered with equity and impact.## **About the NC DHHS Information Technology Division**In collaboration with our partners, the North Carolina Department of Health and Human Services (DHHS) protects the health and safety of all North Carolinians and provides essential health and human services. The IT division (ITD) is one of the divisions that report to the Operational Excellence portfolio. The ITD division comprises four sections: Implementation and Operations, Strategy and Workforce, Enterprise Technology, and Vendor and Finance. ITD offers the following services but not limited to implementations, operations, project/portfolio management, infrastructure, consulting, business division liaison, digital transformation, IT strategy, enterprise technology, IT contract and vendor management, and data office services.## **Compensation and Benefits**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). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees. Visit website for .## **Supplemental Contact Information**The North Carolina Department of Health and Human Services (DHHS) is an Equal Opportunity Employer that embraces an Employment First philosophy, which consists of complying with all federal laws, state laws, and Executive Orders.
We are committed to reviewing requests for reasonable accommodation at any time during the hiring process or while on the job.
For more information about DHHS:
.DHHS uses the Merit-Based Recruitment and Selection Plan to fill positions subject to the State Human Resources Act with the most qualified individuals.
Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.In accordance with the Governor’s , our agency supports second-chance employment for individuals who were previously incarcerated or justice-involved.
We invite all potential applicants to apply for positions for which they may be qualified.
Application Process**Be sure to complete the application in its entirety.**
*Resumes will not be accepted in lieu of completing this application.** Information should be provided in the appropriate areas, to include the following: Education, including high school and all degrees obtained, Work Experience, and Certificates & Licenses. It is critical to our screening and salary determination process that applications contain comprehensive candidate information.* Applications must be submitted by 11:59 PM the day before the closing date.* Applicants may be subject to a criminal background check. All candidates selected for positions considered "Positions of Trust" will be subject to a criminal background check.* Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account.
Upon the closing date, applications are "Under Review" and will be screened by Human Resources for qualified applicants. The hiring process may take several weeks.* Degrees must be received from appropriately accredited institutions.
Transcripts and degree evaluations may be uploaded with your application. The State of North Carolina/Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent.* For a list of organizations that perform this specialized service, please visit the NACES membership website at .Degree/College Credit
#J-18808-Ljbffr