Data Warehouse Architect

Job Summary:

We are seeking a highly experienced and strategic data professional to serve as the authoritative steward of our enterprise customer data ecosystem. This role sits at the intersection of data architecture, product thinking, and governance — responsible for defining, owning, and evolving the canonical customer data model that underpins operational, analytical, and AI-driven capabilities across the organization. The ideal candidate brings deep technical expertise in data modeling, a strong command of data product principles, and the leadership presence to align diverse teams around a single, trusted view of the customer. This is a high-impact, high-visibility role for someone who thrives on bringing order to complexity and enabling others to build confidently on a well-governed foundation.

Responsibilities:

- Serve as the primary owner of the enterprise customer data model, including conceptual, logical, and physical representations
- Define and maintain canonical customer entities, relationships, hierarchies, and identifiers across systems
- Govern model evolution to support new business capabilities while preventing fragmentation and redundancy
- Resolve semantic conflicts across source systems and ensure consistent customer definitions enterprise-wide
- Own and oversee customer-centric data products, including curated datasets, views, and domain data assets
- Define data product contracts covering schemas, SLAs, quality rules, access patterns, and usage expectations
- Partner with engineering and analytics teams to ensure data products are production-grade, discoverable, and reusable
- Ensure customer data products are designed for analytics, reporting, and AI/ML consumption
- Ensure customer data models and products align with enterprise data platform standards, including lakehouse, catalog, and governance frameworks
- Guide ingestion, transformation, and persistence patterns to preserve model integrity and performance
- Collaborate with integration, application, and analytics architects to embed customer data consistently across solutions
- Participate in architecture governance forums, providing clear recommendations and decision rationale
- Define and enforce data quality standards, validation rules, and stewardship processes for customer data
- Partner with data governance teams on metadata, lineage, classification, and access controls
- Enable downstream teams through clear documentation, diagrams, and reference models
- Act as a subject-matter expert for customer data in design reviews and delivery engagements

Skills:

- Deep expertise in conceptual, logical, and physical data modeling, including 3NF, dimensional, and hybrid models
- Strong understanding of data product concepts, including ownership, contracts, and lifecycle management
- Experience working with modern data platforms such as lakehouse architectures, cloud data platforms, and data catalogs
- Ability to influence and align cross-functional teams without direct authority
- Familiarity with MDM, customer identity resolution, and cross-system customer harmonization
- Experience supporting AI/ML use cases through well-modeled, high-quality customer data
- Strong communication skills with the ability to explain complex models to both technical and non-technical audiences

Experience:

- 8 or more years of experience in data architecture or data modeling roles
- Proven experience owning and evolving a core enterprise domain model such as Customer, Party, or Account
- Experience in regulated or complex enterprise environments such as utilities, finance, or healthcare is preferred

Qualifications:

- Formal education or equivalent professional experience in data management, information architecture, computer science, or a related field is expected
- Relevant certifications in data management, data governance, or enterprise architecture are a plus

This is a rare opportunity to shape the data foundation that an entire enterprise builds upon, serving as the single authoritative voice for how customers are understood, represented, and activated across every system and use case. If you are energized by the challenge of bringing clarity and consistency to complex data landscapes, and you want your work to directly enable smarter analytics, more reliable operations, and trustworthy AI, this role offers the scope, visibility, and influence to make a lasting impact.

The closing date for applications for this job posting is 7/17/2026.

Should you require any accommodations in responding to this job posting or at any stage during the application process, kindly e-mail : xcelenergyprogramoffice@magnitglobal.com

Salary : $94 - $126