Accylerate, LLC.
Data Warehouse Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Developer on a contract basis, requiring strong SQL Server skills, data modeling with Kimball methodologies, and hands-on experience with SSIS ETL pipelines. Knowledge of GIT and dashboard creation is a plus.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 26, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Richmond, VA
-
🧠 - Skills detailed
#Data Modeling #SQL (Structured Query Language) #"ETL (Extract #Transform #Load)" #Microsoft Power BI #Visual Studio #SSIS (SQL Server Integration Services) #Data Mart #Tableau #Visualization #BI (Business Intelligence) #Data Accuracy #Data Warehouse #Deployment #SQL Server #GIT #Documentation #Data Profiling #Data Engineering
Role description
Ideal Candidate Profile : Seeking 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 handson 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.
Job Duties & Responsibilitie s
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.
Ideal Candidate Profile : Seeking 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 handson 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.
Job Duties & Responsibilitie s
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.
