What are the responsibilities and job description for the 10925 - Hybrid Job -IT - DSS - System Software Programmer - Consultant position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Cynosure Technologies LLC, is seeking the following. Apply via Dice today!
Hi,
Hope you are doing well.
Role: IT - DSS - System Software Programmer - Consultant
Job id : 10925
Duration: 12 Months
Client: State of South Carolina
Location : Columbia , SC (Hybrid Job)
Department : DSS
Job Description:
Full job description attached and required and preferred skills are listed below.
Job Duties / Responsibilities:
The Department seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the Child Support Applications group under the South Carolina Department of Social Services. This is a posting of a position to perform in the role of SQL Database Administrator and Senior Developer that is responsible for developing applications and database integrations using the Microsoft SQL Server platform. This will include reports, vendor exports, data warehousing tasks and other data related tasks.
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
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:
Bachelor s degree or equivalent experience
Required Certifications:
N/A
Environments And Tools
MS SQL 2022 enterprise server and MS SQL 2022 enterprise server Reporting Services
TFS (Team Foundation Server)
Microsoft Visual Studio 2022
C#, ASP.net, .NET
POWERSHELL
MICROSOFT POWERBI
Additional Skills:
Proven abilities to plan, organize, instruct, and review the work of the development team.
Knowledge of generally accepted system architecture, project management and supervision principles and practices.
Ability to communicate (orally and written) effectively with technical, non-technical staff, customers/stakeholders (State and Federal) and executives.
Ability to communicate effectively with DSS and other State information technology staff.
Hi,
Hope you are doing well.
Role: IT - DSS - System Software Programmer - Consultant
Job id : 10925
Duration: 12 Months
Client: State of South Carolina
Location : Columbia , SC (Hybrid Job)
Department : DSS
Job Description:
Full job description attached and required and preferred skills are listed below.
Job Duties / Responsibilities:
The Department seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the Child Support Applications group under the South Carolina Department of Social Services. This is a posting of a position to perform in the role of SQL Database Administrator and Senior Developer that is responsible for developing applications and database integrations using the Microsoft SQL Server platform. This will include reports, vendor exports, data warehousing tasks and other data related tasks.
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 longterm performance and scalability
- Design, develop and manage data analysis reports using Microsoft PowerBI platform
- Serve as primary DBA for Child Support related applications
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
- Experience with Child Support Enforcement system design and development
- Experience with PowerBI
Bachelor s degree or equivalent experience
Required Certifications:
N/A
Environments And Tools
MS SQL 2022 enterprise server and MS SQL 2022 enterprise server Reporting Services
TFS (Team Foundation Server)
Microsoft Visual Studio 2022
C#, ASP.net, .NET
POWERSHELL
MICROSOFT POWERBI
Additional Skills:
Proven abilities to plan, organize, instruct, and review the work of the development team.
Knowledge of generally accepted system architecture, project management and supervision principles and practices.
Ability to communicate (orally and written) effectively with technical, non-technical staff, customers/stakeholders (State and Federal) and executives.
Ability to communicate effectively with DSS and other State information technology staff.