Description

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

Responsibilities

• Gather and validate BI and reporting requirements from stakeholders.
• Design and review star schema dimensional models to support data warehouses and data marts.
• Perform data profiling on source systems and create source-to-target mappings.
• Develop ETL transformations using Pentaho Data Integration (PDI) or SSIS.
• Build reports and analytics using Pentaho, Tableau, or Power BI.
• Write complex Transact-SQL queries leveraging analytic functions.
• Execute testing and complete technical documentation for all solutions.

Required Skills

• 12+ years of experience in Information Technology, operating beyond a standard programming role.
• 84 months of experience building ETL pipelines to drive data warehouse loads.
• 84 months of experience with Pentaho Data Integration (PDI) or SSIS.
• 84 months of experience in reporting and analytics using Pentaho or Tableau.
• 84 months of experience with complex SQL development in Sybase ASE or SQL Server.
• 84 months of experience in data profiling and source-to-target mapping.
• 84 months of experience in stakeholder communication and presentation development.
• 60 months of experience in Star Schema and Dimensional Modeling.
• 48 months of specific experience in Pentaho Data Integration (PDI) development.

Preferred Skills

• Experience with Power BI for reporting and analytics.

Key Skills

Education

Any Gradute