Data Warehouse/BI Developer 3

Ampcus Incorporated

Richmond, VA

JOB DETAILS
SKILLS
Alliance/Partner Management, Business Intelligence, Business Services, Change Management, Communication Skills, Consulting, Data Analysis, Data Mart, Data Modeling, Data Profiling, Data Quality, Data Warehousing, Database Administration, Database Design, Database Extract Transform and Load (ETL), Dimensional Modeling, Git, Interviewing Skills, Loading/Unloading, Microsoft SQL Server, Microsoft Visual Studio, Power BI, Precision Testing, Reporting Dashboards, SQL Server Integration Services (SSIS), Source Code/Configuration Management (SCM), Star Schema, Stored Procedures, Tableau, Validation Testing
LOCATION
Richmond, VA
POSTED
3 days ago

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, VA

Job Summary:

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.

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.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com