Manager, Data Architecture

Role overview

Workplace

• Hybrid role with in-office work and 20% flexibility to work from home.

Data platform and architecture

• Build and support data solutions, pipelines, integrations, transformations, production SQL, validation, and operational monitoring.
• Mature intake, bronze, silver, and gold layers; define quality, traceability, reconciliation, security, and promotion standards.
• Design relational, dimensional, canonical, and semantic models; establish authoritative data sources and consistent business definitions.
• Document architecture, data flows, mappings, models, and technical decisions; plan for historical data, incremental processing, and schema changes.
• Troubleshoot platform and downstream issues; improve testing, logging, error handling, restartability, and supportability.

Integrations and data products

• Build reusable enterprise integrations across applications and external sources, including NetSuite, Salesforce, Boomi, Oracle EPM, SuccessFactors, ADP, and Power BI.
• Resolve inconsistent identifiers, definitions, and business rules; ensure validation, reconciliation, monitoring, security, and supportability.
• Develop trusted data products, dimensional models, and semantic models for reporting, analytics, automation, and operations.

Platform evolution and technical leadership

• Strengthen the Azure SQL DataHub and assess phased use of Microsoft Fabric and related services.
• Establish development, testing, deployment, security, and monitoring standards; recommend changes based on value, scale, cost, and complexity.
• Enable secure AI access and help move approved AI uses from prototypes to production, with controls for sensitive information.
• Guide vendors and technical partners, review designs and deliverables, establish reusable standards, mentor internal resources, and communicate risks and trade-offs.

Qualifications

• Significant enterprise data-platform design and delivery experience, including recent hands-on production pipelines, integrations, transformations, and models.
• Advanced SQL; strong experience with Azure SQL Server or another enterprise relational platform.
• Experience with data warehouse, DataHub, lakehouse, or medallion architectures; strong relational and dimensional modelling.
• Experience with application integrations through APIs, files, integration platforms, and incremental processing.
• Experience implementing validation, reconciliation, monitoring, logging, error handling, and automated testing.
• Experience with enterprise reporting and semantic models, preferably Power BI.
• Practical experience supporting analytics, automation, or AI with governed data; production source control, deployment, and support practices.
• Able to deliver independently from requirements through support; strong technical communication and documentation.

Preferred qualifications

• Beneficial experience includes Microsoft Fabric, Azure Data Factory or Fabric Data Factory, Power BI semantic models, Boomi, Microsoft Purview, Azure Functions, or Logic Apps.
• Other beneficial experience includes Azure DevOps, GitHub, deployment automation, Python, PowerShell, C#, PySpark, AI search and agents, listed enterprise applications, master data management, or public-company control and governance.
• A bachelor's degree in computer science, engineering, information systems, data management, or a related discipline is preferred; equivalent professional experience is considered.

About Black Diamond Group