Data Architect

Cordance is dedicated to accelerating the growth of vertically focused business-to-business (B2B) software-as-a-service (SaaS) companies through acquisition and long-term tactical and financial guidance. We’re experienced operators and subject-matter experts with a passion for software and building businesses. We partner with founders to help them scale their businesses and realize their companies’ full potential.

We look for businesses with strong leadership and high potential for profitable growth, and work together to increase year-over-year revenue, company efficiency, and impact. Cordance envisions that all companies we work with achieve their full potential. We embrace what makes each company great and build on those foundations. We believe in elevating a company as it scales, delivering dignity to the organization and its employees, and sharing a passion for building a legacy.

Position Overview

The Data Architect will define and lead the enterprise data architecture for Cordance Commerce, with primary responsibility for unifying reporting platforms, data models, and analytics capabilities across Solutions, Secure Retail, Upright, and Pearl Dive. This is a hands-on technical leadership role for someone who can turn fragmented operational data and customer-specific reporting into a scalable, governed, and reliable data platform.

The role partners closely with Database Administrators, Business Intelligence professionals, Engineering, Product, Finance, Customer Success, and business leaders. The Data Architect will establish a practical migration strategy that separates analytical workloads from transactional systems, protects product performance, preserves critical customer reporting, and enables a trusted source of data across the portfolio.

Key Responsibilities

Own the target-state data architecture and roadmap for a unified reporting and analytics platform across Cordance Commerce products.

Assess current transactional databases, data pipelines, reporting tools, standard BI reports, and customer-specific reports; document dependencies, duplication, performance risks, and migration constraints.

Define a shared enterprise data model, canonical business definitions, master-data strategy, and system-of-record ownership for core entities such as customer, item, store, employee, transaction, inventory, donation, processing, and e-commerce activity.

Design the separation of transactional and analytical workloads using fit-for-purpose patterns such as a cloud data warehouse or lakehouse; evaluate platforms including Snowflake and recommend the appropriate solution based on scale, security, cost, operability, and business needs.

Create the phased migration strategy for consolidating reporting from Solutions, Secure Retail, Upright, and Pearl Dive while maintaining business continuity and customer commitments.

Develop patterns and standards for data ingestion, transformation, orchestration, semantic models, APIs, data quality, lineage, metadata, retention, archival, and observability.

Partner with BI professionals to rationalize the Solutions standard report catalog and reduce the support burden created by hundreds of Secure Retail customer-specific reports through reusable datasets, governed self-service analytics, and configurable reporting patterns.

Guide DBAs and engineering teams on database architecture, PostgreSQL and Microsoft SQL modernization, replication or change-data-capture patterns, performance isolation, backup, recovery, and operational readiness.

Establish data governance practices covering data ownership, access controls, privacy, security, auditability, quality thresholds, and change management.

Lead technical discovery, architecture reviews, proofs of concept, and vendor evaluations; translate findings into actionable designs, sequencing, estimates, risks, and investment recommendations.

Provide hands-on technical guidance to delivery teams, review implementation designs, and ensure new product capabilities align with the target architecture instead of creating additional data silos.

Enable trusted enterprise dashboards and cross-product reporting that support operational, customer, financial, and executive decision-making.

Competencies:

Enterprise Data Architecture: Converts complex, fragmented data estates into pragmatic target-state architectures and phased roadmaps.

Technical Depth: Designs modern warehouses or lakehouses, dimensional and relational models, pipelines, semantic layers, and reporting platforms.

Business Translation: Connects architecture decisions to customer value, product performance, operational efficiency, and measurable business outcomes.

Data Governance: Establishes clear ownership, definitions, lineage, quality, security, and lifecycle controls without creating unnecessary bureaucracy.

Migration Leadership: Plans incremental transitions that protect customer reporting and production stability while retiring duplication and technical debt.