Data Warehouse/BI Developer

Propertyvalue American Business Solutions Inc.

Richmond, United States

about 2 months ago

Apply on dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

dice.com

Tech stack

Databases Data Validation Extract Transform Load (ETL) Data Mart Data Profiling Microsoft Visual Studio Microsoft SQL Server Power BI SQL Stored Procedures SQL Server Integration Services Data Streaming Git

+1 more

Software Version Control

Job description

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.Required/Desired Skills

Requirements

Skill Required/Desired Amount of Experience Data profiling Required 5.0 Years Data modeling Required 5.0 Years SQL Server data mart development Required 5.0 Years SSIS ETL development Required 5.0 Years Source Control Required 3.0 Years Dashboard/report creation Desired 3.0 Years

Skills:

Data profiling,Data modeling,SQL Server data mart development,SSIS ETL development,Source Control