LanternVerified Job Source

Senior Data & AI Consultant

Edmonton, AB
On-site
Posted Sep 19, 2026
1 position

US$110,000–US$160,000 / year

Opens an external site

Employment type: Full-time
Experience level: Senior · 5+ years
Minimum education: Professional degree
Posting language: English
Working hours: 40 hours per week

Job summary

The consultant will design and deliver modern data, analytics, and AI solutions while working directly with client stakeholders to translate business needs into scalable technical architectures. Responsibilities include developing data pipelines, managing data governance, and mentoring team members to ensure high-quality project delivery.

Job details

At Lantern, our company culture stands as the bedrock of our success and a source of pride for our teams. We firmly believe that a culture founded on trust forms the basis for enduring relationships with clients, colleagues, and partners. Within this culture, we nurture an environment of respect, inclusion, and belonging, fostering collaboration among inspired teams. We prioritize the well-being of our colleagues, the success of our clients, and our positive impact on society. Embracing a growth mindset where curiosity thrives, we celebrate excellence and value individuals who inspire and mentor others, elevating the collective. Our driving force lies in personal and business growth. We go above and beyond to surprise and delight our clients, delivering tangible business value. In facing challenges, we make tough choices and solve complex problems to positively influence our clients, their customers, and the world at large. As a Microsoft services partner, we hold ourselves to the highest standards of technical excellence. This commitment to quality is evident not only in our work but also in how we support and empower our employees. At Lantern, our culture mirrors our core values and unwavering dedication to realizing our purpose and vision, making it a dynamic and fulfilling workplace. Together, we transcend the ordinary and achieve extraordinary results. Data Architect Lantern is seeking a hands-on, client-facing Senior Consultant, Data & AI 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. Key Responsibilities Facilitate discovery sessions, gather requirements, 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 technical components. Apply data governance, quality, metadata, lineage, observability, security, and cost-management practices 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, Knowledge and Expertise 5+ years of experience delivering data, analytics, or AI solutions, preferably in consulting or other client-facing environments. Strong hands-on experience with one or more core platforms - Azure Databricks, Microsoft Fabric, or Power BI - and working knowledge of the Azure modern data ecosystem. Proficiency in SQL and Python or PySpark, with experience in ETL/ELT, lakehouse or warehouse delivery, data modeling, and semantic models. Understanding of medallion and dimensional-modeling patterns, batch or streaming integration, and modern analytics architectures. Practical 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 effectively with architects, engineers, analysts, and client teams. Preferred Certifications Databricks Data Engineer Associate or Professional Microsoft Fabric Data Engineer Associate (DP-700) or Fabric Analytics Engineer Associate (DP-600) Power BI Data Analyst Associate (PL-300) Relevant Azure AI, machine learning, generative AI, or data-platform credentials Databricks Solutions Architect Champion is a plus Lantern is committed to fair and equitable compensation practices. Actual compensation will depend upon an individual’s skills, experience, qualifications, location, and other relevant factors. The salary pay range is subject to change and may be modified at any time. Colorado Salary Range $110,000—$160,000 USD Lantern is committed to fair and equitable compensation practices. Actual compensation will depend upon an individual’s skills, experience, qualifications, location, and other relevant factors. The salary pay range is subject to change and may be modified at any time. Ontario Salary Range $110,000—$160,000 CAD

What you’ll do

Requirements

Candidates must have at least 5 years of experience in data, analytics, or AI consulting with strong hands-on proficiency in Azure platforms and modern data ecosystems. Proficiency in SQL, Python, and data modeling patterns is required, along with excellent communication and problem-solving skills.