Senior Data & AI Consultant

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

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