Associate Director, Data Warehouse Strategy

Princeton University

Princeton (NJ)

Hybrid

USD 140,000 - 157,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Princeton University is seeking an Associate Director to lead the Advancement Data Warehouse strategy and development. You will manage a Data Systems Engineer and translate business requirements into scalable ETL solutions, metadata rules, and documentation.

The role emphasizes collaboration with analysts and stakeholders to ensure accurate reporting definitions, data quality, and governance across enterprise analytics initiatives.

Qualifications

  • Bachelor’s degree required.
  • 5+ years of related work experience.
  • Strong experience designing relational and multi-dimensional models.
  • Good analysis and problem-solving skills to understand business information requirements and resolve data quality issues in BI solutions.
  • Experience performing data selection and SQL development using PL/SQL and Oracle Stored Procedures.
  • Strong understanding of data architecture for BI reporting tools (Cognos, MS Reporting, Tableau preferred).
  • Experience developing solutions using Excel and MS Access.
  • Experience with PowerPoint and Word.
  • Familiarity with project management.
  • Strong customer service orientation.
  • Ability to work independently and in teams; professional and collaborative demeanor.

Responsibilities

  • Lead the design, implementation, and ongoing enhancement of the Advancement Data Warehouse platform.
  • Develop and maintain data models supporting reporting and analytics.
  • Design and oversee ELT pipelines that ingest and transform data.
  • Establish standards for data modeling, business rules, and warehouse development practices.
  • Lead development of curated reporting structures balancing usability and performance.
  • Maintain documentation and data lineage for warehouse assets.
  • Partner with reporting analysts and stakeholders to translate needs into scalable warehouse solutions.
  • Serve as primary technical authority on reporting data structures and warehouse design.
  • Collaborate to ensure reporting reflects institutional definitions and requirements.
  • Support enterprise reporting initiatives with trusted data assets.
  • Guide users in effective use of warehouse data.

Skills

Relational data modeling
Dimensional modeling
SQL development
ELT/ETL design
Data governance
Data quality
Communication & collaboration
Project management

Education

Bachelor’s degree

Tools

Cognos
MS Reporting
Tableau
Excel
MS Access

Job description

Princeton University is seeking an Associate Director to lead the Advancement Data Warehouse strategy and development. You will manage a Data Systems Engineer and translate business requirements into scalable ETL solutions, metadata rules, and documentation.

The role emphasizes collaboration with analysts and stakeholders to ensure accurate reporting definitions, data quality, and governance across enterprise analytics initiatives.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Governance Director - Data Quality & Stewardship
Data Governance Director - Data Quality & Stewardship

Princeton University • Princeton (NJ)

Hybrid
USD 152,000 - 170,000
Associate Director, Assessment & Data Strategy
Associate Director, Assessment & Data Strategy

Princeton University • Princeton (NJ)

On-site
USD 95,000 - 115,000
Associate Director, Data Management
Associate Director, Data Management

Princeton University • Princeton (NJ)

Hybrid
USD 140,000 - 157,000
Senior Data Warehouse Architect & Analytics Lead
Senior Data Warehouse Architect & Analytics Lead

Northern Virginia Community College • Annandale (VA)

On-site
USD 105,000 - 125,000
Director of Enterprise Data Strategy & Governance
Director of Enterprise Data Strategy & Governance

University at Buffalo • Buffalo (NY)

On-site
USD 150,000 - 190,000
Data Strategy & Analytics Lead (Hybrid)
Data Strategy & Analytics Lead (Hybrid)

New York University • New York (NY)

Hybrid
USD 100,000 - 120,000
Data Governance & Analytics Leader
Data Governance & Analytics Leader

University of Missouri-Saint Louis • St. Louis (MO)

On-site
USD 61,000 - 78,000
Senior BI & Analytics Lead - Data Strategy (Hybrid)
Senior BI & Analytics Lead - Data Strategy (Hybrid)

University of Virginia • Charlottesville (VA)

Hybrid
USD 90,000 - 95,000
Director of Data Strategy & BI Excellence
Director of Data Strategy & BI Excellence

Oracle • Nashville (TN)

On-site
USD 180,000 - 240,000
Cloud Data Warehouse Architect (OCI/ADW)
Cloud Data Warehouse Architect (OCI/ADW)

Rutgers • New Jersey

Hybrid
USD 122,000 - 176,000
Medical, prescription drug, and dental
Paid vacation and holidays
Retirement benefits
+3