Data Warehouse Specialist L3

Collins Consulting; Washington (District of Columbia); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer with extensive experience in data migration and ETL processes. In this dynamic role, you will design and implement ETL workflows, ensuring data integrity and performance while collaborating with various stakeholders. Your expertise in SQL and familiarity with data warehousing concepts will be crucial as you create data mapping documents and validate data accuracy. This position offers an exciting opportunity to work with cutting-edge cloud-based Data Warehouse solutions and contribute to impactful BI projects. If you are passionate about data and thrive in a collaborative environment, this role is perfect for you.

Qualifications

• 8+ years of experience in data migration projects.
• Strong proficiency in SQL and ETL tools for data integration.

Responsibilities

• Design and implement ETL processes for data loading into the Data Warehouse.
• Create data mapping documents and validate data accuracy post-migration.

Skills

SQL

ETL tools

Data migration

IBM DataStage

Data modeling

Analytical skills

Communication skills

Problem-solving skills

Education

Graduate degree in Management Information Science

Bachelor’s degree in Computer Science

Tools

IBM DataStage

PeopleSoft

Cloud-based Data Warehouse platforms

Job description

Must be a US Citizen or Green Card holder and local to the Metro DC Area.

Responsibilities:

• 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 and analyze data sources for mapping to BI requirements.
• Work closely with customers to determine the best approach for the user community and 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 and 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 and to analyze and gather the requirements of BI data from users/customers.
• Create ETL/ELT for Peoplesoft EPM Datawarehouse.
• Maintain the ERP data warehouse and Ascential/Datastage environments.
• Design and develop data models and data mart tables and develop ETL processes and data pipelines using Data Stage ETL tool.
• Support and maintain Production ETL processes and jobs of Data Stage.
• Support and fulfill adhoc data requests from customers and management using SQL queries and Excel sheets; perform data validation, accuracy, and 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 support cyber security reviews and implement remediations as required.

Skills:

• 8 years of experience.
• 5+ years of experience in data migration projects, specifically from PeopleSoft to a Cloud Based Data Warehouse system.
• Strong proficiency in SQL for data extraction and manipulation.
• Experience with ETL tools and data integration techniques.
• Familiarity with data warehousing concepts, data modeling, and reporting tools.
• Excellent analytical, problem-solving, and communication skills; strong attention to detail and commitment to data accuracy.
• Experience in IBM Datastage.
• Experience in customizing Peoplesoft delivered maps.
• Six (6) months of experience using the Datastage tool and version designated in the Task Order.
• Excellent communication skills.

Education:

• Graduate degree or equivalent from an accredited college or university with a bachelor’s degree in Management Information Science, Computer Science, Mathematics, Finance, Business, Accounting, Public Administration, or in a related discipline.

Preferred Skills:

• Experience with cloud-based Data Warehouse platforms and solutions (e.g., Oracle FDIP, Snowflake, Amazon Redshift, Google BigQuery).
• Relevant certifications in data management or ETL tools are a plus.
• Experience with one or more of the following systems: Maximo, PeopleSoft FSCM, HCM, ELM, PeopleSoft EPM, NextFare, and Trapeze.
• 3+ years of experience in building ETL Maps/Sequences using IBM DataStage (IBM Infosphere Information Server).
• In-depth understanding of Data Warehousing.