Data Architect

Description:

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 revolutionizing how the world plans, builds, and manages infrastructure projects with Masterworks, our industry-leading enterprise SaaS platform. Trusted by over 300 customers managing $300 billion in capital programs, Masterworks is setting new standards for project delivery and asset management. Recognized as one of the Top 25 AI Companies of 2024 and a Great Place to Work for three consecutive years, we are leveraging artificial intelligence to create a smarter, more connected future for customers in transportation, water and utilities, healthcare, higher education, and the government, with over 40,000 projects across North America. 

At Aurigo, we don’t just develop software—we shape the future. If you’re excited to join a fast-growing company and collaborate with some of the brightest minds in the industry to solve real-world challenges, let’s connect.

Competencies