Senior IT Technical Data Analyst (680797)
About the Opportunity
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- We are only considering local candidates who currently reside within 45 minutes of postal code 20003
- No Third Party Agencies
- $102 per hour 1099, C2C, $88 per hour W2 + benefits
- Location: 60% On-site, 40% Work From Home in downtown SE DC (Green Line: Navy Yard)
- Job Id: CAI-680797
- Must be able to provide proof of COVID-19 vaccination plus booster shot
- Contract Term: Till end of the 2022 fiscal year with yearly extension based upon performance
Short Description
The District of Columbia’s Child and Family Services Agency (CFSA) is seeking a Senior IT Technical Data Analyst to analyze processes and re-engineering with an understanding of technical problems and solutions as they relate to the current and future business environment. The ideal candidate will have 7+ years of SQL queries and data conversion from legacy Oracle to SQL Server as well as 5+ years of data security requirement and data production go-live planning and execution.
Required Skills/Years of Experience
- Bachelor’s degree in IT or related field or equivalent experience
- 11+ years of business process re-engineering experience
- 11+ years of scripting/data analysis languages (R, Python, Perl, Javascript, etc.)
- 11+ years of data extraction/transfer, data mapping, and data cleansing/data quality
Desired Skills/Years of Experience:
- 7+ years of SQL queries
- 7+ years of data conversion from legacy Oracle to SQL Server
- 5+ years of data security requirements
- 5+ years of data production go-live planning and execution
- 2+ years of Human Services, Child Services, or K-12 Education
Complete Description
The District of Columbia’s Child and Family Services Agency (CFSA) is seeking a Senior IT Technical Data Analyst to analyze processes and re-engineering with an understanding of technical problems and solutions as they relate to the current and future business environment. The ideal candidate will have 7+ years of SQL queries and data conversion from legacy Oracle to SQL Server as well as 5+ years of data security requirement and data production go-live planning and execution.
The Senior IT Technical Data Analyst will be tasked to:
- Analyze processes and re-engineering with an understanding of technical problems and solutions as they relate to the current and future business environment
- Support the development of an ideal target data model for new CCWIS and work with the vendor to implement actual data model
- Evaluate and document the current state of data quality
- Come up with and track data quality improvement actions
- Manage data quality activities and maintain the CFSA Data Quality Plan
- Maintain data inventories and when possible reduce data capture and maintenance systems
- Develop agendas and schedule meetings
- Develop action items for the Data Quality Committee and its subcommittees
- Conduct data quality analysis and develop recommendations for the committees
- Develop a documentation framework (using online capabilities such as SharePoint, Wiki, other tools) to continuously capture and update data quality standards, exception report processing, data, and domain definitions
- Develop and maintain the report catalogue
- Work with a system integrator vendor to support the data conversion effort
- Develop data conversion quality control and quality assurance processes
- Creates process change by integrating new processes with existing ones and communicating these changes to impacted business systems teams
- Recommend and facilitate quality improvement efforts
Hiring Expectations
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- No Third Parties
- Right to Represent authorization is required
- Expect technical interview screening
- Expect F2F interview
- Background check and/or credit check will be required