Applications Systems Specialist I - Data Analytics Division

nc; North Carolina; On-site; USD 88,000 - 131,000; Full time

Benefits offered by this job

Work-Life Balance

Generous paid time off

Health insurance

Job summary

Agency Office of the State Auditor Division in North Carolina is seeking an experienced Applications Systems Specialist I (NS) to translate business and audit requirements into scalable technical designs and data workflows. The role focuses on advanced Python, PySpark, and Spark SQL solutions for data ingestion, transformation, enrichment, and delivery.

The position includes mentoring engineers in Databricks, Python, PySpark, SQL, and governance, and implementing Databricks governance using

Qualifications

• Translate business and audit requirements into scalable technical designs, data models, processing workflows, and platform configurations.
• Develop advanced Python, PySpark, and Spark SQL solutions for data ingestion, transformation, enrichment, reconciliation, and delivery.
• Define and execute testing strategies for pipelines, transformations, workflows, integrations, and governed data products.

Responsibilities

• Mentor engineers working with Databricks, Python, PySpark, SQL, data pipelines, testing, deployment, and governance.
• Design and implement Databricks governance structures using Unity Catalog and related platform capabilities.
• Define or support data ownership, stewardship, classification, access, certification, retention, and lifecycle requirements.

Skills

Python

PySpark

Spark SQL

Databricks

Unity Catalog

Tools

Databricks

Job description

Agency Office of the State Auditor Division

Job Classification Title

Applications Systems Specialist I (NS)

Position Number

Grade

DT10

About Us

The North Carolina Office of the State Auditor (OSA) is your fiscal watchdog. We audit more than $100 billion in state assets and liabilities each year, bringing transparency to local, state, and federal government. Our reports and findings include recommendations that result in good government reforms. OSA thoroughly investigates alleged cases of fraud, waste, and abuse of taxpayer dollars, working with law enforcement on prosecution when warranted.

Description of Work

This position is designated as Exempt Policy-Making under G.S. 126-5(c)(3) and is considered an at-will appointment.

We are recruiting for 2 positions within this posting.

Learn more about our office here! Why Work for the NC Office of The State Auditor?

As part of our team, you will get to

• Translate business and audit requirements into scalable technical designs, data models, processing workflows, and platform configurations
• Develop advanced Python, PySpark, and Spark SQL solutions for data ingestion, transformation, enrichment, reconciliation, and delivery
• Define and execute testing strategies for pipelines, transformations, workflows, integrations, and governed data products
• Mentor engineers working with Databricks, Python, PySpark, SQL, data pipelines, testing, deployment, and governance
• Design and implement Databricks governance structures using Unity Catalog and related platform capabilities.
• Define or support data ownership, stewardship, classification, access, certification, retention, and lifecycle requirements

Knowledge Skills and Abilities/Management Preferences

Salary Range: $87,617 - $131,426

Knowledge, Skills, and Abilities

• K nowledge of deployment approaches such as Databricks Asset Bundles, infrastructure as code and configuration as code
• Thorough knowledge of enterprise data governance principles, including data ownership, stewardship, classification, metadata, lineage, retention, access control, and lifecycle management
• Experience in designing, developing and supporting production solutions in Databricks

This position is designated as Exempt Policy-Making under G.S. 126-5(c)(3) and is considered an at-will appointment.

We are recruiting for 2 positions within this posting.

This is a full-time position (40 hours per week) with State Benefits including:

• Work-Life Balance: 40-hour work week with flexible schedule options and the ability to earn compensatory time off
• Generous paid time off each year
• Competitive pay and affordable health insurance options
• NC OSHR: Total Compensation Calculator
• Enrollment in the state's pension plan and options for additional supplemental savings
• An opportunity to work with a team of professionals to make a difference in state government
• If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program, visit www.studentaid.gov to learn more

Supplemental and Contact Information

The Office of the State Auditor uses the Merit-Based Recruitment & Selection Plan to fill positions subject to the State Human Resources Act (SHRA) with highly qualified individuals.

In order to receive credit for work history and credentials you must complete the online application completely. Any information omitted from the application cannot be considered for qualifying credit.

You can attach resumes, cover letters, reference information as supplemental information, but this will NOT be used in lieu of a completed state application.

If you have earned a foreign degree, an official evaluation for United States equivalency is required and must be submitted to Human Resources for verification purposes.

The National Association of Credential Evaluation Services (NACES) has several options on their website that can provide credential verification: https://www.naces.org/members

Reference checks will be performed on all top finalists.

The Office of the State Auditor is an Equal Opportunity Employer:

Applicants seeking Veteran's Preference must attach a DD Form 214, Certificate of Release or Discharge from Active Duty, along with the state application.

Applicants seeking National Guard Preference must attach a NGB 23A (RPAS) if they are a current member of the NC National Guard in good standing.

If applicants are a former member of the NC National Guard who served for