Data Warehouse/Bi Developer 3

Ampcus IncorporatedRichmond, VA

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Remote

On-site

Job Description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Data Warehouse/BI Developer 3

Location(s): Richmond, VADescription: 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.

Skills:

Skill	Required / Desired	Amount	of Experience	Expertise Rating	Move
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

Additional Information

Candidates must be able to interview and work on site.
Local Candidates are strongly preferred.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Data Warehouse/Bi Developer 3 Jobs at Ampcus Incorporated

What is the work location for this position at Ampcus Incorporated?

This job at Ampcus Incorporated is located in Richmond, VA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at Ampcus Incorporated?

Employer has not shared pay details for this role.

What employment applies to this position at Ampcus Incorporated?

The employer has not provided this information. This may be discussed during the hiring process.

What is the process to apply for this position at Ampcus Incorporated?

You can apply for this role at Ampcus Incorporated either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.