Previous Job
Previous
CL - Business Analyst - Project Lead
Ref No.: 17-01423
Location: Columbia, South Carolina
Client: Department of Social Services
Location: Columbia,SC
Duration: 12+ Months



Job Description:
General: Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs. Possesses expertise in the business unit(s) they support, as well as, an understanding of the IT organization's systems and capabilities. Analyzes business partner's operations to understand their strengths and weaknesses to determine opportunities to automate processes and functions. Assists in the business process redesign and documentation as needed for new technology. Translates high level business requirements into functional specifications for the IT organization and manages changes to such specifications. Educates the IT organization on the direction of the business. Negotiates agreements and commitments by facilitating communication between business unit(s) and IT from initial requirements to final implementation. Possesses an understanding of technological trends and uses this knowledge to bring solutions to business units supported to enhance the enterprise's competitive edge. May make recommendations for buy versus build decision. May require a bachelor's degree in a related area and 5-7 years of experience in the field or in a related area.

SCOPE OF THE PROJECT: THE CFS PROJECT IS PART OF THE DEPARTMENT OF SOCIAL SERVICES (DSS) 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 new position on the CFS Project for a Data Conversion Business/Data Analyst experienced in Child Support Enforcement Systems and Clerk of Court child support data.. 
The successful candidate will demonstrate a proven ability to collaborate and coordinate activities with diverse groups, including stakeholders, team leads, vendors, project managers, and technical staff.
As the Data Conversion Business/Data Analyst, this individual will:
• Develop a thorough knowledge of the existing South Carolina child support data, mapping rules, and the data conversion requirements in order to understand how the existing data must be mapped into the new child support system
• Oversee the data conversion work performed by the System Development Contractor (SDC) during the phases of the system development life cycle (SDLC)
• Review SDC deliverables applicable to the areas of responsibilities in accordance with project plans and processes 
• Coordinate date cleanup efforts with stakeholders
• Analyze SDC mapping rules and validate rules accurately map legacy data to new data structure. This includes writing queries to analyze legacy data and determine correctness of rules as well as the correctness of the converted data
• Interpret Application requirements and their impacts to the Conversion process and mapping rules
• Perform Automated as well as online testing activities to insure conversion is correct

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
(SEE BEELINE DESCRIPTION)
• EXPERIENCED DATA ANALYST WITH EXTENSIVE EXPERIENCE PERFORMING, DATA MAPPING, DATA CLEANSING.
• BUSINESS ANALYSIS EXPERIENCE TO INCLUDE DATA FLOW DIAGRAMS, REQUIREMENTS SPECIFICATIONS, USE CASE SCENARIOS, AND ACCEPTANCE TESTING.
• RELATIONAL DATABASE EXPERIENCE INCLUDING WRITING QUERIES USING SQL SERVER
• STRONG ORGANIZATIONAL SKILLS
• EXPERIENCE WORKING WITH MICROSOFT OFFICE 2010 TO INCLUDE EXCEL, WORD, VISIO AND POWERPOINT
• VERY GOOD ENGLISH COMMUNICATION SKILLS, WRITTEN AND ORAL
• Child Support Enforcement Experience

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
(SEE BEELINE DESCRIPTION)
• 3-5 YEARS OF EXPERIENCE IN CHILD SUPPORT ENFORCEMENT SYSTEM DATA CONVERSION 
• 3-5 YEARS OF EXPERIENCE IN CLERK OF COURT CHILD SUPPORT DATA CONVERSION
• EXPERIENCE USING MS ACCESS

REQUIRED EDUCATION:
• BS DEGREE IN RELATED FIELD


Skills:
Category Name Required Importance Level Last Used Experience  
Database Platforms Relational Database Experience Yes 1 Advanced Within 6 Months 4 - 6 Years    
Miscellaneous Demonstrated knowledge/skills of the IT industry which includes: multi-tiered architectures, enterprise applications, evaluation of emerging technologies, networks, data management systems and hardware systems. Yes 3 Advanced Within 6 Months 4 - 6 Years    
Miscellaneous Document business and system data using data classification methods. Yes 3 Advanced Within 6 Months 4 - 6 Years    
Packaged Applications MS Office (Word, Excel, PowerPoint, Visio) Yes 1 Advanced Within 6 Months 4 - 6 Years    
Specialties Business Analysis experience to include data flow diagrams, requirements specifications, use case scenarios, and acceptance testing. Yes 1 Advanced Within 6 Months 4 - 6 Years    
Specialties Child Support Enforcement System (CSES) Yes 1 Advanced Within 6 Months 4 - 6 Years    
Specialties Solid background in data integration, staging, quality and distribution Yes 1 Advanced Within 6 Months 4 - 6 Years    
Additional Skills:  
Required 4-6 Years - Experienced data analyst with extensive experience performing data mapping and data cleansing