Data Warehouse/BI Developer 3

Ampcus, Inc; Richmond (VA); On-site; USD 80,000 - 100,000; Full time

Job summary

Ampcus, Inc is seeking a Data Warehouse/BI Developer 3 in Richmond, VA. Candidates should possess strong SQL Server skills, and experience in data profiling, modeling, and ETL development is essential.

This role requires strong analytical capabilities and the ability to communicate effectively across teams. Candidates must be able to work on site, with a preference for local applicants. Join us in delivering high-quality data solutions in an equal opportunity environment.

Qualifications

• 5 years of experience in data profiling.
• 5 years of experience in data modeling.
• 5 years of experience in SQL Server data mart development.
• 5 years of experience in SSIS ETL development.
• 3 years of experience in source control management.
• 3 years of experience in dashboard/report creation is desired.

Responsibilities

• Analyze and understand source systems to determine data availability and quality.
• Design dimensional models and star schemas for analytics.
• Produce detailed mapping documents translating business rules.
• Build and optimize tables and views in SQL Server.
• Create and maintain database projects in Visual Studio.
• Manage code changes and collaboration workflows in GIT.
• Build and monitor ETL packages in SSIS.
• Ensure data accuracy and completeness through testing.
• Build dashboards or visualizations using tools like Power BI.

Skills

Data profiling

Data modeling

SQL Server data mart development

SSIS ETL development

Source control management

Dashboard/report creation

Tools

SQL Server

Visual Studio

GIT

Power BI

Tableau

Job description

Job Title: Data Warehouse/BI Developer 3

Location(s): Richmond, VA

Job Summary

A Data Warehouse Developer who can selfmanage, 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 nontechnical 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.

Required Qualifications

• Data profiling: 5 years of experience
• Data modeling: 5 years of experience
• SQL Server data mart development: 5 years of experience
• SSIS ETL development: 5 years of experience
• Source Control: 3 years of experience
• Dashboard/report creation: 3 years of experience (desired)

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.