Data Architect

Caylent

8h•Remote

About The Position

Caylent is a cloud native services company that helps organizations bring the best out of their people and technology using Amazon Web Services (AWS). We provide a full-range of AWS services including workload migrations and modernization, cloud native application development, DevOps, data engineering, security and compliance, and everything in between. At Caylent, our people always come first. We are a global company and operate fully remote with employees in Canada, the United States, and Latin America. We celebrate the culture of each of our team members and foster a community of technological curiosity. Come talk to us to learn more about what it means to be a Caylien! We are seeking an exceptional Data Architect to join our growing Cloud Data Engineering team. The right candidate is someone who has deep expertise in data architecture | ML system design and is passionate about working with our customers, partners, and colleagues to drive innovation forward. Your mission will be to work alongside Caylent’s Engineers, Engineering Managers, and Project Managers to deliver AWS solutions across our diverse and forward-thinking customer base. You’ll work with the latest technologies and support customers looking to bring cutting-edge ideas to market. You will be a mission control specialist, guiding Cayliens and Customers alike through Agile ceremonies like stand-ups, retrospectives, and more. You will translate customer requirements and into a workable backlog of tickets for engineers. Delegate tickets to a team of engineers in order to complete customer projects. Lead requirements gathering, backlog grooming, and architecture discussions. Apply your understanding of DevOps pipelines, including build automation, branching strategies, CI/CD, Infrastructure as Code, security, monitoring, logging, and alerting. Troubleshoot and resolve issues in customer dev, test, and production environments. Automate software testing at multiple levels (component, configuration item, subsystem, system) and monitor results. Write production quality code, including unit and integration tests. Work with a team to deliver top-quality cloud native applications on AWS for customers. Clearly communicate and document your designs, processes, and procedures. You will demonstrate a passion to Stay Curious as you mentor peers, tackle new technologies, and learn from our word-class team of engineers. Coach and mentor less experienced teammates, coach and be mentored by world class engineers.

Requirements

Solid experience leading and managing multi-database migration projects (on-prem/cloud, cross-RDBMS) with minimal downtime and risk.
Expert in designing OLTP and OLAP systems including normalization, indexing, and concurrency, and ER modeling and dimensional design.
In-depth knowledge of at least two major RDBMS platforms (PostgreSQL, MySQL, SQL Server, Oracle).
Solid advanced knowledge in HA/DR, cost-control patterns, and databases security.
Advanced experience in performance analysis, query optimization, execution plan analysis, and troubleshooting complex database issues.
Solid experience architecting RDS, Aurora, and EC2-hosted databases within the broader AWS ecosystem.
Skilled designing architecture diagrams, technical documentation, runbooks, and migration playbooks.
Proficiency in Python scripting and automation for workloads.
Experience with IaC, CI/CD, security and FinOps.
6+ years RDBMS architecture experience.
3+ years of AWS architecture experience.
Advanced English (minimum C1).