Data Warehouse Developer

GlobalPoint; Richmond (VA); On-site; USD 95,000 - 130,000; Full time

Job summary

GlobalPoint in Richmond, VA is seeking a Data Warehouse Developer who can self-manage and collaborate with BSAs and PMs to translate business needs into analytics-ready data solutions.

The role emphasizes SQL Server, Kimball dimensional modeling, SSIS ETL, data marts, and governance via Git and Visual Studio, with dashboard capabilities a nice to have.

Qualifications

• Experience building analytics-ready data solutions from SQL Server data sources.
• Strong data modeling using Kimball methodologies for dimensional models and star schemas.
• Hands-on development of data marts, SSIS ETL pipelines, and data flow design documentation.
• Ability to design, implement, and manage database projects in Visual Studio and track changes with Git.
• Experience validating data accuracy through testing and dashboards is a plus.

Responsibilities

• Data profiling: Analyze source systems to determine data availability and quality.
• Data modeling: Design dimensional models and star schemas for analytics.
• Data flow design: Produce mapping documents translating business rules to technical specs.
• SQL Server data mart development: Build and optimize tables, views, procedures, indexes.
• Visual Studio database projects: Create and maintain versioned deployments.
• GIT source control: Manage code changes and branching workflows.
• SSIS ETL development: Build, schedule, and monitor ETL packages.
• Data validation testing: Ensure data accuracy and completeness.
• Dashboard/report creation: Build basic dashboards in Power BI or Tableau.

Skills

Data profiling

Data modeling

SQL Server ETL

SSIS ETL

Source control

Dashboard creation

Tools

Visual Studio

Git

Power BI

Tableau

Job description

Description: A Data Warehouse Developer who can self manage, partner with BSAs and PMs, and translate business needs into actionable, analytics ready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and hands on development of data marts, SSIS ETL pipelines, and data flow design documentation. The developer must be able to deep-dive profile source systems, design and implement database projects in Visual Studio, manage code in GIT, and validate data accuracy through testing. Experience building dashboards is helpful but secondary.

Richmond, VA

Long term

Description: A Data Warehouse Developer who can self manage, partner with BSAs and PMs, and translate business needs into actionable, analytics ready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and hands on development of data marts, SSIS ETL pipelines, and data flow design documentation. The developer must be able to deep-dive profile source systems, design and implement database projects in Visual Studio, manage code in GIT, and validate data accuracy through testing. Experience building dashboards is helpful but secondary. 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.

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

Skill

Required / Desired
Amount
Actual exp

• Data profiling
  5
• Data modeling
  5
• SQL Server data mart development
  5
• SSIS ETL development
  5
• Source Control
  3
• Dashboard/report creation
  3