Senior Data & AI Consultant

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.

The Opportunity

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.

What You’ll Do

• 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.

Required Skills and Experience

• 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

Why Join Lantern?

• Deliver high-impact data, analytics, and AI transformation initiatives.

• Build hands-on expertise with Microsoft Fabric, Azure Databricks, Power BI, Azure, and emerging AI technologies.

• Work directly with clients and collaborate with experienced data, AI, application, and cloud professionals.

• Grow through mentoring, challenging assignments, and strong learning and certification support.

• Help shape reusable delivery practices and the continued growth of Lantern’s Data & AI Service Line in an inclusive, accountable, and innovative culture.

Benefits

• Competitive compensation and group benefits.

• Challenging projects using leading technologies.

• Generous training, education, and certification support.

• A collaborative, inclusive, and engaging work environment.

Join Lantern and help organizations build modern, governed, and AI-ready data platforms that turn information into intelligence and intelligence into meaningful business outcomes.

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