Software Architect (Data) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Advantive · 8 hours ago

Software Architect (Data)

Advantive is a company that builds careers and powers the manufacturing and distribution backbone of the global economy. They are seeking a highly skilled Data Architect to design and lead the evolution of their unified data platform, enabling product teams and AI services to access high-quality data. The role involves designing data pipelines, governance models, and collaborating with architecture teams to facilitate analytics and API-driven insights.

Enterprise Resource Planning (ERP)SaaSSoftware
check
H1B Sponsor Likelynote

Responsibilities

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
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
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
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

Qualification

Data Platform ArchitectureIntegration DesignAzure Data ServicesAPI EnablementModeling & AnalyticsGovernance & ComplianceSQLPower BIData Security KnowledgeInfrastructure as CodeCollaborationCommunication Skills

Required

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

Company

Advantive

twittertwittertwitter
company-logo
Advantive provides software solutions for specialty manufacturers and wholesale distributors.

H1B Sponsorship

Advantive has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)

Funding

Current Stage
Growth Stage
Total Funding
unknown
2023-09-13Private Equity

Leadership Team

leader-logo
Benoit de la Tour
Chief Executive Officer
linkedin
leader-logo
Andries Hanekom
Chief Technology Officer
linkedin
Company data provided by crunchbase