Data Architect

Job Summary We are seeking a seasoned Data Architect to lead the design, governance, and optimization of CADY’s enterprise data platform. This role is pivotal in consolidating legacy systems, integrating data from acquisitions, and establishing a single source of truth across operational and analytical environments. The ideal candidate will define data schemas, oversee migrations, and implement governance standards to ensure data quality, compliance, and scalability within a service-oriented architecture (SOA).

If you are interested in applying for this job, please make sure you meet the following requirements as listed below.

Responsibilities :

Design and maintain enterprise data architecture, including PostgreSQL for operational systems and AWS-based analytics pipelines (S3 / Parquet, Glue, Athena, Redshift).^Define canonical data models, schemas, indexes, and partitioning strategies to support SOA microservices.^Lead ETL / migration efforts for legacy and acquired systems, ensuring data reconciliation, mapping, and quality.^Establish and enforce data governance frameworks, including metadata management, data lineage, access control, and auditability (FERPA, COPPA, SOX).^Collaborate with DevOps and engineering teams to design event-driven data flows using patterns such as outbox, SQS, SNS, and EventBridge.^Partner with business stakeholders to translate reporting requirements into efficient data structures and pipelines.^Implement performance tuning and query optimization across databases and analytics tools.^Document data architecture, definitions, and policies to ensure long-term clarity and compliance.^Mentor engineers and analysts on data modeling, SQL best practices, and governance principles.