Data Warehouse Developer

Data Profiling

Analyze and understand 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 Data Mart Development

Build and optimize tables, views, stored procedures, and indexes.

Visual Studio Database Projects

Create and maintain database projects for versioned, repeatable deployments.

Git Source Control

Manage code changes, branching, and collaboration workflows.

SSIS ETL Development

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

Data Validation Testing

Ensure accuracy, completeness, and alignment with business rules.

Dashboard/Report Creation (Nice to Have)

Build basic dashboards or visualizations using tools such as Power BI or Tableau.