Overview
Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Analytical Skill
Attention To Detail
Collaboration
Data Conversion
Data Extraction
Data Integration
Data Integrity
Data Loading
Data Mapping
Data Modeling
Data Processing
Data Quality
Transact-SQL
Scalability
Microsoft SSRS
Legacy Systems
Performance Tuning
Data Structure
Data Warehouse
Database
Database Design
Debugging
Documentation
Extract
Transform
Load
Extraction
Facilitation
HR Management
Informatica
Kronos
Management
Mapping
Microsoft SSAS
Microsoft SSIS
Migration
Reporting
SQL
Scripting
Software Design
Stored Procedures
Talend
Test Cases
Training
Unstructured Data
Workday
Workflow
Job Details
About Beacon Systems, Inc
Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Services. We have a vast portfolio of clients across the country. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
Position: Warehouse/BI Developer
Duration: 12 Months
Location: Richmond, VA (Hybrid)
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
Minimum Qualifications:
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
Required Skills:
6 Years 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
6Years 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 Bachelor s degree in IT, Computer Science or closely related field
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.
Desired Skills:
6 Years Previous experience in migrations working with Kronos, Cornerstone, and Workday is a plus
6 Years Strong understanding of Workday's data structures pertaining to HCM module.
Compensation:
Compensation for roles at Beacon Systems Inc depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, BeaconGov provides reasonable range of compensation for this role.
EEO Statement:
Beacon Systems is dedicated to fostering an inclusive and diverse work environment. We ensure equal employment opportunities for all individuals, regardless of their race, color, religion, gender, national origin, age, disability, or any other legally protected characteristic. Our commitment to being an equal-opportunity employer extends across all aspects of employment, from recruitment and hiring to promotions and benefits. We firmly believe in treating all employees and applicants fairly, based on their qualifications, skills, and performance.
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.