Data Warehouse / BI Developer 3
Stellar Professionals
Richmond, United States of America
28 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Richmond, United States of America
Tech stack
Databases
Data Validation
Information Engineering
ETL
Data Mart
Data Profiling
Data Systems
Data Warehousing
Dimensional Modeling
Microsoft Visual Studio
Microsoft SQL Server
Power BI
SQL Stored Procedures
SQL Server Integration Services
Data Streaming
Tableau
GIT
Drilldown
Software Version Control
Data Pipelines
Job description
You will be responsible for end-to-end data mart delivery. The core focus areas include
Requirements
We are looking for a self-directed Data Warehouse Developer who can translate business needs into clean, analytics-ready data solutions. If you excel at data engineering, dimensional modeling, and pipeline development, we want to hear from you!, * Data Profiling (5+ Years): Deep-dive analysis of source systems to determine data quality and extraction logic.
- Data Modeling (5+ Years): Designing dimensional models and star schemas using Kimball methodologies.
- SQL Server Development (5+ Years): Building and optimizing tables, views, stored procedures, and indexes.
- SSIS ETL Development (5+ Years): Building, scheduling, and monitoring robust ETL pipelines.
- Source Control (3+ Years): Managing code and database projects using GIT and Visual Studio.
- Data Flow Design: Creating detailed mapping documents and technical specifications.
- Data Validation: Writing tests to ensure data accuracy, completeness, and business rule alignment.
Bonus Skills (Nice-to-Have)
- Dashboarding (3+ Years): Basic visualization experience with Power BI or Tableau.