Systems Specialist - Data Analytics Division

Position: Applications Systems Specialist I - Data Analytics Division
Agency Office of the State Auditor Division Job  Classification Title Applications Systems Specialist I (NS)
Position NumberGradeDT
10

About UsThe 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.

The Office of the State Auditor (OSA) is seeking an Applications Systems Specialist I to serve on our Data Engineering Team within our Data Analytics Division. In this role, you would have the opportunity to work with Databricks solution architecture and engineering, lead technical projects, review code, and help develop data governance for the agency.

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 AbilitiesK 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.

OSA is the state’s Fiscal Watchdog . We hold state government and entities that receive public money accountable, working on behalf of North Carolinians to eliminate waste, fraud, and abuse.

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

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 optionsNC 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 (Use the "Apply for this Job" box below). 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  order to receive…