Apply on Kit Job: kitjob.ca/job/2g9d1s

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

Senior Data & AI Consultant Position Summary We are seeking a

Senior Consultant

for our

Data & AI

practice to lead transformative digital initiatives powered by the Microsoft ecosystem. This role is ideal for someone with deep expertise across Microsoft Fabric, Power BI, Azure Synapse, Data Factory, and Dataverse, who can translate complex data challenges into strategic business outcomes. You will architect and implement modern data platforms, guide clients on AI readiness, and mentor teams on leveraging the full Microsoft stack to enable advanced analytics, data governance, and intelligent automation.

Position Responsibilities

Design and implement enterprise‑grade data solutions using Microsoft Fabric, Azure Synapse Analytics, Data Factory, and Power BI, ensuring scalable, secure, and performant architectures.

Develop robust ETL/ELT pipelines leveraging Dataflows, Notebooks, and Pipelines within Fabric, enabling unified data ingestion and transformation across diverse data sources.

Build semantic data models and design data warehouses, lakes, and lakehouses for analytics, AI, and operational reporting.

Deliver end‑to‑end Power BI solutions, from dataset modeling to DAX optimization and interactive visual storytelling.

Provide strategic consulting on data modernization, AI enablement, and governance frameworks (e.g., Purview), aligning technical execution with business goals.

Lead and mentor cross‑functional teams, promoting best practices in data engineering, solution architecture,



and Microsoft platform adoption.

Act as a subject matter expert on the Microsoft Cloud Data Platform, staying current with updates across Fabric, Power BI, Synapse, and Azure OpenAI.

Qualifications

Bachelor’s degree in Computer Science, Data Engineering, or a related discipline.

4+ years hands‑on experience with the Microsoft Data & AI stack (Fabric, Power BI, Azure Data Factory, Synapse, SQL, Dataverse).

Proven success designing and delivering modern data platforms within Microsoft environments, integrating structured and unstructured data for analytics and AI.

Expertise in DAX, Power Query (M), T‑SQL, and Python for advanced data modeling and transformation.

Familiarity with Fabric’s OneLake, Data Activator, and Copilot integrations for automating data insights.

Experience implementing data governance and security via Microsoft Purview and Entra ID (Azure AD).

Excellent communication and presentation skills, capable of translating technical concepts for non‑technical audiences.

Preferred Qualifications

Microsoft Certified: Fabric Analytics Engineer Associate

Microsoft Certified: Power BI Data Analyst Associate

A culture that both wows our customers and employees;

Variety of challenging projects, and the ability to work with leading‑edge technologies;

Competitive salary & group benefits;

Generous training and education opportunities;

Diverse team social events;

Be part of a team that believes in diversity, inclusion, and a fun atmosphere!

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.

$120,000 - $165,000 USD

Voluntary Self‑Identification For government reporting purposes, we ask candidates to respond to the below self‑identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Lantern’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.



As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA.

Voluntary Self‑Identification of Disability We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress toward this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years. Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

Alcohol or other substance use disorder (not currently using drugs illegally)

Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS

Blind or low vision

Cancer (past or present)

Cardiovascular or heart disease

Celiac disease

Cerebral palsy

Deaf or serious difficulty hearing

Diabetes

Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders

Epilepsy or other seizure disorder

Gastrointestinal disorders, for example, Crohn’s disease, irritable bowel syndrome

Intellectual or developmental disability

Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD

Missing limbs or partially missing limbs

Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports

Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)

Neurodivergence, for example, attention‑deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities

Partial or complete paralysis (any cause)

Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema

Short stature (dwarfism)

Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

#J-18808-Ljbffr

Apply on Kit Job: kitjob.ca/job/2g9d1s

📌 Senior Data & AI Consultant (Edmonton)
🏢 Lantern
📍 Edmonton