Description

You will own the data modeling strategy, design, and documentation for high-volume data warehouses and analytics platforms.

This role is on-site.

Responsibilities

• Design and enforce data models, naming standards, and lineage using ER Studio.
• Develop current and target state data integration models, flows, and transformation logic to reduce redundancy.
• Reverse and forward engineer legacy business data models to support advanced analytics.
• Partner with Business Intelligence teams to define end-state reporting goals and dashboard requirements.
• Document business rules and communicate technical design decisions to IT and business stakeholders.

Required Skills

• 12+ years of experience in data modeling, database design, and data architecture.
• Expert understanding of Data Warehouse design for high-volume processing and performance.
• Proficiency with ER Studio for data lineage and modeling.
• Hands-on experience with Informatica toolsets, specifically Data Archive and EDC.
• Strong background with Oracle databases.
• Knowledge of Business Intelligence tools such as SAS, Tableau, or Microsoft PowerBI.
• Ability to document and present technical specifications to non-technical audiences.

Preferred Skills

• DAMA Data certifications.
• Experience in the Travel and Hospitality industry.

Key Skills

Education

Master’s degree