Description

You will design, build, and maintain SQL Server data marts and ETL pipelines while ensuring data quality and accurate reporting.

Data profiling — Analyze source systems to determine data availability, quality, and extraction logic.

Data modeling — Design dimensional models and star schemas to support analytics and reporting needs.

Data flow design — Produce clear, detailed mapping documents that translate business rules into technical specifications.

SQL Server development — Build and optimize tables, views, stored procedures, and indexes.

SSIS ETL development — Build, schedule, and monitor ETL packages to load data marts reliably and efficiently.

Responsibilities

• Design and implement dimensional data models and star schemas.
• Develop and optimize SQL Server database objects including tables, views, and stored procedures.
• Build, schedule, and monitor SSIS ETL packages for reliable data loading.
• Manage database projects in Visual Studio using GIT for version control and deployment.
• Validate data accuracy, completeness, and alignment with business rules.

Required Skills

• 5+ years of experience in data profiling and understanding source systems.
• 5+ years of experience in data modeling, specifically dimensional models and star schemas.
• 5+ years of experience developing SQL Server data marts.
• 5+ years of experience with SSIS ETL development.
• 3+ years of experience with source control tools (GIT).
• Strong proficiency in SQL Server and database optimization.

Preferred Skills

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

Key Skills

Education

Any Gradute