ZipRecruiter

Log In

1

Data Warehousing Analyst Jobs (NOW HIRING)

Prophecy Technologies

Data Analyst

Jersey City, NJ · On-site

The ideal candidate will have strong expertise in data analysis, SQL, and data warehousing, with a focus on commercial lending systems like Loan IQ. This role offers an exciting opportunity to work ...

Kalera

Data Warehouse Engineer

Orlando, FL · On-site

... Warehousing and BI projects. * Architect and maintain data warehouses to support ease of data modeling, reporting, and analysis using dimensional model architecture (such as star schemas and OLAP ...

Kalera

Data Warehouse Engineer

Orlando, FL

... Warehousing and BI projects. * Architect and maintain data warehouses to support ease of data modeling, reporting, and analysis using dimensional model architecture (such as star schemas and OLAP ...

Purple Drive Technologies

Data Analyst

Tempe, AZ · On-site

Support data warehouse development and analytics initiatives through advanced SQL/PLSQL programming. * Document business processes, data governance standards, and integration workflows. * Partner ...

Infojini Inc

Senior Data Warehouse Analyst

Olympia, WA

$92.20K - $116.30K/yr

Senior Data Warehouse Analyst Duration: Two (2 1/2) months Location:Tumwater/ olympia, WA Client: Washington Department of Transportation Scope of Work The Washington State Department of ...

next page

Showing results 1-20

People also search for

All JobsData Warehousing Analyst Jobs

Data Warehousing Analyst information

See salary details

$34K

$82.6K

$136K

How much do data warehousing analyst jobs pay per year?

As of May 30, 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 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.

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

More about Data Warehousing Analyst jobs
What cities are hiring for Data Warehousing Analyst jobs? Cities with the most Data Warehousing Analyst job openings:
What job categories do people searching Data Warehousing Analyst jobs look for? The top searched job categories for Data Warehousing Analyst jobs are:
Data Warehousing Analyst jobs near you
Infographic showing various Data Warehousing Analyst job openings in the United States as of May 2026, with employment types broken down into 90% Full Time, and 10% Contract. Highlights an 77% Physical, and 23% Hybrid job distribution, with an average salary of $82,640 per year, or $39.7 per hour.
Data Warehouse Analyst, C. Advanced

Data Warehouse Analyst, C. Advanced

Apex Informatics

Tallahassee, FL • On-site

Other

Posted 29 days ago

Job description

Scope of Services
The resource will support cloud-based data integration initiatives by translating business needs into system and integration requirements. They will design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) capabilities-including cloud data integration-while ensuring reliable delivery of accurate, consistent, and governed data across diverse platforms such as relational databases and mainframe flat files.
They will collaborate with business stakeholders to document reporting and analytics requirements and validate that integrated data supports decision-making needs. The role also involves supporting real-time and batch data flows, conducting data modeling for cloud data warehousing, and optimizing performance and quality enforcement through modular pipeline design and orchestration. Familiarity with scripting languages and ongoing evolution in the cloud ecosystem is essential for maintaining agility and technical excellence.
Additionally, the resource will be responsible for converting legacy mainframe (JCL, COOLGEN, COBOL, FOCUS and WebFOCUS) code into modern, IDMC data integration workflows. This includes working closely with business analysts and stakeholders in analyzing existing logic, reports, and data flows to identify transformation requirements; rearchitecting them using IDMC tools; and implementing equivalent functionality within cloud-native environments. Supporting this function requires expertise in legacy data retrieval methods, report logic translation, and integration design that aligns with current best practices. Clear documentation, structured testing, and close collaboration with business and technical teams will be essential to ensure fidelity and completeness in the conversion process.
Education
Bachelor's degree in computer science, Information Systems, or other related field. Or equivalent work experience.
Experience
A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
Primary Job Duties/ Tasks
Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs
Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics
Creates designs, diagrams, and documents to support data integration and data warehouse solutions
Ensures data warehouse metadata is collected and maintained
Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
Assists with the development and maintenance of methods and practices documentation.
Job Specific Knowledge, Skills, and Abilities (KSAs)
7 Years experience in Data Warehousing and Data Integration
4 Years experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions
Extensive knowledge of data warehouse and data mart concepts
Ability to model transactional data for data warehousing usage
Knowledge of and skill in Snowflake cloud data warehouse functionality
Extensive knowledge of and expert skill in use of Informatica PowerCenter Cloud Platform
Knowledge of and skill in Informatica Data Quality functionality
Knowledge of and skill in Informatica Data Catalog functionality
Knowledge of and skill in Power BI, Tableau, and other reporting tools functionality
Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle

Apply