Senior Data Warehouse & BI Developer (SQL Server/SSIS)

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

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.