1

Enterprise Data Warehouse Jobs (NOW HIRING)

This role will involve gathering and analyzing business requirements, designing and managing enterprise data warehouse solutions, and developing analytics and reporting capabilities within a ...

Data Warehouse SME

Merrifield, VA · On-site

$180K - $220K/yr

Position OverviewThe Data Warehouse SME serves as the Enterprise Data Warehouse (EDW) Team Lead responsible for the design, development, optimization, and operational support of large-scale SQL ...

Bachelor's Degree Required Position Overview Seeking an experienced Data Warehouse Architect 5 to support enterprise data warehouse initiatives, with a strong focus on IBM Cloud Pak for Data (CP4D ...

Data Warehouse Developer

New York, NY · On-site

$54 - $73.75/hr

Sr Enterprise Data Warehouse Developer NYC (hybrd role) Look candidates within NY Must-haves: Data Warehousing expert Sourcing data, transforming data, star schema, landing, dimensions, data ...

Data Warehouse SME

Merrifield, VA · On-site

$180K - $220K/yr

Lead the Enterprise Data Warehouse development team. * Design, maintain, and optimize enterprise-scale SQL Server data warehouse solutions. * Develop dimensional models and enterprise reporting ...

Data Warehouse SME

Merrifield, VA · On-site

$180K - $220K/yr

Lead the Enterprise Data Warehouse development team. * Design, maintain, and optimize enterprise-scale SQL Server data warehouse solutions. * Develop dimensional models and enterprise reporting ...

Lead the Enterprise Data Warehouse development team. * Design, maintain, and optimize enterprise-scale SQL Server data warehouse solutions. * Develop dimensional models and enterprise reporting ...

Showing results 41-60

Enterprise Data Warehouse information

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.

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

Data Warehouse Analyst

Trilyon, Inc.

Tallahassee, FL • On-site

Contractor

Re-posted 15 days ago


Job description

For over 16 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. For additional information or to view all of our job opportunities, please visit our website:
https://trilyonservices.com/careers/


We are seeking a Data Warehouse Analyst to join our team. This role will involve gathering and analyzing business requirements, designing and managing enterprise data warehouse solutions, and developing analytics and reporting capabilities within a Snowflake cloud environment. The ideal candidate will have strong experience in data warehousing, ETL/ELT processes, Informatica tools, and business intelligence platforms, along with a passion for data-driven decision-making and enterprise analytics.


Job Title: Data Warehouse Analyst
Location: Tallahassee, FL (On-site)
Duration: 6 Months + Extension

Job Description:

The Data Warehouse Analyst will be responsible for designing, developing, and supporting enterprise data warehouse and analytics solutions for a large government client. This role requires close collaboration with business users, data architects, and technical teams to ensure accurate, optimized, and governed data solutions.

Key Responsibilities include:

  • Gather, analyze, and document business and reporting requirements.
  • Design and evaluate data warehouse architecture and enterprise data models.
  • Develop and support data integration solutions using Snowflake Data Cloud and Informatica IICS / PowerCenter.
  • Perform ETL/ELT development, including data extraction, transformation, loading, cleansing, replication, and validation.
  • Analyze transactional data sources and optimize warehouse models for analytics and reporting.
  • Review and validate data accuracy and completeness in the data warehouse.
  • Prototype, build, and test reports and dashboards using Power BI and Tableau.
  • Provide technical consulting and guidance to users on data usage, conflicts, and best practices.
  • Support metadata management and data governance initiatives using tools such as EDC, Axon, and CDGC.
  • Perform performance tuning for Snowflake and Informatica IICS environments.
  • Mentor and coach team members on data warehousing concepts and tools.
  • Maintain documentation, standards, and best practices for data warehousing and analytics.

Education & Experience:
  • Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
  • Minimum 7 years of IT experience with data management, data warehousing, and business intelligence solutions.
  • Strong hands-on experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration preferred.

Required Skills & Knowledge (KSAs):
  • Data warehousing and data integration expertise (ETL/ELT).
  • Snowflake Data Cloud design, administration, and performance tuning.
  • Informatica IICS, PowerCenter, Data Quality, and PowerExchange (CDC).
  • Business intelligence tools: Power BI and Tableau.
  • Enterprise data modeling and metadata management.
  • Data governance tools: EDC, Axon, CDGC.
  • Experience analyzing IBM Mainframe environments (COBOL, JCL, DB2).
  • Strong analytical, communication, and collaboration skills.

Why Join Us?
  • Trilyon, Inc. offers a comprehensive benefits package.
  • Opportunities for growth and professional development.
  • Collaborative and inclusive company culture.

Equal Employment Opportunity (EEO) Statement:

Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.

Thank you
Anjali Sharma
anjali@trilyonservices.com