Provide a high degree of expert consultative services in preparing technical qualitative and quantitative data projects and ad-hoc reports by describing the methodology, findings, and conclusions, including the preparation of supporting tables, graphs, and charts in a structured, professional format using Word, Excel, and software access databases to make final recommendations which may be used for analysis and decision making by departmental staff and management within the branch, division, and executive staff of the Department of Child Support Services (DCSS).Write queries using Structured Query Language (SQL) for departmental data requests including scoping system issues, program initiative impacts, and create both ad hoc and automated reports which may be used to assist in managing program performance and for analysis and decision making by departmental staff and management.Analyze and summarize data using Statistical Analysis System (SAS) software to produce reports, make comparisons, and identify data anomalies for departmental data requests to DCSS staff and management with statistics to assist with analysis, assessments, and decisions about the ProgramWrite technical specifications to document the architecture, business specifications, functionality, methodologies, definitions, and requirements of software applications and programs used by thebranch which may be used for analysis and decision making by departmental staff and management.

Prepare and check reports and graphs/tables/charts based on our data collection for Management, Office of Child Support Enforcement and publication to the Local Child Support Agency Secure website using SharePoint, Word and Excel.Prepare documentation outlining methods used for data collection and analysis and make recommendation to staff and management to make decisions based on findings.Support the Child Support Services Division with writing and validating queries and automated reports in MS SQL Server and IBM Data Studio, as well as Ad Hoc workgroup participation.Validate query results using SQL, SAS Enterprise Guide, Child Support Backup Data, MS Excel and the Child Support Enforcement system. Scope system issues and potential impact of program changes.Analyze, compare and compile data sets and reports in SAS Enterprise Guide. Develop methods and procedures regarding the completion of staff work within the unit, including managing the data library. Produce technical documentation for reports that includes technical query specifications, business impacts and functionality of reports.Manage a log which tracks the life-cycle of both internally and externally created queries that come through the Data Analytics Unit.Communicate with department staff, management and Local Child Support Agency personnel regarding the status of queries and reports via e-mail, phone and in person.

SQL query writing, Quality checking reports for the federal Office of Child Support EnforcementDaily use of Microsoft SQL Server Studio for querying the Child Support Data databases, analyze and validate data, creating/modifying tables, importing/exporting dataRegular use of IBM Data StudioOccasional use of BIDS for SSIS package developmentRegular use of Microsoft Word, Excel, Power Point, Outlook, Share Point, VisioDaily use of Share Point to track the query cycle of the current workload, upload/download files (spreadsheets and documentation) and maintaining the data library for the unit

Daily use of Microsoft SQL Server Studio in conjunction with Microsoft Visio and CCSAS CSE for database documentation and data validation Extensive use of Microsoft Excel for quality checking documents and reports and compiling dataDaily use of Microsoft Office for sending/receiving emails, setting up appointments and calendar management