ETL Database Design Data Warehousing Specialist (Jobs in Richmond, VA)   Requirement id 151171 Job title Specialist Job location in Richmond, VA Skills required SQL Queries, Scripting, ETL, Database Design Data Warehousing Open Date 08-Jan-2025 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Specialist: SQL Queries, Scripting, ETL, Database Design Data Warehousing No of Submissions : 2 Start date : 01/13/2025 End Date : 06/30/2025 Submission deadline : 1/13/2025 Client Info : DBHDS Note: * Agency Interview Type : Both Web Cam and In Person Interview * Hybrid * Pls note: Initial web-based interviews will be conducted; however, the team may request a second round IN PERSON with the finalists. * No Parking provided for contractors Description : ABOUT THE ROLE Main Responsibilities of a Data Migration Specialist The following list describes the typical responsibilities and deliverables of a Data Migration Specialist: Transform and load data into the respective data warehouse for a modernization initiative. Transform data to meet target system requirements Translate functional requirements into technical specifications for ETL development. Troubleshoot and resolve data migration issues Validate and analyze data sets to ensure data consistency and internal requirements are met. Analyze DBDHS Legacy data, data quality rules, business rules, data dictionaries, Analyze, prepare and execute data cleansing services. Analyze, specify and document data migration requirements with clients and internal teams. Articulate how Legacy data will be cleansed and adapted to fit into the new Future solution. Assist others with the selection of approaches, methods and / or services as required. Attend Project stand-ups and Stakeholder meetings Champion standards and implementation process that you define with the team. Collaborate with data architects to design data migration solutions Collaborate with the IMS Business customers and the DBHDS EDW Team, ensuring quicker and more accurate data management. Complete assigned tasks in an organized manner to ensure project deadlines. Develop and execute data migration process and procedures (from analysis to post implementation) including scripts and programs Develop and execute test plans to ensure client requirements are fulfilled. Contribute to the release and cutover strategy. Coordinate with stakeholders to gather requirements and system assessments as it related to data. Create and maintain utilities, SQL scripts as needed to accelerate the process. Ensure adherence to compliance needs for the agency. Implement new Mapping and ETL scripts. Lead data cleaning and dedupe program to drive accurate and complete data. Maintain appropriate levels of data security and privacy relating to customer data. Ensure documentation are created an maintained to enable migration process and post implementation support. Create and Monitor data migration progress and build dashboards to support audit , reconciliation and verification Perform regular backups to ensure data preservation. Propose a data migration and reconciliation strategy. Represent DBHDS IT and the Data cleansing/migration initiative at meetups with DBHDS internal and external partners Retrieve data from the database or electronic files as requested. Validate post-migration results and communicate outcome with Key DBHDS Central Office Leadership and Business Stakeholders, Key External DBHDS Reporting Stakeholders, CO Security, VITA, and DBHDS IT. Verify data by comparing it to source documents. Write validation scripts to run over the Staging tables to report any invalid data.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 151171 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14), SQL Queries job openings in Richmond, VA Jobs List DOC - Data Warehouse/BI Developer 3 (765137) Create date: 04-Jun-2025 Start date : 06/16/2025 End Date : 12/15/2025 Submission deadline : 06/10/2025 Client Info : DOC Note: * Agency Interview Type : In Person Only * Hybrid Description : Job Title: Data Warehouse/Business Intelligence Developer 3 Working Title: Data Int.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) DBHDS - Data Analyst 3 - (729231) Create date: 16-Feb-2024 Job Title: DBHDS - Data Analyst 3 - IN PERSON INTERVIEWS ONLY! (729231) Hybrid start date :03/04/2024 End date :06/28/2024 submission deadline :2/21/2024 client info :DBHDS Description : IN PERSON INTERVIEWS ONLY! No excepti.... (This job is for - Tableau Jobs in VA Richmond Analyst - (in Richmond, VA)) TAX - Jr Software Tester/QA Analyst 2 (727768) Create date: 16-Jan-2024 Hybrid start date :01/29/2024 End date :01/31/2025 submission deadline :1/18/2024 client info : TAX Description : Virginia Tax seeks a qualified person who works well with team with 1- 2 years of experience in the following: .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) ABC - Software Tester/QA Analyst 4 (678551) Create date: 22-Mar-2022 Start Date :03/28/2022 End Date :06/30/2022 Submission Deadline :03/25/2022 Client Info :ABC nOTE : * Agency Interview Type: Web Cam Interview Only Description : PLS NOTE: ABC is in the office (starting in March) 2 days a week - NO EXCEPTIONS. Ple.... (This job is for - UI Jobs in VA Richmond Analyst - (in Richmond, VA)) DOC Data Report Developer (660684) Create date: 27-Aug-2021 Start Date :09/20/2021 End Date :08/31/2022 Submission Deadline :09/2/2021 Client Info : DOC Note : * Agency Interview Type: Web Cam Interview Only Description : *local candidates strongly preferred *candidate selected must come onsite to pick up l.... (This job is for - SSRS Jobs in VA Richmond Developer - (in Richmond, VA))    SQL Queries job openings in other states Jobs List Business Analyst/Consultant IV - 140093 Create date: 14-Feb-2025 No of Submissions : 1 Start date : 04/07/2025 End Date : 06/30/2025 Submission deadline : 2/21/2025 4:00:00 PM Client Info : ETF Note: * Interview Process: 2 rounds via MS Teams. PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid in or.... (This job is for - Analysis Jobs in WI Madison Consultant - (in Madison, WI)) Programmer Analyst 3 - 139908 Create date: 10-Feb-2025 No of Submissions: 1 Start Date : 3/10/2025 End Date : 1 Years from projected start date Submission Deadline : 2/14/2025 10:00:00 AM EST Client Info : DOC Note: * Interview Process: In-person. Candidates must be available for an in-person interview. * Remote or On-site: Loca.... (This job is for - job Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDIT - Applications System Analyst (751874) Create date: 25-Nov-2024 No of Submissions : 2 Start date : 12/02/2024 End Date : 06/30/2025 Submission deadline : 12/03/2024 Client Info : NCDIT Note: * Agency Interview Type : Webcam Interview Only * Remote Description : · The primary purpose of this position is to.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer Analyst 6 -134720 Create date: 06-Sep-2024 Bid Limit Per Vendor : 1 Start date : 10/07/2024 End Date : 09/30/2025 Submission deadline : 9/12/2024 at 10am EST. Client Info : DIFS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphone.... (This job is for - Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDIT - Applications System Analyst (735593) Create date: 18-Jun-2024 * Remote No of Submissions : 2 Start date :06/01/2024 End Date :10/29/2024 Submission deadline :06/20/2024 Client Info :NCDIT Note: * Webcam Interview Only Description : · The primary purpose of this position is to work in partnership with exte.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC))    SQL Queries job openings in VA Jobs List ABC - Business Systems Analyst (702652) Create date: 20-Jan-2023 Hybrid Start date :01/30/2023 End Date :06/30/2023 Submission deadline :1/24/2023 Client Info :ABC Description : --------------------------------------------- 3 days/week ON SITE required from Day 1. No Exceptions! Pls do not submit if your candidate has interviewed for similar role a.... (This job is for - job Jobs in VA Mechanicsville Analyst - (in Mechanicsville, VA)) GOV - Data Analyst (648163) Create date: 24-Mar-2021 Start Date :04/05/2021 End Date :09/30/2021 Submission Deadline :03/30/2021 Client Info : SOA Note : * Agency Interview Type: Web Cam Interview Only Description : It is seeking a Senior Data Analyst to support a state wide Covid project. The contractor s.... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA)) Reports Workstream Lead - 64935 Create date: 13-Jul-2020 Note : Please only submit local candidates Candidate must be local : Yes Job Description : Title: Reports Work-stream Lead Location: Chesterfield, VA Duration: 12+ months PROJECT/SYSTEM OVERVIEW Reporting Lead: Leadership and Business Analytics Lead a project Reporting w.... (This job is for - SSRS SMEs Jobs in VA Chesterfield TeamLead - (in Chesterfield, VA)) Cloud Engineer - 64827 Create date: 09-Jul-2020 Note :This is a heads up and will be exclusive to us once released Upon offer, it is required to show consultants W2 take home pay in the Exh A. Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Title: Data Engineer Lo.... (This job is for - AWS Python Jobs in VA McLean Engineer - (in Mclean, VA)) ETL/Application QA - 51013 Create date: 09-Aug-2019 Candidate must be our W2 Employee Notes : This is a manual testing position, please do not send automation testers. Must be an expert in ETL manual testing. Description: Responsible for creating an end-to-end test plan; executing the plan and managing all activities in the plan to ensure that all t.... (This job is for - ETL Jobs in VA GlenAllen Analyst - (in Glen Allen, VA)) (Specialist: SQL Queries, Scripting, ETL, Database Design Data Warehousing in Richmond, VA)

Featured Jobs SharePoint Analyst (Jobs in Pontiac, Michigan) IIS Troubleshooting Architecting JAVA Architect (Jobs in Madison, Wisconsin DAX ETL Administrator (Jobs in Lansing, Michigan) IIS Architecting Business Architect (Jobs in Madison, Wisconsin) HCM SaaS IT Analyst (Jobs in Raleigh, North Carolina) ITSM Architect (Jobs in Madison, Wisconsin) Analytical Skills System Architect (Jobs in Madison, Wisconsin) OOAD C# Developer (Jobs in Richmond, Virginia) DHCP Firewall Written Engineer (Jobs in Richmond, Virginia) Business Consultant (Jobs in Richmond, Virginia)