Data Warehouse Developer

About the role

A Data Warehouse Developer who can self-manage, partner with Business Systems Analysts (BSAs) and Project Managers (PMs), and translate business needs into actionable, analytics-ready data solutions. This role is ideal for someone who thrives in a self-directed environment, communicates clearly with both technical and non-technical partners, and takes pride in delivering clean, well-modeled, well-tested data.

Responsibilities

• 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.

Requirements

• 5+ years of experience in data profiling
• 5+ years of experience in data modeling using Kimball methodologies
• 5+ years of experience in SQL Server data mart development
• 5+ years of experience in SSIS ETL development
• 3+ years of experience with source control (GIT)
• 3+ years of experience in dashboard/report creation (desired)