Senior Data & AI Architect - Client-Facing Azure & Power BI

Lantern; Edmonton; On-site; CAD 154,000 - 223,000; Full time

Job summary

Lantern is seeking a hands-on Data Architect to design and deliver modern data, analytics, and AI solutions across Azure Databricks, Microsoft Fabric, Power BI, and Azure. You will work directly with client stakeholders and Lantern delivery teams to translate business needs into secure, governed, and scalable solutions that support analytics, machine learning, generative AI, and intelligent applications.

This senior role combines leadership with hands-on delivery, mentoring consultants, and

Qualifications

• 5+ years of experience delivering data, analytics, or AI solutions.
• Strong hands-on experience with Azure Databricks, Microsoft Fabric, or Power BI.
• Proficiency in SQL and Python or PySpark, with ETL/ELT and data modeling experience.
• Understanding of medallion and dimensional-modeling patterns and modern analytics architectures.
• Experience with data governance, security, quality, metadata, lineage, observability, CI/CD, performance, and cost optimization.
• Strong consulting, communication, documentation, problem-solving, and stakeholder-management skills.
• Ability to work independently on assigned workstreams while collaborating with architects and client teams.

Responsibilities

• Facilitate discovery sessions and translate business needs into practical solution designs and delivery plans.
• Design, build, test, and deploy lakehouse, warehouse, batch, streaming, and real-time data solutions using Databricks, Fabric, Power BI, and Azure.
• Develop data pipelines, transformations, models, semantic layers, dashboards, notebooks, and reusable components.
• Apply governance, security, quality, metadata, lineage, observability, and cost management throughout delivery.
• Implement CI/CD, DevOps, DataOps, source-control, testing, and deployment patterns for modern data platforms.
• Own assigned workstreams, communicate progress and risks, troubleshoot issues, and help deliver high-quality outcomes on time.
• Contribute to estimates, proposals, demonstrations, accelerators, technical documentation, and knowledge sharing.
• Mentor consultants and engineers, participate in peer reviews, and collaborate with architects and project leaders on technical decisions.

Skills

SQL

Python / PySpark

Data modeling

ETL/ELT

Data governance

CI/CD

Stakeholder management

Communication

Consulting experience

Mentoring

Tools

Azure Databricks

Microsoft Fabric

Power BI

Job description

Lantern is seeking a hands-on Data Architect to design and deliver modern data, analytics, and AI solutions across Azure Databricks, Microsoft Fabric, Power BI, and Azure. You will work directly with client stakeholders and Lantern delivery teams to translate business needs into secure, governed, and scalable solutions that support analytics, machine learning, generative AI, and intelligent applications.

This senior role combines leadership with hands-on delivery, mentoring consultants, and