What are the responsibilities and job description for the Data Warehouse Specialist position at VSG Business Solutions LLC?
Need locals
Need copy of bachelors degree
Hybrid - 3 days onsite per week
Looking for BI / Data Warehouse Specialists to facilitate the re-platforming of our current Data Warehouse to Oracle FDIP, ensuring data integrity and optimal performance. This resource will also assist as a Data Conversion Specialist, they will be responsible for extracting, transforming, and loading (ETL) data from PeopleSoft into our Data Warehouse system, and rebuilding data warehouse structures and reports in the FDIP system. They will ensure that data and reports are accurately migrated and optimized for accurate reporting and analytics, collaborating with various teams to achieve
project goals.
- Create data mapping documents that outline the relationships between source and target data fields.
- Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity.
- Utilize ETL tools for data integration.
- Validate data accuracy and completeness post-migration to ensure that all data has been successfully transferred.
- Work closely with business analysts, data architects, and stakeholders to understand data requirements and ensure alignment with business objectives
- Analyze requirements for BI reports and dashboards; analyze data sources for mapping to BI requirements; work closely with customers to determine the best approach for the user community.
- Use BI tools to develop reports, dashboards, and widgets; create and execute test plans, coordinate life cycle activities from development to production, create and maintain data models to support requirements.
- Determine the best approach for data delivery depending on data sources and requirements.
- Develop spreadsheets and databases as needed to support interim strategies for data.
- Analyze and gather the requirements of BI data from users / customers.
- Create ETL / ELT for Peoplesoft EPM Datawarehouse.
- Maintaining the ERP data warehouse and Ascential / Datastage environments.
- Design and develop data models and data mart tables.
- Design and develop ETL processes and data pipelines using Data Stage ETL tool.
- Support and maintenance of Production ETL processes and jobs of Data Stage.
- Support and fulfill adhoc data requests from customers and management using SQL queries and Excel sheets and to perform data validation, accuracy and its completeness during delivery of the data. Support other BI team members during development of reports and dashboards for their data needs.
- Document product specifications, create user guides for operations and maintenance.
- Support cyber security reviews and implement remediations as required
Qualifications
Preferred Skills :
