Data Architect

About this role:

We are seeking an experienced Data Architect to design and implement our enterprise data architecture, with a focus on Data Warehouse/Data Lake / Data Mesh. This position offers an opportunity to shape the data foundation of our organization, working with cutting-edge technologies and solving complex data challenges in a collaborative environment.

Requirements:

• Bachelor’s degree in computer science, Information Systems, or related field; Master’s degree preferred
• 8+ years of experience in data architecture, database design, and data modelling.
• 5+ years of experience with cloud data platforms, particularly AWS data services
• 3+ years of experience architecting MPP database solutions (Redshift, Snowflake, etc.)
• Expert knowledge of data warehouse architecture and dimensional modelling
• Strong understanding of AWS data services ecosystem (Redshift, S3, Glue, DMS, Lambda)
• Experience with SQL Server and migration to cloud data platforms
• Proficiency in data modelling, entity relationship diagrams, and schema design
• Working knowledge of data integration patterns and technologies (ETL/ELT, CDC)
• Experience with one or more programming/scripting languages (Python, SQL, Shell)
• Familiarity with data lake architectures and technologies (Parquet, Delta Lake, Athena)
• Strong stakeholder management and influencing skills. Experience implementing data warehouse, data lake and data mesh architectures
• Good to have knowledge of machine learning workflows and feature engineering
• Understanding of regulatory requirements related to data (Fed Ramp, GDPR, CCPA, etc.)
• Experience with big data technologies (Spark, Hadoop).

About Aurigo

Aurigo is an AI‑native capital program management platform trusted by over 300 customers managing more than $300 billion in capital programs across North America. With over 40,000 projects delivered, Aurigo helps organisations in transportation, water and utilities, healthcare, higher education, and government plan, build, and manage infrastructure with confidence. Recognised as one of the Top 25 AI Companies of 2024 and a Great Place to Work for three consecutive years, we leverage artificial intelligence to create smarter, more connected outcomes. At Aurigo, we don’t just build software—we help shape the future of infrastructure.