Description
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: Azure Data Engineer Associate
- Microsoft Certified: Power BI Data Analyst Associate
Benefits
- 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!
Similar jobs
Est. 144,000 USD
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, colleag…
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, colleag…
Est. 141,000 USD
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, colleag…
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, colleag…
Est. 124,000 USD
At AlixPartners, we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communitie…
Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most popular platforms. With the support of an international team of dynamic and collabor…
Est. 140,000 USD
Founded in 2017, Lovelytics has helped some of the most complex enterprises across industries such as Energy & Utilities, Media & Entertainment, Manufacturing and Retail & CPG, modernize their data and put AI…
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, colleag…
Est. 25,000 USD
The Job in short The Data Enablement team is here to enable every team in the organisation with their data needs. Our job starts the moment that data enters our platform and ends when it reaches whoever needs it. We are…
Est. 257,000 USD
Company Overview We are the better way to work in finance. As private equity’s value creation partner, we sit at the heart of PE—where sponsors and CFOs meet. Through financial consulting rooted in data, technology, and…
Est. 156,250 USD
Company Overview We are the better way to work in finance. As private equity’s value creation partner, we sit at the heart of PE—where sponsors and CFOs meet. Through financial consulting rooted in data, technology, and…
Est. 130,000 USD
Founded in 2017, Lovelytics has helped some of the most complex enterprises across industries such as Energy & Utilities, Media & Entertainment, Manufacturing and Retail & CPG, modernize their data and put AI…
Est. 250,000 USD
USA (Remote) with 35-40% Travel Robots & Pencils is an applied AI engineering firm building the next frontier of business architecture. We design and ship AI co-workers that integrate into enterprise operations and d…
Est. 144,000 USD
About Lantern Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, in…
Est. 114,000 USD
As one of Microsoft’s most recognized global partners, Quisitive sits at the forefront of cloud transformation, enterprise data strategy, cybersecurity, and the emerging frontier of agentic AI. Here, consultants and tech…
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, colleag…
Est. 80,000 GBP
Alpha Financial Markets Consulting (Alpha) is a leading global consultancy to the financial services industry. We are a boutique management consulting firm that offers the world’s top industry players a competitive edge…
At HSO, we're looking for a proactive and skilled Data Engineer to join our growing team. In this role, you'll design, build, and optimize modern data platforms that enable organizations to unlock the full value of their…
At HSO, we're looking for a proactive and skilled Data Engineer to join our growing team. In this role, you'll design, build, and optimize modern data platforms that enable organizations to unlock the full value of their…
Est. 90,000 GBP
Senior Data Engineer Who we are Artefact is a new generation of data service provider, specialising in data consulting and data-driven digital marketing, dedicated to transforming data into business impact across the ent…
Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…
Est. 210,500 USD
Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Robots & Pencils is an applied AI engineering firm building the next frontier of business architecture. We design and ship AI co-workers that integrate into enterprise operations and deliver measurable results for ou…
Est. 175,000 USD
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Est. 140,000 USD
Join phData, a remote-first data and AI consultancy company with employees across the United States, Latin America, and India. We partner with industry leaders, including Snowflake, AWS, Anthropic, Glean, and dbt, to sol…
Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…
Est. 124,000 USD
Data Architect – Inspire11 Elevens, as we call ourselves here, are curiously smart, purposefully scrappy, and dedicated to the highest standard of quality. By being true to ourselves and others, we create a respectful en…
Est. 197,500 USD
Company Overview We are the better way to work in finance. As private equity’s value creation partner, we sit at the heart of PE—where sponsors and CFOs meet. Through financial consulting rooted in data, technology, and…
WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and e…