Data Architect | AI-Powered Enterprise SaaS & Infrastructure Tech | AWS, Redshift, Snowflake, Data Warehouse, Data Lake, Python, ETL

About the Company

Top 25 AI Company of 2024 and a 3x Great Place to Work – this is cloud-native, AI-powered SaaS that literally helps build the world. With $450B+ in capital programs under management, 300+ customers, and 40,000+ projects across transportation, healthcare, utilities, and government – this isn’t just fast growth, it’s reshaping how infrastructure gets built. For those who want their work to have real-world impact at a massive scale, this is the arena.

A seasoned Data Architect is needed to design and lead an enterprise data foundation – spanning Data Warehouse, Data Lake, and Data Mesh – using cutting-edge cloud technologies. The role solves complex, large-scale data challenges that directly power AI and ML capabilities used by governments and enterprises across North America.

What You’ll Do

• Architect and implement enterprise-grade Data Warehouse / Data Lake / Data Mesh solutions
• Lead cloud data platform design, primarily on AWS (Redshift, S3, Glue, DMS, Lambda)
• Drive MPP database architecture using Redshift, Snowflake, or equivalent
• Build robust data models, ERDs, and dimensional schemas
• Own ETL/ELT and CDC integration patterns across the data ecosystem
• Collaborate with stakeholders across engineering, product, and leadership
• Migrate legacy SQL Server environments to modern cloud platforms
• Contribute to Data Governance and compliance frameworks (FedRAMP, GDPR, CCPA)

What You Bring

• 8+ years in data architecture, database design & data modelling
• 5+ years hands-on with AWS data services ecosystem
• 3+ years architecting MPP solutions – Redshift, Snowflake
• Expert in data warehouse architecture & dimensional modelling
• Proficient in Python, SQL, Shell scripting
• Solid grasp of Data Lake technologies – Parquet, Delta Lake, Athena
• Experience with big data tools – Spark, Hadoop
• Strong stakeholder management & cross-functional influence
• Bonus: ML workflows, feature engineering knowledge

Education

• Bachelor’s in Computer Science, Information Systems, or related field
• Master’s degree preferred

High Impact Jobs: CareerXperts Jobs 

Follow CareerXperts on LinkedIn: CareerXperts Consulting