Data Warehouse/BI Developer

Cyber Resource

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

Data profiling Required 5 Years

Data modeling Required 5 Years

SQL Server data mart development Required 5 Years

SSIS ETL development Required 5 Years

Source Control Required 3 Years

Dashboard/report creation Desired 3 Years

Apply

Vacancy posted 13 days ago

Similar jobs that could be interesting for youBased on the Data Warehouse/BI Developer in Richmond, VA vacancy

Data warehouse Developer
...Data warehouse Developer Python, SQL, NoSQL, Airflow, Spark/PySpark, REST API, AWS (Lambda, S3, RDS, Fargate, EC2, ECS, EMR, etc.) Data pipeline development, movement and maintenance Location: Plano TX (hybrid & local)/ Richmond, VA or McLean, VA hybrid...
Suggested
Local area
RIT Solutions, Inc.
Richmond, VA
2 days ago
Data Warehouse Developer
...Data Warehouse Developer Seeking a Data Warehouse Developer who can self manage, partner with BSAs and PMs, and translate business needs into... ...Dashboard/report creation (nice to have): Build basic dashboards or visualizations using tools such as Power BI or Tableau....
Suggested
Accylerate, LLC
Richmond, VA
3 days ago
SQL BI Developer
...SQL BI Developer **Onsite in Richmond, VA Tuesday/Wednesday; Remote Monday, Thursday, Friday** Scope: Team is seeking an experienced... ...to include creation of stored procedures or raw SQL Code Data Movement - Provide support in the design, development, and implementation...
Suggested
Remote work
Monday to Friday
Software Technology Inc
Richmond, VA
2 days ago
SQL Developer
...SQL Developer Position: SQL Developer Location: Must reside in CA, OR, WA, CO, GA, MD,... ...Synapse Analytics Experience in reporting, data analysis, and data warehousing Proven... ...Experience with Databricks Proficiency in Power BI reporting and dashboard development...
Suggested
Long term contract
Perfict Global, Inc.
Richmond, VA
1 day ago
SQL Developer
...Allen, VA 23060 Position Type: Full-time Seeking qualified SQL Developer with a Master’s or foreign equivalent degree in CS or IT or Engg... ...SSIS Packages and deploy using Deployment Wizard. Extract data from various sources like SQL Server 2008/10/12/14, Oracle, CSV...
Suggested
Full time
Work experience placement
VKare Corp
Glen Allen, VA
4 days ago
SQL SERVER DEVELOPER
...background in stored procedures and SQL. Job Description: SQL Server Developer: Proficient in stored procedures, functions, triggers, and SQL... .... Responsibilities: Analyze, design, and develop analytical data structures. Business Rules: Translate business rules into code....
Target Labs
Richmond, VA
4 days ago
SQL Developer & SSIS ETL Specialist — Travel Required
A technology solution provider is looking for a qualified SQL Developer to design and implement various SSIS packages. Candidates should... ...at least 6 months of related work experience. The role involves data extraction and development using SQL Server and Oracle, with...
Work experience placement
VKare Corp
Glen Allen, VA
4 hours ago
Artificial Intelligence Engineer
...such as Tenable for vulnerability management. Use SCCM and SCOM for automated patching and deployment. Develop disaster recovery plans to minimize downtime and prevent data loss. Apply strong networking knowledge including OSI layers and core network protocols. Required...
Contract work
Local area
RADIANT
Mechanicsville, VA
4 days ago
Bi Developer
...Power Bi Developer Modeling, designing, developing, and testing Power BI semantic layers, reports, and dashboards. Excellent written... ...oral communication skills, along with presentation skills using data visualizations for effective storytelling. Ability to quickly...
Work at office
PLANIT Group
Richmond, VA
3 days ago
BI DEVELOPER
...The Business Intelligence (BI) developer role works within a team of skilled professionals in... ...within Client on the topics of reporting and data management best practices and standards.... ...in large companies using SQL data warehouses, particularly Teradata. Excellent communications...
Target Labs
Richmond, VA
3 days ago
Senior Business Intelligence Engineer
$89k - $121.4k
...Intelligence Engineer solves complex business problems and issues using data from internal and external sources to provide insight to decision... ..., etc.) ~2+ years data visualization development (Power BI, Tableau) ~ Comprehensive knowledge of Microsoft 365 applications...
Bi-weekly pay
Full time
Temporary work
Apprenticeship
Work experience placement
Work at office
Remote work
Work from home
Home office
Humana
Richmond, VA
1 day ago
Business Intelligence Engineer
$66.8k - $91.1k
...Become a part of our caring community The Business Intelligence Engineer solves complex business problems using data from internal and external sources to provide insight to decision-makers. You will work assignments that are varied and frequently require interpretation...
Full time
Temporary work
Apprenticeship
Remote work
CenterWell
Richmond, VA
3 days ago
Decision Intelligence Engineer - Next Best Action
$129.3k - $177.8k
...instrument training pipelines. Additionally, you will collaborate with data and platform engineers. Furthermore, you will ensure the system... ..., Illinois, Montana, or South Dakota will be provided a bi-weekly payment for their internet expense.Humana will provide Home...
Bi-weekly pay
Full time
Temporary work
Apprenticeship
Work at office
Remote work
Work from home
Home office
Shift work
Night shift
Humana
Richmond, VA
1 day ago
.Net/SQL Server Programmer Developer
...Works as part of the Virginia Department of Health, Office of Information Management (VDH) to develop and maintain multiple .NET applications. Specific Tasks Develop, maintain, and enhance ASP.NET/MVC and .NET Core applications. Required Skill Set C# .NET – 5+ years’ experience...
Work at office
MBI
Richmond, VA
4 days ago
Power BI Developer
...Power Bi Developer Location: Richmond, VA Duration: 12 Months *local candidates Madatory *interviews will be conducted via Teams or Meet... ...Required / Desired - Require Exp - Have Over all IT experience in data analysis, data management, and report development - Required -...
Work at office
Local area
Remote work
My3Tech Inc
Richmond, VA
3 days ago
Power BI Developer
...Job Title: Power BI Developer Location: Richmond, VA 23219 on Hybrid (onsite 1 days/week) Duration: 15+ months with possible extension... ...other developers to create and maintain application code and data needed to operate Power Platform leveraging best standards and...
1 day per week
Integrated Resources
Richmond, VA
14 hours ago
Senior Data Analyst/BI Developer
...Senior Data Analyst/Bi Developer Our client, a software product company in the asset management space, is seeking a data analyst. This is a senior level, permanent/direct hire position. The employee will work a hybrid schedule, 3 days a week in the office ideally. Their...
Permanent employment
Casual work
Work at office
Flexible hours
3 days per week
Key Choice Group
Richmond, VA
14 hours ago
Power BI Developer
...Power Bi Developer Location: Richmond, VA or Des Moines, IA (Hybrid, 1–2 days onsite) Employment Type: Long-Term Contract About the... ...strategic business decisions. You will work closely with data teams, analysts, and senior leadership on initiatives focused on...
Long term contract
Key Choice Group
Glen Allen, VA
2 days ago
Senior Power BI Developer
...VDOT Senior Power BI Developer Location: 1401 E. Broad St. Richmond, VA *Local candidates only please *Candidate must also be able... ...development, including troubleshooting existing reports, updating data sources, and publishing to on-prem and cloud report servers....
For contractors
Work at office
Local area
2 days per week
3 days per week
My3Tech Inc
Richmond, VA
1 day ago
Sr. Business Intelligence Developer
$133.76k - $149.6k
...Responsibilities Job Title: Sr. Business Intelligence Developer Location: 4820 Lake Brook Drive, Ste. 300... ...and casualty insurance industry. Provide data development at a complex level and perform... ...troubleshoot complex SQL code. Utilize BI tools such as Tableau and Power BI....
Work experience placement
Remote work
W. R. Berkley
Glen Allen, VA
2 days ago
Enterprise Data Modeler
...meet the following criteria: Requirements: ~7 years of professional experience working in an enterprise environment as a Data Modeler using Erwin and/or star schema. ~ Background working with larger structured and unstructured data sets. ~ Experience working...
Local area
ShiftCode Analytics
Richmond, VA
4 days ago
Data Modeler
...Hybrid Richmond, V Long term contract Design enterprise data models (conceptual, logical, and physical) that enable trusted,... ...: Azure (Synapse, Fabric, SQL DB, Data Factory, Purview) • BI/Semantic Layer: Power BI, semantic models, measures, and calculation...
Long term contract
Work at office
PLANIT Group
Richmond, VA
3 days ago
Enterprise Data Modeler
...Job ID-ACSXMWN32 Enterprise Data Modeler Location - Richmond, VA (look for nearby candidates only) Interview Type - Both... ...that helps to establish, modify and maintain data model. • Develop canonical models, Data as a service models and Knowledge of SOA...
Remote work
Keylent Inc
Richmond, VA
14 hours ago
Data Architect (Remote)
$160k - $185k
...Technology Overview GovCIO is currently hiring an experienced Data Architect with deep expertise in cloud and network engineering... ...test plans and procedures to ensure contractual compliance. Develops and maintains documentation for network designs, policies, and...
Full time
Currently hiring
Remote work
Flexible hours
GovCIO
Richmond, VA
4 days ago
DATA ARCHITECT
...experience in architecture, design or development of enterprise data solutions, applications, and integrations ~ Experience... ...modern enterprise data architectures and data toolsets (ex: data warehouse, data marts, data lake, modeling tools, profiling tools) ~ Strong...
Work from home
Apex Informatics
Richmond, VA
1 day ago
Data Modeler
...Job Title: Data Modeler Location: Richmond, VA (Hybrid. 3 day onsite) Fulltime only For non-locals there will be relocation... ...metadata creation, metadata change management and reporting. Develop logical metadata models (e.g., metadata asset model, semantic...
Full time
Local area
Relocation package
Syntricate Technologies
Richmond, VA
2 days ago
Senior Data Architect
$3,600 per month
...Are you an experienced data leader ready to architect the future of enterprise-scale data platforms? Join Kinsale Insurance, a leading... ...evolution of enterprise data architecture across cloud data warehouses and transactional database platforms, ensuring scalability, performance...
Immediate start
Kinsale Insurance Company
Richmond, VA
2 days ago
Data Architect
...greater is required. ~5+ years serving in a data architecture position is required. ~5+... ...and model mission critical RDMS, BI, OLTP, OLAP and solutions leveraging multiple... ...writing skills, along with the ability to develop and present complex material effectively to...
InterSources
Richmond, VA
2 days ago
Oracle PL/SQL Developer
...Oracle PL/SQL Developer Location: Richmond, VA Duration: 12 Months Client is seeking... ...Datawarehouse Integration teams in EDM (Enterprise Data Management). The selected candidate will... ...transactions related to Enterprise Data Warehouse, Operational Data Store (ODS), and other...
My3Tech Inc
Richmond, VA
2 days ago
Oracle Database Developer
...hybrid from day -1 (Need only local candidates with local ID) Description: Experienced PL/SQL developer with skills in Oracle coding. Must also have ability to do data analysis, develop requirements and data models. Must have background in application backend support...
Local area
ShiftCode Analytics
Richmond, VA
4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse/BI Developer. Be the first to apply!