1

Enterprise Data Warehouse Jobs (NOW HIRING)

next page

Showing results 1-20

Enterprise Data Warehouse information

What is an enterprise data warehouse?

An Enterprise Data Warehouse (EDW) is a centralized repository that stores integrated data from multiple sources across an organization. It enables businesses to consolidate, manage, and analyze large volumes of data for reporting, business intelligence, and decision-making. EDWs are designed to support queries and analysis while ensuring data consistency and quality. They play a crucial role in helping organizations gain insights from their data and improve overall efficiency.

What are the key skills and qualifications needed to thrive as an enterprise data warehouse professional?

To thrive as an Enterprise Data Warehouse professional, you need expertise in data modeling, SQL, ETL processes, and a strong understanding of database concepts, often supported by a degree in computer science or a related field. Familiarity with tools such as Informatica, Microsoft SQL Server, Oracle, or cloud-based platforms like AWS Redshift and certifications in relevant technologies are highly beneficial. Analytical thinking, problem-solving, and effective communication are valuable soft skills for collaborating with stakeholders and addressing complex data needs. These skills are crucial for ensuring data integrity, optimizing data flow, and supporting informed business decisions through reliable data solutions.

What are some common challenges faced by professionals working in enterprise data warehouse roles?

Professionals in Enterprise Data Warehouse roles often encounter challenges such as ensuring data quality and consistency across multiple sources, managing large volumes of data efficiently, and adapting to evolving business requirements. Collaboration with cross-functional teams—including business analysts, data scientists, and IT staff—is essential to gather requirements and deliver accurate, timely insights. Additionally, staying updated with new technologies and best practices in data integration, storage, and security is crucial for long-term success and growth in this field.

What is the difference between Enterprise Data Warehouse vs Data Analyst?

AspectEnterprise Data WarehouseData Analyst
CredentialsTypically requires a degree in Computer Science, Data Management, or related fields; certifications like CDMP or DAMA are commonUsually holds a degree in Statistics, Business, or related fields; certifications like Microsoft Data Analyst or Tableau are beneficial
Work EnvironmentWorks with large-scale data systems, databases, and ETL processes within organizationsAnalyzes data sets, creates reports, and visualizations to support business decisions
Industry UsageUsed across industries for centralized data storage and managementUsed across industries for data analysis and reporting

The main difference is that an Enterprise Data Warehouse focuses on building and maintaining large data storage systems, while a Data Analyst interprets data to generate insights. Both roles require strong analytical skills, but their responsibilities and tools differ significantly.

More about Enterprise Data Warehouse jobs
Infographic showing various Enterprise Data Warehouse job openings in the United States as of August 2026, with employment types broken down into 1% As Needed, 84% Full Time, 11% Part Time, and 4% Contract. Highlights an 86% Physical, 4% Hybrid, and 10% Remote job distribution.

Enterprise Data Warehouse Analyst

Apex Informatics

Tallahassee, FL • On-site

Other

Re-posted 18 days ago


Job description

Title: Enterprise Data Warehouse Analyst
Location: Tallahassee, FL
Job Description:
Key Responsibilities
  • Support cloud-based data integration initiatives by translating business needs into system and integration requirements.
  • Design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC), including cloud data integration.
  • Ensure reliable delivery of accurate, consistent, and governed data across relational databases and mainframe flat files.
  • Collaborate with business stakeholders to document reporting and analytics requirements.
  • Validate that integrated data supports decision-making needs.
  • Support real-time and batch data flows.
  • Conduct data modeling for cloud data warehousing.
  • Optimize performance and data quality enforcement through modular pipeline design and orchestration.
  • Convert legacy mainframe code (JCL, COOLGEN, COBOL, FOCUS, WebFOCUS) into modern IDMC data integration workflows.
  • Analyze existing legacy logic, reports, and data flows to identify transformation requirements.
  • Rearchitect legacy processes using IDMC tools and implement equivalent cloud-native functionality.
  • Apply expertise in legacy data retrieval, report logic translation, and integration design aligned with best practices.
  • Produce clear documentation, structured testing, and collaborate closely with business and technical teams to ensure fidelity and completeness of conversions.
  • Prototype, build, and test ETL/ELT jobs.
  • Analyze transactional data stores and develop data warehouse models optimized for reporting and analytics.
  • Create designs, diagrams, and documentation supporting data integration and warehouse solutions.
  • Ensure data warehouse metadata is collected and maintained.
  • Coach and mentor peers in data warehousing concepts and tool usage.
  • Assist in development and maintenance of methods and practices documentation.

Required Qualifications
  • Minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.

Work Environment
  • Onsite work at the reporting location, Monday-Friday, during business hours.
  • Flexibility to work hours between 7:00 AM & 7:00 PM and/or Saturdays, on rotation or as part of an on-call schedule.
  • Occasional remote work may be approved at the discretion of the hiring manager.

Education / Experience
  • Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.