Enterprise Architect

Wipfli Advisory LLC

3d • Remote

About The Position

At Wipfli, people count. At Wipfli, our people are core to everything we do—the catalyst behind our ability to create exceptional impact and extraordinary results. We believe in flexibility. We focus on relationships. We encourage each individual to follow their own path. People truly matter and they feel it. For those looking to make a difference and find a professional home, Wipfli offers a career-defining opportunity.
Under the direction of Chief Data & Analytics Officer, the Enterprise Data Architect is a technical leader responsible for defining, documenting, and governing the canonical data model and architectural standards that enable the firm’s enterprise data platform to deliver trusted, consistent data across its Practice, Growth, and Functional segments. Thiis role produces and maintains enterprise data blueprints—including entity relationship models, dimensional schemas, and source-of-truth definitions—that guide the development of high-quality data products.

Requirements

• Bachelors Degree in Computer Science, Information Systems, Data Engineering, or related field.
• 8+ years of progressive experience in data architecture, data engineering, or enterprise data modeling roles, with a minimum of 3 years in a senior or lead architect capacity.
• Hands-on background in Kimball-style dimensional modeling, medallion architecture patterns, and semantic layer design at enterprise scale.
• Proven experience in professional services, financial services, or similarly complex industries where production, utilization, WIP, and engagement-based financial models are core business concepts.
• Experience establishing architectural governance practices including design reviews, architecture decision records, and standards documentation.

Nice To Haves

• Master’s Degree in technical or business discipline preferred; equivalent professional experience considered.
• Experience with Workday as a source system (HCM, PSA, and/or Financials modules) is a significant advantage.
• CDMP — Certified Data Management Professional (DAMA International).
• Microsoft Certified: Azure Data Engineer Associate or Databricks Certified Data Engineer.
• Microsoft Certified: Fabric Analytics Engineer Associate.

Responsibilities

• Produce and maintain enterprise data modeling artifacts including ERDs, attribute-level source-of-truth mappings, grain definitions, and relationship documentation to enable consistent implementation across teams
• Own and evolve the firm’s canonical (enterprise) data model by defining conformed entities (e.g., Account, Worker, Project/Engagement, Client) and ensuring consistent interpretation across Practice, Growth, and Functional domains
• Architect and govern the Silver layer canonical model within a Databricks lakehouse / Microsoft Fabric environment, conforming data from Workday, Dynamics 365, and other sources into matched/merged/mastered enterprise entities
• Design and maintain Gold layer dimensional models (facts, dimensions, measures, hierarchies, and grain) across core subject areas such as revenue, workforce, pipeline, billing, and financial performance to support analytics and self-service consumption
• Perform architectural design reviews and approvals for new or modified data models introduced by any team, validating adherence to enterprise standards, cross-domain compatibility, and downstream usability (semantic models, Power BI, APIs)
• Translate business requirements into implementable architecture specifications by partnering with CDAO and Product Managers to convert needs into model blueprints, gold-layer design requirements, and development-ready documentation for engineering teams
• Maintain architecture decision records (ADRs) and reference patterns to document architectural choices, provide rationale, and accelerate consistent, repeatable delivery of governed data products
• Partner with Data Governance and Security stakeholders to align canonical definitions, data quality rules, lineage capture, data classification, access control architecture, and masking patterns—ensuring data is audit-ready and trusted
• Define platform integration and data contract expectations by specifying ingestion and interoperability patterns for upstream systems (Workday, Dynamics 365/Dataverse) and downstream consumers (Fabric semantic models, Power BI, operational interfaces), including SLAs for data freshness, quality, and availability

Benefits

• 8 health plan options (both HMO & PPO plans), dental and vision coverage, opportunity to enroll in HSA with potential Firm contribution and an Employee Assistance Program
• Firm-sponsored basic life and short and long-term disability coverage, a 401(k) savings plan & profit share as well as Firm matching contribution, well-being incentive, education & certification assistance, flexible time off, family care leave, parental leave, family formation benefits, cell phone reimbursement, and travel rewards
• Voluntary benefit offerings include critical illness & accident insurance, hospital indemnity insurance, legal, long-term care, pet insurance, ID theft protection, and supplemental life/AD&D

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees