Data Architect

Job Description

SCOPE OF THE PROJECT:
THE PROGRAM MANAGEMENT OFFICE IS TASKED WITH OVERSEEING THE DELIVERY OF IT SHARED SERVICES FOR SOUTH CAROLINA STATE GOVERNMENT AGENCIES. TO SUPPORT THE DIRECTION FOR IT SHARED SERVICES. THIS PROJECT SCOPE INCLUDES: 

• MONITORING AND MEASURING THE FINANCIAL STATUS OF PROJECTS AND PROGRAMS THE PMO OVERSEES AND MANAGES
• DEVELOPING OR COORDINATING THE DEVELOPMENT OF REPORTS ON PROJECT/PROGRAM STATUS FOR STAKEHOLDERS AND OTHER CONSTITUENCIES IMPACTED BY THE SHARED SERVICES PROGRAM
• TRACKING COSTS ASSOCIATED WITH IT SHARED SERVICES, WORKING WITH DTO LEADERSHIP TO ESTABLISH THE BASIS FOR SHARED SERVICES COSTS AND CHARGES TO STATE AGENCIES
• THIS ROLE WILL ALSO SUPPORT COST AND REVENUE TRACKING, ANALYSIS OF INVOICES GENERATED FOR AGENCIES
• DESIGNS COMPLEX RESEARCH AND STATISTICAL STUDIES FROM THE HYPOTHESIS DEVELOPMENT STAGE THROUGH THE FINAL ANALYSIS AND PRESENTATION OF FINDINGS.
• INTERPRETS EXISTING TRENDS IN PROGRAM AREA; FORECAST FUTURE TRENDS FOR POLICY IMPLEMENTATION. 
• DEVELOPS STATISTICAL MODELS; DEVELOPS AND REFINES TECHNIQUES FOR COMPUTER ANALYSIS AND PRESENTATION OF DATA. 
• PREPARES CHARTS, TABLES OR OTHER GRAPHIC PRESENTATIONS AS WELL AS NARRATIVE REPORTS. 

DAILY DUTIES / RESPONSIBILITIES:
THIS IMPLEMENTATION ASSISTANCE WOULD INCLUDE, BUT IS NOT LIMITED TO:
• INTERPRET DATA, ANALYZE RESULTS USING STATISTICAL TECHNIQUES AND PROVIDE ONGOING REPORTS
• DEVELOP AND IMPLEMENT DATABASES, DATA COLLECTION SYSTEMS, DATA ANALYTICS AND OTHER STRATEGIES THAT OPTIMIZE STATISTICAL EFFICIENCY AND QUALITY
• ACQUIRE DATA FROM PRIMARY OR SECONDARY DATA SOURCES AND MAINTAIN DATABASES/DATA SYSTEMS
• IDENTIFY, ANALYZE, AND INTERPRET TRENDS OR PATTERNS IN COMPLEX DATA SETS
• FILTER AND “CLEAN” DATA BY REVIEWING COMPUTER REPORTS, PRINTOUTS, AND PERFORMANCE INDICATORS TO LOCATE AND CORRECT CODE PROBLEMS
• WORK WITH MANAGEMENT TO PRIORITIZE BUSINESS AND INFORMATION NEEDS
• LOCATE AND DEFINE NEW PROCESS IMPROVEMENT OPPORTUNITIES

REQUIRED EDUCATION/CERTIFICATIONS:
• BS IN MATHEMATICS, ECONOMICS, COMPUTER SCIENCE, INFORMATION MANAGEMENT OR STATISTICS OR RELATED FIELD.
• 10 YEARS’ OF RELEVANT WORK EXPERIENCE MAY BE SUBSTITUTED IN LIEU OF EDUCATION.
• MINIMUM 7 YEARS OF EXPERIENCE HANDS ON EXPERIENCE IN DEVELOPING DASHBOARDS AND REPORTS

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• PROVEN WORKING EXPERIENCE AS A DATA ANALYST OR BUSINESS DATA ANALYST
• TECHNICAL EXPERTISE REGARDING DATA MODELS, DATABASE DESIGN DEVELOPMENT, DATA MINING AND SEGMENTATION TECHNIQUES
• STRONG KNOWLEDGE OF AND EXPERIENCE WITH REPORTING PACKAGES (BUSINESS OBJECTS ETC), DATABASES (SQL ETC), PROGRAMMING (XML, JAVASCRIPT, OR ETL FRAMEWORKS)
• KNOWLEDGE OF STATISTICS AND EXPERIENCE USING STATISTICAL PACKAGES FOR ANALYZING DATASETS (EXCEL, SPSS, SAS ETC)
• STRONG ANALYTICAL SKILLS WITH THE ABILITY TO COLLECT, ORGANIZE, ANALYZE, AND DISSEMINATE SIGNIFICANT AMOUNTS OF INFORMATION WITH ATTENTION TO DETAIL AND ACCURACY
• ADEPT AT QUERIES, REPORT WRITING AND PRESENTING FINDINGS
• BUSINESS INTELLIGENCE DEVELOPER WITH HANDS-ON EXPERIENCE IN DATA WAREHOUSES AND BI TO DESIGN AND DEVELOP BUSINESS REPORTS, DASHBOARDS WITH SAP BUSINESS OBJECTS. 
• EXPERT IN DESIGNING BUSINESS OBJECTS UNIVERSE(S). SHOULD BE ABLE TO RECOMMEND DATA WAREHOUSE DESIGNING 
• EXPERIENCED IN REQUIREMENT GATHERINGS FROM BUSINESS AND CREATE THE SPECS FOR DEVELOPMENT OF UNIVERSE DESIGN/WEBI. 

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• WORK WITH CROSS FUNCTIONAL BUSINESS AND IT TEAMS OF BUSINESS ANALYSTS, DATA MODELERS, SOLUTION ARCHITECTS, DBA'S AND PROJECT MANAGERS DURING ALL SDLC PHASES 
• TRANSLATES FUNCTIONAL REQUIREMENTS INTO TECHNICAL SPECIFICATIONS. PERFORMS CODE WALKTHROUGHS AND FORMAL REVIEWS 
• PARTICIPATE IN PRODUCTION, OFF-HOURS AND WEEKEND SUPPORT 
• CREATE AND FOLLOW PROCESSES, PROCEDURES AND BEST PRACTICES 
• EXPERIENCE IN DEVELOPING RE-USABLE FRAME-WORK AND COMPONENTS
• EXPERIENCE IN TUNING PERFORMANCE OF DASHBOARD AND SQL
• EXPERIENCED IN UNDERSTANDING THE FLOW OF DATA BETWEEN SOURCE AND TARGET DATABASE, DATA ANALYSIS AND ANALYTICAL SKILL 
• STRONG UNDERSTANDING OF DIMENSIONAL & RELATIONAL DATA MODELS.

REQUIRED EDUCATION/CERTIFICATIONS:
• BS IN MATHEMATICS, ECONOMICS, COMPUTER SCIENCE, INFORMATION MANAGEMENT OR STATISTICS OR RELATED FIELD.
• 10 YEARS’ OF RELEVANT WORK EXPERIENCE MAY BE SUBSTITUTED IN LIEU OF EDUCATION.
• MINIMUM 7 YEARS OF EXPERIENCE HANDS ON EXPERIENCE IN DEVELOPING DASHBOARDS AND REPORTS

Additional Information

All your information will be kept confidential according to EEO guidelines.