1

Data Warehousing Analyst Jobs (NOW HIRING)

Acts as a Subject Matter Expert (SME) on enterprise data warehouse (EDW) content and insurance ... Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.

Senior Data Analyst

Minnetonka, MN · On-site

$87K - $110K/yr

We are seeking a highly experienced Senior Data Analyst with strong expertise in healthcare data, clinical data warehousing, and quality measures. The ideal candidate will combine strong analytical ...

The role involves collaborating with department leaders to define business metrics, analyzing data structures, and building a robust data warehouse. Responsibilities : • Help transition and ...

... analytics, and strategic decision-making. This role requires strong expertise in Informatica ... Data Warehousing * Power BI * Cognos * API Development * Data Modeling * Snowpipe * Streams & Tasks

... Data Warehousing - business or data analysis experience in data warehousing 2+ years of experience with query tools such as Cognos, SAS, Toad, or Teradata SQL Assistant 5+ years of experience with ...

Job Summary We are looking for an experienced Data Modeller to support enterprise-scale data initiatives involving data warehousing, analytics, and cloud-based data platforms. The role requires ...

Job Summary We are looking for an experienced Data Modeller to support enterprise-scale data initiatives involving data warehousing, analytics, and cloud-based data platforms. The role requires ...

The Data Warehouse Engineer will be responsible for building and maintaining an internal data warehouse, aggregating data from various source systems, and facilitating complex business analyses ...

Collaborate with business stakeholders and management to understand analytical requirements and ... Stay current with emerging technologies, tools, and methodologies in data warehousing and data ...

Lead data warehousing efforts and performing data analysis as needed across sets of transactional, operational, device, and various other data sources. Coordinate with the development team, business ...

Mohegan Sun is a premier entertainment destination, and they are seeking a Data Warehouse Analyst to work with end users to design and implement decision support assets. The role involves maintaining ...

Sr Data Engineer (Databricks)

Plano, TX · On-site

$109K - $131K/yr

Experience with cloud data warehouse and analytics technologies, specifically Azure Databricks, Azure Synapse, Azure Data Factory, Azure Data Lake Storage, Power BI, and other Azure data solutions

New

Sr Data Engineer (Databricks)

Camas, WA · On-site

$126K - $151K/yr

Experience with cloud data warehouse and analytics technologies, specifically Azure Databricks, Azure Synapse, Azure Data Factory, Azure Data Lake Storage, Power BI, and other Azure data solutions

New

next page

Showing results 1-20

Data Warehousing Analyst information

See salary details

$34K

$82.6K

$136K

How much do data warehousing analyst jobs pay per year?

As of Jun 27, 2026, the average yearly pay for data warehousing analyst in the United States is $82,640.00, according to ZipRecruiter salary data. Most workers in this role earn between $62,500.00 and $97,000.00 per year, depending on experience, location, and employer.

What is the difference between Data Warehousing Analyst vs Data Engineer?

AspectData Warehousing AnalystData Engineer
Primary FocusAnalyzing and maintaining data warehouse data, reporting, and data qualityDesigning, building, and maintaining data pipelines and infrastructure
Skills & CertificationsSQL, data analysis, data warehousing tools, certifications like Microsoft Certified Data AnalystProgramming (Python, Java), ETL tools, cloud platforms, certifications like AWS Certified Data Analytics
Work EnvironmentBusiness intelligence teams, data analysis departmentsData engineering teams, IT infrastructure
Industry UsageFinance, healthcare, retail, where data analysis is keyTech, finance, e-commerce, focusing on data infrastructure

The main difference between a Data Warehousing Analyst and a Data Engineer lies in their focus: analysts interpret and report on data stored in warehouses, while engineers build and maintain the systems that store and process the data. Both roles often collaborate but serve distinct functions within data management.

What is a Data Warehousing Analyst?

A Data Warehousing Analyst is a professional who designs, implements, and maintains data warehouse systems. They gather and analyze data from multiple sources, ensuring data quality, integrity, and accessibility for business intelligence and reporting purposes. Their role often involves collaborating with IT teams and business stakeholders to meet organizational data needs. Data Warehousing Analysts also optimize data storage and retrieval processes to support informed decision-making.

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

To thrive as a Data Warehousing Analyst, you need strong analytical skills, experience with database management, and a background in computer science or a related field. Expertise in SQL, ETL tools (such as Informatica or Talend), and familiarity with data warehousing platforms like Amazon Redshift or Snowflake are typically required. Attention to detail, problem-solving abilities, and effective communication are important soft skills for translating business needs into technical solutions. These skills ensure accurate data integration, reliable reporting, and support critical decision-making within organizations.

What are some common challenges a Data Warehousing Analyst faces when integrating data from multiple sources?

Data Warehousing Analysts often encounter challenges such as discrepancies in data formats, varying data quality, and inconsistent data definitions across different systems. Successfully integrating data requires thorough data profiling, transformation, and cleansing to ensure accuracy and consistency. Additionally, collaborating closely with business units and IT teams is crucial to understand data requirements and resolve integration issues efficiently.
More about Data Warehousing Analyst jobs
What cities are hiring for Data Warehousing Analyst jobs? Cities with the most Data Warehousing Analyst job openings:
Infographic showing various Data Warehousing Analyst job openings in the United States as of June 2026, with employment types broken down into 1% Internship, 12% Full Time, 70% Part Time, and 17% Contract. Highlights an 87% Physical, 3% Hybrid, and 10% Remote job distribution, with an average salary of $82,640 per year, or $39.7 per hour.
Reporting Data Analyst

Reporting Data Analyst

Covetit

Dallas, TX • On-site

Other

Posted 4 days ago


Job description

Reporting Data Analyst

The Senior Reporting Data Analyst brings 13+ years of experience in enterprise data warehousing and reporting, with deep expertise in the Property & Casualty (P&C) insurance domain, especially Workers’ Compensation. Acts as a Subject Matter Expert (SME) on enterprise data warehouse (EDW) content and insurance source systems, ensuring accurate data interpretation, strong data lineage, and reliable, business-aligned reporting outputs.

Role Responsibilities:

  • Act as a Data & Domain SME across P&C insurance subject areas including policy, claims, billing, and financials.
  • Demonstrate deep expertise in Commercial Lines: Workers’ Compensation, General Liability, Commercial Auto, Property, Umbrella/Excess.
  • Collaborate with business stakeholders to gather, analyze, and validate reporting and data extract requirements.
  • Translate complex insurance business processes into data models, KPIs, metrics, and dimensional structures.
  • Leverage strong knowledge of Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP for accurate data interpretation and lineage.
  • Explain and map policy lifecycle events (submission, quote, bind, issue, endorsements, renewal, cancellation, reinstatement) into warehouse models.
  • Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.
  • Perform data lineage, source-to-target mapping, and transformation analysis across ETL and EDW layers.
  • Develop and validate complex SQL queries, views, and reporting datasets.
  • Ensure data reconciliation and consistency between transactional systems and enterprise warehouse.
  • Review and certify reports for accuracy, completeness, and regulatory compliance.
  • Investigate and resolve data discrepancies across source systems, ETL pipelines, and reporting layers.
  • Document data definitions, mappings, lineage, and business rules.
  • Support UAT, defect resolution, and reporting enhancements.
  • Educate stakeholders on data interpretation, reporting usage, and governance standards.

Technical Qualifications:

  • 13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
  • 10+ years working with Enterprise Data Warehousing (EDW/DWH) solutions.
  • 7+ years of experience in Property & Casualty Insurance (Commercial Lines).
  • Strong domain expertise in Workers’ Compensation and claims analytics.
  • 5+ years of experience with BI/reporting tools: MicroStrategy, Power BI.
  • Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, SAP.
  • Advanced SQL skills with extensive experience querying large-scale data warehouses.
  • Strong understanding of:
    • Data lineage and traceability
    • Source-to-target mappings
    • Dimensional modeling (facts, dimensions, aggregates)
    • Enterprise reporting architecture
    • Proven ability to reconcile data between source systems and warehouse environments.

General Qualifications:

  • Strong initiative with ability to self-manage in complex, ambiguous environments.
  • Excellent communication and stakeholder management skills.
  • Proven ability to work with senior business leaders and cross-functional teams.
  • Ability to clearly explain complex data concepts to technical and non-technical audiences.
  • Recognized as a trusted SME in Insurance Data & Data Warehousing.

Education Requirements:

  • Bachelor’s degree in Computer Science, MIS, or related field (or equivalent experience).