Remote Enterprise Data Architect - Unified Analytics Platform

Cordance; United States; On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401K Plan (US)

Paid Time Off

Parental Leave

Remote Work Stipend

Job summary

Cordance is seeking a Data Architect to define and lead the enterprise data architecture across Cordance Commerce, unifying reporting, data models, and analytics for Solutions, Secure Retail, Upright, and Pearl Dive. This hands-on leader will transform fragmented data into a scalable, governed data platform and partner with DBAs, BI, and engineering teams.

Responsibilities include creating a phased migration strategy, establishing data governance, and enabling trusted cross-product dashboards

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Data Management, or a related field, or equivalent practical experience.
• 8+ years of experience in data engineering, database architecture, analytics engineering, or business intelligence, including 3+ years in a data architecture or senior technical leadership role.
• Demonstrated experience designing enterprise data warehouses, lakehouses, or analytical platforms and migrating data from multiple operational systems.
• Strong data-modeling expertise across conceptual, logical, and physical models, including dimensional modeling and normalized transactional designs.
• Hands-on proficiency with SQL, relational databases, ETL/ELT patterns, orchestration, data quality, metadata, lineage, and BI semantic models.
• Experience separating reporting workloads from high-volume transactional systems and designing for performance, resilience, scalability, and cost control.
• Experience with cloud data platforms and modern data integration patterns, including APIs, replication, and change data capture.
• Strong written and verbal communication skills, including the ability to present architecture decisions and tradeoffs to technical and non-technical audiences.

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.

Skills

Data modeling

SQL

ETL/ELT

Cloud data platforms

Data governance

API integration

Change data capture

PostgreSQL

Microsoft SQL

Analytics engineering

Education

Bachelor's degree or higher in CS/IS/Engineering/Data Management

Tools

Snowflake

PostgreSQL

Microsoft SQL Server

Job description

Cordance is seeking a Data Architect to define and lead the enterprise data architecture across Cordance Commerce, unifying reporting, data models, and analytics for Solutions, Secure Retail, Upright, and Pearl Dive. This hands-on leader will transform fragmented data into a scalable, governed data platform and partner with DBAs, BI, and engineering teams.

Responsibilities include creating a phased migration strategy, establishing data governance, and enabling trusted cross-product dashboards