Description

Build and optimize data marts, ETL pipelines, and dimensional models to support analytics and reporting.

This role is on-site.

Responsibilities

• Analyze source systems to determine data availability, quality, and extraction logic.
• Design dimensional models and star schemas for analytics needs.
• Produce detailed mapping documents that translate business rules into technical specifications.
• Build and optimize tables, views, stored procedures, and indexes in SQL Server.
• Create and maintain database projects for versioned deployments using Visual Studio and GIT.

Required Skills

• 5+ years of experience with SQL Server data mart development.
• 5+ years of experience with SSIS ETL development.
• 5+ years of experience in data profiling.
• 5+ years of experience in data modeling.
• 3+ years of experience with source control (GIT).
• Experience creating and maintaining database projects in Visual Studio.

Preferred Skills

• 3+ years of experience creating dashboards or visualizations using Power BI or Tableau.

Key Skills

Education

Any Gradute