Data Architect leading the design of a Customer Data Mart at ShyftLabs for Fortune 500 AI solutions. Collaborating with teams to implement scalable, secure, and modern data architectures.
Responsibilities
Own the technical vision and architecture for the Unified Customer Data Mart, ensuring solutions are scalable, secure, compliant, and aligned with enterprise standards.
Design and implement end-to-end data architectures of data pipelines, including raw data ingestion (Bronze), data cleaning and standardization (Silver), and curated data marts (Gold) that serve CDP, reporting, and activation use cases.
Define and evolve data modeling standards for customer data, including customer dimensions, transaction facts, engagement events, web behavior, support interactions, and loyalty activity.
Decomposing complex business requirements into structured technical solutions and driving alignment with client stakeholders.
Formulate, compare, and present multiple architectural approaches for data ingestion, transformation, identity resolution, and consumption patterns, guiding clients and internal teams toward optimal long-term solutions that balance speed, maintainability, and scalability.
Architect and build production-grade data pipelines using DBT and Airflow that support customer analytics, segmentation and reporting at scale.
Partner directly with client stakeholders to understand business objectives, translate customer journey requirements into robust technical designs, and act as a trusted technical advisor on data architecture decisions.
Lead and mentor cross-functional teams, including Analytics Engineers, Data Engineers, and BI developers, setting a high bar for technical quality, code review standards, and documentation practices.
Influence and contribute to data governance initiatives, including PII handling, data quality frameworks, identity resolution strategies, and platform reliability.
Requirements
Deep expertise in SQL and Python, with demonstrated ability to design, optimize, and troubleshoot complex distributed data systems.
5+ years of experience in data engineering and/or data architecture, with a proven track record of building and scaling enterprise-level data platforms.
Extensive experience designing and implementing data lakes, cloud data warehouses, and modern analytics architectures in production environments.
Hands on experience with DBT for transformations and modular data modeling.
Hands on experience with Google BigQuery (mandatory) or equivalent cloud warehouses (Snowflake, Databricks).
Hands on experience with Airflow (or similar orchestration frameworks).
Proven experience implementing medallion or layered data architectures, including raw ingestion, conformed layers, and curated marts.
Strong foundation in dimensional modeling, star/snowflake schemas, conformed dimensions, and designing for both analytical and operational use cases.
Experience with Customer Data Platforms (CDPs) and multi-channel customer data integration, including identity resolution (deterministic and probabilistic matching).
Experience designing for security and compliance, including PII masking, access controls, RLS policies, encryption, and privacy regulations (GDPR/CCPA).
Strong understanding of cloud architecture principles, including storage optimization, cost management, security patterns, and scalability in GCP environments.
Demonstrated ability to operate independently with full architectural ownership while influencing senior stakeholders in client-facing environments.
Experience leading and mentoring engineers, setting architectural standards, and driving technical governance.
Benefits
Comprehensive Benefits: 100% coverage for health, dental, and vision insurance for you and your dependents from day one.
Hybrid Flexibility: 4 days per week in our downtown Toronto office.
Continuous learning opportunities and influence over technical direction.
Shape applied research and AI strategy in a fast-growing, product-focused data company.
Data Engineering Intern assisting with data projects and cloud solutions at Simmons Bank. Collaborating on data pipelines and gaining exposure to modern data engineering concepts.
Data Engineer building and scaling client - facing Microsoft Fabric analytics platform to drive revenue and decision - making. Collaborating with teams to develop pipelines, optimize performance, and ensure client satisfaction.
Data Engineer role focusing on migrating legacy systems to ADA at BBVA. Collaborate with multidisciplinary teams and ensure system integrity during transitions.
Senior Data Engineer focused on modernizing enterprise data capabilities at U.S. Bank. Designing and building reusable data engineering patterns for consistent delivery across teams.
Experienced Data Architect designing and implementing scalable data architecture for a financial services and healthcare technology company. Collaborating across teams to support analytics and operational needs.
Principal Data Pipeline Lead at SS&C overseeing development of scalable data pipelines. Leading a small team and providing technical guidance for modern data platform integration.
Senior Data Engineer at SS&C building and optimizing data pipelines in a lakehouse environment. Collaborating with data architects and stakeholders in the financial services sector.
Data Architect designing scalable, secure data architectures for fraud detection and risk management at Fiserv. Collaborating with cross - functional teams and managing large datasets and pipelines.
Director of Engineering overseeing development of AI - driven data platforms at LVT. Leading teams to transform sensor data into actionable insights using modern architecture and technologies.
Senior Data Engineer at Independence Pet Holdings shaping data ecosystem by building platforms and pipelines. Collaborating with teams to enhance data analytics and operational insights.