Data Architect (N)

3+ years of experience building and supporting production data pipelines in a Data Warehouse environment Deep understanding of Data Warehouse modeling (facts/dimensions, SCD Type 2, relational modeling, and performance tuning) Strong experience with AWS data services (S3, IAM, Lambda, Glue, Athena, Redshift, RDS/DMS, Kinesis, Step Functions, CloudWatch) Proficiency in SQL Strong understanding of analytical and relational database concepts Knowledge of modern storage formats and patterns (delta tables, data lakes) Proficiency in at least one programming language used for data engineering (Python preferred) Practical knowledge of batch, streaming, and CDC integration patterns Comfort with Git-based workflows, automated deployments, and CI/CD Experience building monitoring and observability for pipelines

Design and implement end-to-end data integrations Evaluate and recommend tooling, frameworks, and platforms Set up, build, and maintain ELT/ETL pipelines primarily using AWS services Develop ingestion patterns for structured and semi-structured data Create and manage data models, staging layers, and integration structures Implement orchestration, scheduling, retries, and error handling Partner with stakeholders to define data requirements, SLAs, and integration contracts Design and implement monitoring, alerting, and observability Apply data governance practices Support CI/CD pipelines for data workloads Troubleshoot production issues and drive root-cause analyses