TechnoSmarts, Inc.
Data Warehouse/BI Developer 4
TechnoSmarts, Inc. - Richmond, Virginia, United States, 23214
Work at TechnoSmarts, Inc.
Overview
- View job
Overview
Get AI-powered advice on this job and more exclusive features.
TechnoSmarts has a Data Warehouse/BI Developer 4 position with their client located in Richmond, VA. This is a 11 month contract with potential for extension and is a Hybrid position. Consultant will be required to work on-site up to 3x/week.
Essential Duties and Responsibilities:
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 VRS 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 Knowledge, Skills, and Abilities: Strong understanding of Workday's data structures pertaining to HCM module. Hands on knowledge on
Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning, Data Quality Assurance
&
Documentation and Collaboration.
Proven experience in working with ETL tools such as Informatica, Talend, or SSIS. Strong knowledge of SQL for querying and manipulating data in databases. Experience in data integration from various data sources, including structured and unstructured data. Ability to troubleshoot and resolve performance issues in ETL pipelines. Strong analytical skills and attention to detail to ensure data quality. Ability to analyze data, identify issues, and validate data accuracy. Working knowledge with the following tools and technologies: ETL process design, development and support ETL tools such as SSIS or equivalent Database Design and Data Modelling T-SQL statements and stored procedures SSRS and SSAS Designing and implementing extraction, transformation, and loading data pipelines Investigating data to anticipate any pipeline issues Managing the maintenance of software Working closely with data analysts on the ETL process Troubleshooting and debugging database issues Facilitating and training staff on ETL processes at each level Working with stakeholders and managers to understand business goals Implementing and updating new software Designing and implementing SQL queries Providing customer reporting Education and Experience: Bachelor’s degree in IT, Computer Science or closely related field 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. Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus Strong understanding of Workday's data structures pertaining to HCM module. 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 Bachelor’s 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 6 Years Seniority level
Seniority level Associate Employment type
Employment type Contract Job function
Job function Information Technology Industries Government Administration Referrals increase your chances of interviewing at TechnoSmarts, Inc. by 2x Sign in to set job alerts for “Data Warehouse Specialist” roles.
Chesterfield County Data Warehouse Arch 2 (752301)
Richmond, VA $70,000.00-$90,000.00 2 weeks ago SiteOps Data Center Production Operations Engineer
Data Center Production Operations Engineer
Need Data Warehouse/BI Developer 4 - Local to Richmond, VA
Need Data Analyst 3 - Local to Richmond, VA
Infrastructure Engineer, Data Center - Overnight Schedule, 8pm to 6am
Chester, VA $100,000.00-$120,000.00 1 month ago Need Business Analyst - Data and QA - Local to Richmond, VA
Net Suite Administrator and Data Analyst - Manufacturing
Richmond, VA $80,000.00-$100,000.00 5 hours ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
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 VRS 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 Knowledge, Skills, and Abilities: Strong understanding of Workday's data structures pertaining to HCM module. Hands on knowledge on
Data Extraction, Data Transformation, Data Loading, Workflow Development, Performance Tuning, Data Quality Assurance
&
Documentation and Collaboration.
Proven experience in working with ETL tools such as Informatica, Talend, or SSIS. Strong knowledge of SQL for querying and manipulating data in databases. Experience in data integration from various data sources, including structured and unstructured data. Ability to troubleshoot and resolve performance issues in ETL pipelines. Strong analytical skills and attention to detail to ensure data quality. Ability to analyze data, identify issues, and validate data accuracy. Working knowledge with the following tools and technologies: ETL process design, development and support ETL tools such as SSIS or equivalent Database Design and Data Modelling T-SQL statements and stored procedures SSRS and SSAS Designing and implementing extraction, transformation, and loading data pipelines Investigating data to anticipate any pipeline issues Managing the maintenance of software Working closely with data analysts on the ETL process Troubleshooting and debugging database issues Facilitating and training staff on ETL processes at each level Working with stakeholders and managers to understand business goals Implementing and updating new software Designing and implementing SQL queries Providing customer reporting Education and Experience: Bachelor’s degree in IT, Computer Science or closely related field 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. Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus Strong understanding of Workday's data structures pertaining to HCM module. 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 Bachelor’s 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 6 Years Seniority level
Seniority level Associate Employment type
Employment type Contract Job function
Job function Information Technology Industries Government Administration Referrals increase your chances of interviewing at TechnoSmarts, Inc. by 2x Sign in to set job alerts for “Data Warehouse Specialist” roles.
Chesterfield County Data Warehouse Arch 2 (752301)
Richmond, VA $70,000.00-$90,000.00 2 weeks ago SiteOps Data Center Production Operations Engineer
Data Center Production Operations Engineer
Need Data Warehouse/BI Developer 4 - Local to Richmond, VA
Need Data Analyst 3 - Local to Richmond, VA
Infrastructure Engineer, Data Center - Overnight Schedule, 8pm to 6am
Chester, VA $100,000.00-$120,000.00 1 month ago Need Business Analyst - Data and QA - Local to Richmond, VA
Net Suite Administrator and Data Analyst - Manufacturing
Richmond, VA $80,000.00-$100,000.00 5 hours ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr