Senior Enterprise Data Architect Snowflake / Python

Senior Enterprise Data Architect – Snowflake / Python
Location: Philadelphia, PA (Onsite/Hybrid)
Employment Type: Contract

Job Description

We are seeking an experienced Senior Enterprise Data Architect with strong expertise in Snowflake, advanced Python development, and enterprise dimensional data modeling. The ideal candidate will lead enterprise data warehouse modernization initiatives, establish data modeling standards, and design scalable analytics architectures supporting enterprise reporting and business intelligence.

This role requires a hands-on technical leader who can drive architectural decisions while collaborating with business stakeholders, data engineers, and analytics teams.

Responsibilities

Enterprise Data Architecture & Modeling

• Lead the redesign and modernization of enterprise dimensional data warehouse environments using Kimball and star schema methodologies.
• Define enterprise standards for dimensional modeling, semantic consistency, certified datasets, and reusable reporting structures.
• Create and maintain conceptual, logical, and physical data models aligned with enterprise reporting and analytics requirements.
• Design scalable enterprise data architectures supporting executive dashboards, operational reporting, and self-service BI.
• Establish governance standards for curated and trusted enterprise data products.

Enterprise Analytics & Data Engineering

• Architect and oversee scalable Snowflake-based data solutions and transformation frameworks.
• Develop and guide Python-based data engineering standards and reusable transformation patterns.
• Support the development of curated and certified enterprise datasets powering analytics and dashboard initiatives.
• Ensure data structures are optimized for enterprise BI tools and analytics consumption.
• Partner with analytics teams to align KPI definitions, reporting logic, and semantic models.

Strategy, Governance & Leadership

• Collaborate with business stakeholders, analytics teams, and technical leadership to translate business requirements into scalable enterprise data solutions.
• Drive enterprise data governance, lineage, quality, and reporting consistency initiatives.
• Provide technical leadership and mentorship to data engineers and data modelers.
• Lead roadmap planning and modernization efforts for enterprise analytics platforms and reporting environments.
• Identify opportunities to improve scalability, maintainability, and operational efficiency across the analytics ecosystem.

Required Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 8+ years of experience in enterprise data architecture, analytics engineering, or data warehousing.
• Proven experience designing and modernizing dimensional data warehouse environments.

Mandatory Technical Skills

• Snowflake: Strong hands-on expertise in Snowflake architecture and development.
• Python: Advanced Python development experience.
• Dimensional Data Modeling: Deep expertise in Kimball methodology and star schema design.
• Enterprise Analytics: Experience with enterprise dashboarding and certified data products.
• SQL: Strong SQL development and query optimization skills.
• Experience designing curated reporting layers and semantic models.
• Experience supporting enterprise BI tools such as Tableau or Power BI.

Preferred Skills

• Experience with AWS cloud environments.
• Experience with Databricks or distributed processing frameworks.

Key Competencies

• Strong architectural and systems-thinking mindset.
• Ability to balance strategic architecture with hands-on execution.
• Excellent communication and stakeholder management skills.
• Strong analytical and problem-solving abilities.
• Experience working in complex enterprise analytics environments.
• Ability to drive alignment across technical and business teams.

Work Location

Philadelphia, PA — Onsite/Hybrid.