Description

You will lead the design, development, and implementation of complex ETL processes and dimensional models.

This role is on-site.

Responsibilities

• Gather and validate BI and reporting requirements from stakeholders.
• Design and review star schema dimensional models for data warehouses and marts.
• Perform data profiling on source systems and create source-to-target mappings.
• Develop ETL transformations using Pentaho Data Integration (PDI) or SSIS.
• Execute testing and complete technical documentation for all solutions.

Required Skills

• 12+ years of experience in Information Technology.
• 7 years of experience building ETL pipelines for data warehouse loads.
• 7 years of experience with Pentaho Data Integration (PDI) or SSIS.
• 7 years of experience in reporting and analytics using Pentaho or Tableau.
• 7 years of experience with complex SQL development in Sybase ASE or SQL Server.
• 7 years of experience in data profiling and source-to-target mapping.
• 7 years of experience in stakeholder communication and presentation development.
• 5 years of experience in Star Schema and Dimensional Modeling.
• 4 years of specific experience in Pentaho Data Integration (PDI) development.

Preferred Skills

• Experience with Power BI for reporting and analytics.

Key Skills

Education

Any Gradute