Overview
On Site
Hybrid
USD 55.00 per hour
Full Time
Skills
Computer Science
Data Extraction
Performance Tuning
Collaboration
Informatica
Talend
Unstructured Data
Analytical Skill
Attention To Detail
Microsoft SSIS
Database Design
Data Modeling
Transact-SQL
Stored Procedures
Extraction
Data Loading
Management
Microsoft SSRS
Microsoft SSAS
Debugging
Database
Facilitation
Training
Reporting
Data Conversion
HR Management
Migration
Kronos
Business Intelligence
SQL
Mapping
Legacy Systems
Data Structure
Workday
Data Quality
Data Warehouse
Data Integrity
Data Processing
Workflow
Scalability
Extract
Transform
Load
Data Integration
Documentation
Data Mapping
Test Cases
Scripting
Job Details
Date Posted: 07/14/2025
Hiring Organization: Rose International
Position Number: 485406
Industry: Government/Staffing
Job Title: Data Warehouse/ BI Developer
Job Location: Richmond, VA, USA, 23219
Work Model: Hybrid
Work Model Details: Requires on-site 2-3 days a week
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 12
Min Hourly Rate($): 55.00
Max Hourly Rate($): 60.00
Must Have Skills/Attributes: ETL, HCM, SSAS, SSIS, SSRS
Experience Desired: Strong understanding of Workday's data structures pertaining to HCM module (6 yrs); experience in migrations working with Kronos, Cornerstone, and Workday (6 yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Data Warehouse/BI Developer/ ETL Developer candidates located near the Richmond, VA area to be considered due to the position requiring an onsite presence***
Required Education:
Bachelor's degree in IT, Computer Science or closely related field
Required Skills:
Hands on knowledge on Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning (6 Years)
Hands on knowledge on Data Quality Assurance & Documentation and Collaboration (6 Years)
Proven experience in working with ETL tools such as Informatica, Talend, or SSIS (6 Years)
Strong knowledge of SQL for querying and manipulating data in databases (6 Years)
Experience in data integration from various data sources, including structured and unstructured data (6 Years)
Ability to troubleshoot and resolve performance issues in ETL pipelines (6 Years)
Strong analytical skills and attention to detail to ensure data quality (6 Years)
Ability to analyze data, identify issues, and validate data accuracy (6 Years)
Working knowledge with ETL process design, development and support (6 Years)
Working knowledge with ETL tools such as SSIS or equivalent (6 Years)
Working knowledge with Database Design and Data Modelling (6 Years)
T-SQL statements and stored procedures (6 Years)
Designing and implementing extraction, transformation, and loading data pipelines (6 Years)
Investigating data to anticipate any pipeline issues (6 Years)
Managing the maintenance of software (6 Years)
SSRS and SSAS (6 Years)
Working closely with data analysts on the ETL process (6 Years)
Troubleshooting and debugging database issues (6 Years)
Facilitating and training staff on ETL processes at each level (6 Years)
Working with stakeholders and managers to understand business goals (6 Years)
Implementing and updating new software (6 Years)
Designing and implementing SQL queries (6 Years)
Providing customer reporting (6 Years)
Total 6 (six) years' experience in data conversion/ETL projects with at least three (3) years in migrating data from legacy systems to Workday HCM (6 Years)
Desired Skills:
Strong understanding of Workday's data structures pertaining to HCM module
Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus
Client is seeking an experienced ETL Developer to design, develop, and maintain robust data pipelines that move data from various sources to our data warehouse. You will work with a team of data engineers, analysts, and stakeholders to ensure data quality, transform complex datasets, and support our business intelligence efforts. The ideal candidate will have experience with ETL tools, data integration, and SQL, and will be passionate about building efficient and scalable data pipelines
Job responsibilities:
Work with client business unit personnel and other stakeholders to extract data from legacy systems and transform it into a format compatible with Workday HCM
Define and document the mapping of data fields between legacy systems and Workday's data structures
Ensure the transformed data that is ready to be loaded into Workday is accurate, complete, and adheres to data quality standards through various validation techniques
Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse
Work closely with the data team to ensure data integrity, quality, and availability
Monitor ETL pipelines for performance and troubleshoot any issues or bottlenecks
Optimize data processing workflows to ensure scalability and efficiency
Document ETL processes and maintain best practices for data integration
Identify and resolve data-related issues that arise during the conversion process
Maintain detailed documentation of data mapping, transformation rules, and validation procedures
Develop and run test cases and scripts
Interview Process: In Person Only
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 485406
Industry: Government/Staffing
Job Title: Data Warehouse/ BI Developer
Job Location: Richmond, VA, USA, 23219
Work Model: Hybrid
Work Model Details: Requires on-site 2-3 days a week
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 12
Min Hourly Rate($): 55.00
Max Hourly Rate($): 60.00
Must Have Skills/Attributes: ETL, HCM, SSAS, SSIS, SSRS
Experience Desired: Strong understanding of Workday's data structures pertaining to HCM module (6 yrs); experience in migrations working with Kronos, Cornerstone, and Workday (6 yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Data Warehouse/BI Developer/ ETL Developer candidates located near the Richmond, VA area to be considered due to the position requiring an onsite presence***
Required Education:
Bachelor's degree in IT, Computer Science or closely related field
Required Skills:
Hands on knowledge on Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning (6 Years)
Hands on knowledge on Data Quality Assurance & Documentation and Collaboration (6 Years)
Proven experience in working with ETL tools such as Informatica, Talend, or SSIS (6 Years)
Strong knowledge of SQL for querying and manipulating data in databases (6 Years)
Experience in data integration from various data sources, including structured and unstructured data (6 Years)
Ability to troubleshoot and resolve performance issues in ETL pipelines (6 Years)
Strong analytical skills and attention to detail to ensure data quality (6 Years)
Ability to analyze data, identify issues, and validate data accuracy (6 Years)
Working knowledge with ETL process design, development and support (6 Years)
Working knowledge with ETL tools such as SSIS or equivalent (6 Years)
Working knowledge with Database Design and Data Modelling (6 Years)
T-SQL statements and stored procedures (6 Years)
Designing and implementing extraction, transformation, and loading data pipelines (6 Years)
Investigating data to anticipate any pipeline issues (6 Years)
Managing the maintenance of software (6 Years)
SSRS and SSAS (6 Years)
Working closely with data analysts on the ETL process (6 Years)
Troubleshooting and debugging database issues (6 Years)
Facilitating and training staff on ETL processes at each level (6 Years)
Working with stakeholders and managers to understand business goals (6 Years)
Implementing and updating new software (6 Years)
Designing and implementing SQL queries (6 Years)
Providing customer reporting (6 Years)
Total 6 (six) years' experience in data conversion/ETL projects with at least three (3) years in migrating data from legacy systems to Workday HCM (6 Years)
Desired Skills:
Strong understanding of Workday's data structures pertaining to HCM module
Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus
Client is seeking an experienced ETL Developer to design, develop, and maintain robust data pipelines that move data from various sources to our data warehouse. You will work with a team of data engineers, analysts, and stakeholders to ensure data quality, transform complex datasets, and support our business intelligence efforts. The ideal candidate will have experience with ETL tools, data integration, and SQL, and will be passionate about building efficient and scalable data pipelines
Job responsibilities:
Work with client business unit personnel and other stakeholders to extract data from legacy systems and transform it into a format compatible with Workday HCM
Define and document the mapping of data fields between legacy systems and Workday's data structures
Ensure the transformed data that is ready to be loaded into Workday is accurate, complete, and adheres to data quality standards through various validation techniques
Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse
Work closely with the data team to ensure data integrity, quality, and availability
Monitor ETL pipelines for performance and troubleshoot any issues or bottlenecks
Optimize data processing workflows to ensure scalability and efficiency
Document ETL processes and maintain best practices for data integration
Identify and resolve data-related issues that arise during the conversion process
Maintain detailed documentation of data mapping, transformation rules, and validation procedures
Develop and run test cases and scripts
Interview Process: In Person Only
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.