ZipRecruiter

Log In

1

Data Mart Jobs (NOW HIRING)

Ampcus Inc

Data Warehouse/BI Developer 3

Richmond, VA · On-site

$48.25 - $66/hr

Required : • Data profiling • Data modeling • SQL Server data mart development • SSIS ETL development • Source Control Preferred : • Dashboard/report creation Company : Ampcus is a global ...

Ask IT consulting

Data Modeler (W2)

San Antonio, TX · On-site

$49.50 - $64/hr

Company Description US IT Solutions. Required Skills - PLEASE INDICATE YEARS OF EXP BY EACH Data Models - Experienced in Data Mart (Star Shema Structures) and Warehouse Data Model designs (Normalized ...

Jobsbridge

Data Architect

Waukegan, IL

$60.50 - $78/hr

Experience working in Biopharmaceutical industry (regulatory affairs) Experience with Data Warehouse and Data Mart Design Additional Information Multiple Openings for OPT/CPT/H4/L2/EAD/Citizen'

Concord IT Systems

Azure Data Engineer

Denver, CO · On-site

$117K - $141K/yr

Talent should have knowledge to build a separate data mart, data layer with apis to consume data for reporting, dashboard, analytics using data bricks

Fidelity Investments

Principal Data Engineer

Durham, NC

$110K - $132K/yr

Develops and maintains databases using principles of Database Warehousing and Data mart concepts. * Confers with systems analysts and other software engineers/developers to design systems and to ...

Fidelity Investments

Principal Data Engineer

Durham, NC · On-site

$110K - $132K/yr

Develops and maintains databases using principles of Database Warehousing and Data mart concepts. * Confers with systems analysts and other software engineers/developers to design systems and to ...

Keylent Inc

Data Modeler and Snowflake Admin

Troy, MI · On-site

$51.25 - $66.50/hr

Data Modeler And Snowflake Admin Profiling, creating, advising and reviewing data models for our data warehouse atomic as well as data mart areas. Should be able to provide design of the table ...

1 Point System

Data Warehouse/SQL BI Developer 3

Richmond, VA · On-site

$48.75 - $66.75/hr

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 ...

next page

Showing results 1-20

All JobsData Mart Jobs

Data Mart information

See salary details

$46K

$165K

$243.5K

How much do data mart jobs pay per year?

As of Jun 29, 2026, the average yearly pay for data mart in the United States is $165,018.00, according to ZipRecruiter salary data. Most workers in this role earn between $133,500.00 and $170,000.00 per year, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive as a Data Mart Developer, and why are they important?

To succeed as a Data Mart Developer, you need a strong background in database design, data warehousing concepts, and proficiency in SQL, often supported by a degree in computer science or a related field. Familiarity with ETL tools (such as Informatica or Talend), data modeling software, and experience with platforms like Microsoft SQL Server or Oracle are typically required. Attention to detail, problem-solving skills, and effective communication help ensure that business requirements are accurately translated into robust data solutions. These skills are vital to deliver reliable, scalable data marts that support organizational analytics and decision-making.

What are some common challenges faced by professionals managing Data Marts, and how can they be addressed?

Professionals managing Data Marts often encounter challenges such as ensuring data consistency across multiple sources, optimizing query performance, and maintaining data security. Addressing these challenges typically involves implementing robust ETL (Extract, Transform, Load) processes, regularly monitoring and tuning database performance, and establishing clear data governance policies. Collaborating closely with data engineers, business analysts, and IT security teams is essential for maintaining the reliability and integrity of the Data Mart environment.

What is a Data Mart?

A Data Mart is a specialized subset of a data warehouse, designed to focus on a specific business area, department, or function within an organization, such as sales, finance, or marketing. It stores relevant data that is extracted, transformed, and loaded from various sources to facilitate targeted analysis and reporting. Data Marts help users access critical information quickly and make better business decisions by providing a simplified and more focused view of data compared to a full-scale data warehouse.

What is the difference between Data Mart vs Data Analyst?

AspectData MartData Analyst
Primary RoleStores and manages specific data subsets for quick accessAnalyzes data to generate insights and reports
Skills & CertificationsDatabase management, SQL, data warehousingData analysis, SQL, Excel, visualization tools
Work EnvironmentData warehouses, business intelligence systemsOffice, data analysis tools, reporting platforms
Industry UsageIT, Business Intelligence, Data ManagementBusiness, Marketing, Finance, IT

While a Data Mart focuses on storing and organizing data for quick retrieval, a Data Analyst interprets this data to provide actionable insights. Both roles are essential in data-driven organizations but serve different functions within the data ecosystem.

More about Data Mart jobs
What states have the most Data Mart jobs? States with the most job openings for Data Mart jobs include:
What job categories do people searching Data Mart jobs look for? The top searched job categories for Data Mart jobs are:
Data Mart jobs near you
Data Warehouse/BI Developer 3

Data Warehouse/BI Developer 3

Ampcus Inc

Richmond, VA • On-site

$48.25 - $66/hr

Full-time

Posted 5 days ago

Job description

Job Summary:
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. They are seeking a Data Warehouse/BI Developer who can partner with BSAs and PMs to translate business needs into actionable data solutions while managing data engineering tasks using SQL Server and ETL pipelines.
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.
Qualifications:
Required:
• Data profiling
• Data modeling
• SQL Server data mart development
• SSIS ETL development
• Source Control
Preferred:
• Dashboard/report creation
Company:
Ampcus is a global business, technology consulting and an staff augmentation firm specializing in AI/ML,digital solutions, Cybersecurity & Risk management, Testing, Forensics & Fraud services and human capital management. Founded in 2004, the company is headquartered in Chantilly, USA, with a team of 1001-5000 employees. The company is currently Late Stage.
Ampcus logo

About Ampcus

Sourced by ZipRecruiter

Ampcus Inc. is a ISO 20000, ISO 27000, ISO 9001, CMMI DEV/3 SM and CMMI SVC/3 SM certified global provider of a broad range of Technology and Business consulting services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, client goals become our goals. Their success is our satisfaction. It’s why our clients sleep well at night. We believe that the success of an engagement is determined by strong project management, as well as clear communication and mutual commitment working collaboratively. Our methodology begins with listening to the customer about their needs, then working with their team to gain a clear understanding of the requirements, while providing knowledge transfer of best practices for the organization.

Industry

It services

Company size

1,001 - 5,000 Employees

Headquarters location

Chantilly, VA, US

Year founded

2004

View All Ampcus Jobs

Apply