System Software Programmer

Job: System Software Programmer

Location: Columbia, SC ( Hybrid)]

The candidate will take initiative in performance, working independently and with groups to
effectively accomplish project objectives and engage in the following:
Identifying, extracting and transforming required data based on business requirements
and following data governance standards
Performing detailed data analysis and data profiling supporting the development and
implementation of data cleanse/create processes and other strategies that optimize data
quality
Understanding performance, quality, and schedule considerations
Interpreting complex data and communicate it in an effective manner, leveraging
advanced reporting techniques
Recognizing data patterns, quantify potential issues, and identify solutions
Standardizing, harmonizing, cleaning, preparing, and using data for datasets
development, reporting, and analysis
Providing support to the project team in terms of technical specification and build of
interface objects
Lead efforts to design, test and validate system interfaces
Work with state (agency IT staff) and Federal partners to design, test and implement
interface files and procedures for data exchange
Inspect and correct, as necessary, interface partner files in production
Serve as primary contact for any interface production file issues during nightly batch
process, monitors batch process for errors
Act as liaison between Child Support team and interface partners
Perform code, technical and logical reviews
Monitor database growth trends and recommend normalization strategies and
maintenance improvements to ensure long-term performance and scalability
Design, develop and manage data analysis reports using Microsoft PowerBI platform
Serve as primary DBA for Child Support related applications
Participate in the monitoring, oversight and reporting on the execution of the System
Development Contractor s performance as it relates to development, daily operations
activities including batch and online performance.
Developing and maintaining enterprise data authoritative ownership and stewardship
metadata
Communicating and supporting the implementation of corporate policies, standards, and
procedures that provide effective architecture, governance, and management of the
organization s information/data assets
Developing and maintaining effective and efficient information architecture and data
ownership awareness and training programs
Monitoring regulatory and compliance guidelines (such as data retention and audit
requirements) to determine impact on enterprise information architecture

REQUIRED SKILLS:
5+ years of experience as a SQL DBA
5+ years of large system architecture
Large scale production system implementation experience
Experience overseeing work of Software Development Vendors
MS SQL Server
TFS (Team Foundation Server)
Microsoft Visual Studio 2022
C#, ASP.net, and/or .NET
Powershell