Data Architect

We're seeking a highly skilled Data Architect to design and lead the evolution of Advantive's unified data platform. This role defines the architectural foundation that enables product teams, customers, and AI services to access consistent, secure, and high-quality data across the Advantive ecosystem.

The Data Architect will design data pipelines, integration frameworks, and governance models that connect on-prem and SaaS products into a centralized data lake and warehouse. In collaboration with our architecture team, this role will be instrumental in enabling self-service analytics, customer-facing APIs, and AI-powered insights.

If you're passionate about data architecture, API-driven design, and building enterprise-scale analytics platforms, this is an opportunity to define how Advantive's customers unlock the value of their operational data.

Responsibilities

Architecture and Design

• Lead the design of the data platform - a unified data platform integrating data from multiple Advantive products and customer environments.

• Architect data ingestion, transformation, and delivery pipelines using cloud-native services

• Define and maintain the enterprise data model supporting analytics, APIs, and AI use cases.

• Develop standards for data quality, lineage, versioning, and change tracking

• Design the data warehouse schema, optimized for performance, scalability, and multi-tenancy.

• Implement APIs and query endpoints to expose clean, secure datasets for customers and internal AI agents.

• Partner with the Cloud Architect on hybrid data exchange - ensuring on-prem connectors, synchronization, and resilience during outages.

Integration and Delivery

• Define data ingestion patterns including direct database connections, API-based integration, and flat-file ingestion.

• Manage the configuration and orchestration of data pipelines and Power BI datasets.

• Design data lake storage strategies to support efficient querying and cost-effective storage.

• Establish data mapping, transformation, and validation processes for newly acquired products joining the platform.

• Enable real-time or near-real-time data streaming where appropriate for operational insights.

Data Governance and Access

• Define and enforce data governance standards across all platform components.

• Implement role-based and row-level security (RLS) to ensure client isolation and compliance with data-sharing agreements.

• Collaborate with legal and compliance teams to enforce regional data privacy, retention, and restricted-client rules.

• Own the metadata catalog, data dictionary, and business glossary.

• Partner with analytics and AI teams to ensure consistent and compliant access to data for model training and inference.

Collaboration and Leadership

• Work closely with Product, AI, and Architecture teams to ensure alignment on shared data models and services.

• Provide technical leadership to developers and data engineers implementing data pipelines and integrations.

• Communicate architecture decisions through documentation, diagrams, and presentations to technical and non-technical audiences.

• Mentor engineers and promote data literacy across the organization.

• Data Platform Architecture - Demonstrated expertise in designing large-scale, secure, and performant data platforms.

• Integration Design - Skilled in designing and managing ingestion from multiple sources using APIs, flat files, and database connectors.

• Modeling & Analytics - Strong understanding of star/snowflake schema design, dimensional modeling, and query optimization.

• Governance & Compliance - Deep knowledge of access control, data lineage, and privacy frameworks (SOC 2, ISO 27001, GDPR).

• Azure Data Services - Hands-on experience with cloud-based data services (e.g. Azure Data Factory, Synapse, Delta Lake, Databricks, and Azure SQL).

• API Enablement - Ability to define and expose data through secure REST and GraphQL APIs.

• Collaboration - Works effectively across teams to deliver cohesive, business-aligned data solutions.

Requirements

• Bachelor's degree in Computer Science, Data Engineering, or related field.

• 7+ years of experience in data architecture, engineering, or BI development.

• Proven expertise with cloud data technologies (e.g. Data Factory, Synapse, Delta Lake, Databricks).

• Strong command of SQL and experience with data modeling tools.

• Knowledge of Power BI, data visualization, and semantic modeling.

• Experience integrating diverse data sources from cloud and on-prem applications.

• Familiarity with Infrastructure as Code (e.g. Terraform) for data infrastructure automation.

• Strong understanding of data security and compliance frameworks.

• Excellent written and verbal communication skills.