About this role
Senior enterprise data architect role focused on defining and governing the canonical data model and architectural standards for the firm's data platform, integrating Workday and Dynamics 365 data into enterprise data blueprints and enabling analytics with Power BI and other downstream tools.
Key Responsibilities
- Produce and maintain enterprise data models
- Own canonical data model
- Architect silver/gold layers
- ADRs & reference patterns
- Partner with governance and security
Technical Overview
Leads data modeling and architectural governance across enterprise data platforms with Databricks lakehouse and Microsoft Fabric, integrating sources like Workday and Dynamics 365/Dataverse, producing ERDs, conformed entities, and gold/silver data layers for analytics via Power BI and APIs.
Ideal Candidate
The ideal candidate is a senior data architect with 8+ years in data architecture, enterprise data modeling, and governance. They should have hands-on experience with Kimball dimensional modeling, medallion architecture, and modern data platforms (Databricks lakehouse, Microsoft Fabric) and be comfortable guiding governance across Workday and Dynamics 365 ERP/CRM systems.
Must-Have Skills
Bachelor's Degree in Computer ScienceInformation SystemsData Engineeringor related field8+ years data architecturedata engineeringor enterprise data modelingHands-on Kimball-style dimensional modelingmedallion architectureand semantic layer designExperience in professional servicesfinancial servicesor similarly complex industriesExperience establishing architectural governance practices including design reviewsarchitecture decision recordsand standards documentation
Nice-to-Have Skills
Master’s Degree in technical or business disciplineWorkday as a source system (HCMPSAand/or Financials modules)CDMP — Certified Data Management Professional (DAMA International)Microsoft Certified: Azure Data Engineer AssociateDatabricks Certified Data EngineerMicrosoft Certified: Fabric Analytics Engineer Associate
Tools & Platforms
DatabricksMicrosoft FabricWorkdayDynamics 365DataversePower BI
Required Skills
Bachelor's Degree in Computer ScienceInformation SystemsData Engineeringor related field; 8+ years data architecturedata engineeringor enterprise data modeling; Kimball dimensional modeling; medallion architecture; data governance; Workday; Dynamics 365; Dataverse; Power BI; Databricks lakehouse; APIs; ADRs; architecture governance; data quality; data lineage
Hard Skills
Kimball dimensional modelingDimensional modelingMedallion architectureData governanceData qualityData lineageERD (Entity Relationship Diagram)Silver layer / Gold layer conceptsDatabricks lakehouseMicrosoft FabricWorkdayDynamics 365DataversePower BIAPIs
Soft Skills
Stakeholder collaborationCommunicationProblem-solvingAttention to detailDocumentation
Certifications
Preferred
CDMP — Certified Data Management Professional (DAMA International)Microsoft Certified: Azure Data Engineer AssociateDatabricks Certified Data EngineerMicrosoft Certified: Fabric Analytics Engineer Associate
Keywords for Your Resume
enterprise data architectdata architecturedata modelingkimballdimensional modelingmedallion architecturedata lakehousedatabricks lakehousemicrosoft fabricworkdaydynamics 365dataversepower bier diagramarchitecture decision recordsADRdata governancedata qualitydata lineagedata contractsslassource-of-truthAPIsDatabricks lakehousePower BIWorkdayDynamics 365 AdminKimball dimensional modelingMedallion architectureData governanceData modelingERDArchitecture decision records
Deal Breakers
Less than 8 years of data architecture/enterprise data modeling experience, No Bachelor's degree in a relevant field, Lack of experience with Kimball-style modeling or medallion architecture, No experience in governance practices
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile