Data AI Engineer
Role summary
YYC Data Solutions is seeking a Data AI Engineer in Calgary, AB, to design, build, and scale modern data and AI-driven solutions. This role involves working across data engineering, analytics, and AI layers, building robust pipelines and enabling intelligent data access using cloud technologies. The ideal candidate will own end-to-end data workflows, from ingestion to transformation to AI-powered applications, utilizing tools like Snowflake, dbt, AWS, and Terraform. Responsibilities include data modeling, pipeline development, AI solution implementation, infrastructure management, and ensuring data security and compliance. The position offers a competitive salary, flexible remote work, and the opportunity to impact architecture decisions.
Company Description
YYC Data Solutions is a consulting company dedicated to leveraging advanced data and artificial intelligence technologies to create innovative solutions for complex challenges. Based in Calgary, AB, YYC Data Solutions collaborates with industry leaders to develop data tools that promote smarter decision-making and operational efficiency. With a focus on data research and practical applications, the company fosters a dynamic environment where creativity and expertise converge to address real-world problems.
About the Role
We are looking for a Data AI Engineer to join our team and help design, build, and scale modern data and AI-driven solutions. You will work across data engineering, analytics, and AI layers, building robust pipelines and enabling intelligent data access using modern cloud technologies.
This role is ideal for someone who is comfortable owning end-to-end data workflows, from ingestion to transformation to AI-powered applications.
Responsibilities
- Design and implement scalable data pipelines and data models
- Build and maintain data warehouses using Snowflake
- Develop and optimize transformations using dbt
- Implement data ingestion processes from multiple sources (APIs, databases, third-party tools)
- Develop AI-driven solutions using Snowflake Cortex (e.g., text-to-SQL, embeddings, automation workflows)
- Manage infrastructure using Terraform and ensure reproducibility
- Work with AWS services to support data platform architecture
- Ensure data security, governance, and compliance best practices
- Optimize performance, cost, and reliability of data systems
- Collaborate with analytics and business teams to deliver data solutions
Requirements
- 4+ years of experience in data engineering, analytics engineering, or related roles
- Strong experience with Snowflake (data modeling, performance tuning, architecture)
- Hands-on experience with Snowflake Cortex or similar AI capabilities
- Proficiency with dbt for transformation and data modeling
- Experience with data ingestion tools and building custom pipelines
- Solid knowledge of AWS (S3, networking, IAM, compute services)
- Understanding of networking concepts (VPC, private access, security groups)
- Experience with Terraform and Infrastructure as Code
- Strong understanding of data security and access control principles
- Proficiency in SQL and Python
Nice to Have
- Experience building AI agents or text-to-SQL systems
- Familiarity with CI/CD for data workflows
- Experience with streaming or near real-time pipelines
- Background in analytics or working closely with business stakeholders
What We Offer
- Competitive salary and flexible remote work
- Opportunity to work on modern data and AI technologies
- High ownership and impact on architecture decisions
- Collaborative and fast-moving environment
Job Title:
Data AI Engineer
Location:
Remote (Canada)
Employment Type:
Full-time
Salary:
CAD $120,000 – $150,000 per year
