lanternstudiosinc
Senior Data & AI Consultant
At a Glance
- Location
- United States
- Experience
- 4+ years
- Posted
- 2026-02-18T13:36:04-05:00
Key Requirements
Required Skills
Domain Knowledge
- Engineering
Requirements
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).
Compensation & Benefits
A culture that both wows our customers and employees;
Variety of challenging projects, and the ability to work with leading-edge technologies;
Generous training and education opportunities;
Diverse team social events;
Be part of a team that believes in diversity, inclusion, and a fun atmosphere!
Responsibilities
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.
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.