Data Warehouse/BI Developer 4 (Hybrid)
Data Warehouse/BI Developer 4 (Hybrid)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Title: Data Warehouse/BI Developer 4 (Hybrid)
Location: Richmond VA
Duration: 12 Months
Job Description:
We are 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.
Key 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 Workdays 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
Skills:
Skill
Required / Desired
Amount
of Experience
Strong understanding of Workdays data structures pertaining to HCM module.
Desired
6
Years
Hands on knowledge on Data Extraction Data Transformation Data Loading Workflow Development Performance Tuning.
Required
6
Years
Hands on knowledge on Data Quality Assurance & Documentation and Collaboration.
Required
6
Years
Proven experience in working with ETL tools such as Informatica Talend or SSIS.
Required
6
Years
Strong knowledge of SQL for querying and manipulating data in databases.
Required
6
Years
Experience in data integration from various data sources including structured and unstructured data.
Required
6
Years
Ability to troubleshoot and resolve performance issues in ETL pipelines.
Required
6
Years
Strong analytical skills and attention to detail to ensure data quality.
Required
6
Years
Ability to analyze data identify issues and validate data accuracy.
Required
6
Years
Working knowledge with ETL process design development and support
Required
6
Years
Working knowledge with ETL tools such as SSIS or equivalent
Required
6
Years
Working knowledge with Database Design and Data Modelling
Required
6
Years
T-SQL statements and stored procedures
Required
6
Years
Designing and implementing extraction transformation and loading data pipelines
Required
6
Years
Investigating data to anticipate any pipeline issues
Required
6
Years
Managing the maintenance of software
Required
6
Years
SSRS and SSAS
Required
6
Years
Working closely with data analysts on the ETL process
Required
6
Years
Troubleshooting and debugging database issues
Required
6
Years
Facilitating and training staff on ETL processes at each level
Required
6
Years
Working with stakeholders and managers to understand business goals
Required
6
Years
Implementing and updating new software
Required
6
Years
Designing and implementing SQL queries
Required
6
Years
Providing customer reporting
Required
6
Years
Bachelors degree in IT Computer Science or closely related field
Required
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.
Required
6
Years
Previous experience in migrations working with Kronos Cornerstone and Workday is a plus
Desired
6
Employment Type
Full-time
