Data Warehouse/BI Developer
Data Warehouse/BI Developer
Posted on :
15-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Jobs by Experience
5years
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
15-07-2025
Job Description
Job Title:Data Warehouse/BI Developer (767150)
Client:Virginia Information Technology Agency
Location:Richmond VA
NOTE:Hybrid work location -Consultants will be required to work on site 2-3 days per week With In Person Only intrrview only.
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 qualitytransform complex datasets and support our business intelligence 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 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
Knowledge Skills and Abilities:
- Strong understanding of Workdays 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
If you are: bright motivated skilled a difference-maker able to get things done work with minimum direction
enthusiastic a thinker able to juggle and multi-task communicate effectively and lead then
we would like to hear from you. We need exceptionally capable people for this role for our client
so get back to us and tell us why you think you are a fit.
About Us:
Since 2000 Tri-Force Consulting Services () has been an MBE/SDB certified IT Consulting
firm in the Philadelphia region. Tri-Force specializes in IT staffing software development (web and mobile apps)
systems integration data analytics system automation cybersecurity and cloud technology solutions for government
and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity
increasing efficiencies through automation and lowering costs. Our clients benefit from our three distinguishing
core values: integrity diligence and technological excellence.
Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the
Inc. 5000 list of the nations fastest-growing companies.
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 goalsImplementing and updating new software Designing and implementing SQL queries Providing customer reporting
Education
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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
