Job Description

Ref No.:18-14041
Location: St Andrews, SC, South Carolina

Remote Work Availability:
0%
Interview Process

Panel phone Interview
Schedule Interview:
within 2 weeks of closing


Comments

SCOPE OF THE PROJECT: THE CFS PROJECT TEAM S RESPONSIBLE FOR DEVELOPING, THE CFS PROJECT IS PART OF THE CLIENT AND IS RESPONSIBLE FOR DEVELOPING, IMPLEMENTING, MAINTAINING, AND OBTAINING FEDERAL CERTIFICATION OF A FEDERALLY-MANDATED CHILD SUPPORT ENFORCEMENT SYSTEM (CSES) THAT WILL PROVIDE COMPREHENSIVE SUPPORT TO THE OPERATION OF SOUTH CAROLINA'S CHILD SUPPORT ENFORCEMENT (CSE) PROGRAM AS WELL AS FOR COMPLETING THE DEVELOPMENT AND IMPLEMENTATION OF THE FAMILY COURT CASE MANAGEMENT SYSTEM (FCCMS) FOR THE 46 CLERKS OF COURT.
DAILY DUTIES / RESPONSIBILITIES:

This is a posting for a new position to perform in the role of SQL Developer that is responsible for developing applications and 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
* Manually migrating required data from the legacy system data by analyzing and mapping existing data to a new solution
* Working closely with legacy data teams and the SI/vendor teams to ensure the right data is migrated
* 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 and Conversion 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 management of the organization's information/data assets
* Developing and maintaining effective and efficient data ownership awareness and training programs
* Monitoring regulatory and compliance guidelines (such as data retention and audit requirements) to determine impact

REQUIRED SKILLS:
(SEE BEELINE DESCRIPTION)
* 7 YEARS OF EXPERIENCE IN INFORMATION TECHNOLOGY INCLUDING COMPUTING, TELECOMMUNICATIONS, PRINTING, DATA STORAGE, DATA TRANSMISSION ETC.
* LARGE SCALE PRODUCTION SYSTEM IMPLEMENTATION EXPERIENCE.
* KNOWLEDGE OF GENERALLY ACCEPTED PROJECT MANAGEMENT AND SUPERVISION PRINCIPLES AND PRACTICES.
* PROVEN ABILITIES TO PLAN, ORGANIZE, INSTRUCT, AND REVIEW THE WORK OF THE DEVELOPMENT TEAM.
* ABILITY TO COMMUNICATE (ORALLY AND WRITTEN) EFFECTIVELY WITH TECHNICAL, NON-TECHNICAL STAFF, CUSTOMERS/STAKEHOLDERS (STATE AND FEDERAL) AND EXECUTIVES.
* ABILITY TO COMMUNICATE EFFECTIVELY WITH THE DSS AND OTHER STATE INFORMATION TECHNOLOGY STAFF.
ENVIRONMENTS AND TOOLS:
* MS SERVER 2008 ENTERPRISE SERVER, MS SQL 2008 R2 ENTERPRISE SERVER AND MS SQL 2008 ENTERPRISE SERVER REPORTING SERVICES
* TFS (TEAM FOUNDATION SERVER)
* MICROSOFT VISUAL STUDIO 2010
* C#, .ASP.NET, .NET
* SSIS
* MS ACCESS

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
(SEE BEELINE DESCRIPTION)
* PREFERENCE WILL BE GIVEN TO EXPERIENCE RELATED TO CHILD SUPPORT ENFORCEMENT SYSTEM DESIGN AND DEVELOPED AND/OR KNOWLEDGE OF THE CHILD SUPPORT ENFORCEMENT PROGRAM'S MISSION AND OBJECTIVES.

REQUIRED EDUCATION:
* BS DEGREE IN RELATED FIELD (experience in lieu of degree is ok)

CategoryNameRequiredImportanceLevelLast UsedCandidate
Last Used
Candidate ExpRequired
Exp
Database PlatformsMS SQL Server 2008Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsMS SQL Server 2008 enterprise serverYes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsMS SQL Server 2008 R2Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsSQL Server Integration Services (SSIS)Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsTeam Foundation Server (TFS) 2013Yes1LeadWithin 6 Months 4 - 6 Years
Development ToolsMS AccessYes1LeadWithin 6 Months 4 - 6 Years
MiscellaneousAbility to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written formYes1LeadWithin 6 Months 4 - 6 Years
MiscellaneousKNOWLEDGE OF INFORMATION TECHNOLOGY FIELD, BEST PRACTICES, ORGANIZATION AND OPERATIONSYes1LeadWithin 6 Months 6 + Years
Packaged ApplicationsMicrosoft Visual Studio 2010Yes1LeadWithin 6 Months 4 - 6 Years
Program ManagementLarge scale production system implementation experienceYes1LeadWithin 6 Months 4 - 6 Years
Program ManagementProject Management experienceYes1LeadWithin 6 Months 4 - 6 Years
Programming Languages.NetYes1LeadWithin 6 Months 4 - 6 Years
Programming LanguagesASP.NETYes1LeadWithin 6 Months 4 - 6 Years
Programming LanguagesC#Yes1LeadWithin 6 Months 4 - 6 Years
SpecialtiesChild Support Enforcement System (CSES)No4IntermediateWithin 2 Years 1 - 2 Years


Additional Preferred Skills:

CategoryNameRequiredImportanceLevelLast UsedCandidate
Last Used
Candidate ExpRequired
Exp
Database PlatformsMS SQL Server 2008Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsMS SQL Server 2008 enterprise serverYes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsMS SQL Server 2008 R2Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsSQL Server Integration Services (SSIS)Yes1LeadWithin 6 Months 4 - 6 Years
Database PlatformsTeam Foundation Server (TFS) 2013Yes1LeadWithin 6 Months 4 - 6 Years
Development ToolsMS AccessYes1LeadWithin 6 Months 4 - 6 Years
MiscellaneousAbility to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written formYes1LeadWithin 6 Months 4 - 6 Years
MiscellaneousKNOWLEDGE OF INFORMATION TECHNOLOGY FIELD, BEST PRACTICES, ORGANIZATION AND OPERATIONSYes1LeadWithin 6 Months 6 + Years
Packaged ApplicationsMicrosoft Visual Studio 2010Yes1LeadWithin 6 Months 4 - 6 Years
Program ManagementLarge scale production system implementation experienceYes1LeadWithin 6 Months 4 - 6 Years
Program ManagementProject Management experienceYes1LeadWithin 6 Months 4 - 6 Years
Programming Languages.NetYes1LeadWithin 6 Months 4 - 6 Years
Programming LanguagesASP.NETYes1LeadWithin 6 Months 4 - 6 Years
Programming LanguagesC#Yes1LeadWithin 6 Months 4 - 6 Years
SpecialtiesChild Support Enforcement System (CSES)No4IntermediateWithin 2 Years 1 - 2 Years

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online