Data Architect AB

Data Architect

We are seeking an experienced Data Architect to join our team  this role you will play a crucial role in designing and implementing solutions that drive business insights for our clients. This role will be a key resource in our Business Analytics Practice and will be client‑facing, innovating with solutions from the Microsoft Data Platform stack, including Fabric, Azure Synapse, Power BI, and SSAS.

The primary objective of this role is to assist our clients in establishing a data platform and data culture that enables them to leverage advanced reporting, analytics, and AI. The Data Architect will be responsible for working with our clients to understand their business and technical requirements, architecting analytics solutions, and providing technical guidance to our consulting team.

• Strategic Advisory, Technical Advisory, and Solution Architecting
• Collaborate with customers to understand their business needs, data challenges, and technical requirements.
• Provide strategic guidance on leveraging Microsoft Data Platform technologies (such as Fabric, Azure Synapse, Power BI, etc.) for data warehousing, data engineering, semantic modeling, analytics, reporting, and machine learning.
• Conduct customer‑facing strategic workshops and assessments of existing data platforms to create recommendations on how to best modernize their data platform using the Fabric and Azure Synapse.
• Architect end‑to‑end solutions that align with customer goals and maximize Fabric and Power BI capabilities.
• Solution Development: create highly performant and scalable data warehouses and lake houses using Microsoft Fabric and Azure Synapse.
• Design and build scalable and efficient data pipelines using Data Factory.
• Add data validation and quality checks throughout data pipelines.
• Develop enterprise‑grade Power BI / Analysis Services semantic models.
• Optimize existing ETL processes and data transformations.
• Create technical documentation for solutions that have been built.
• Troubleshoot production systems, address technical issues, etc.
• Team Leadership: stay up‑to‑date on the latest features and capabilities across Microsoft Fabric, coach team members around the Microsoft Data Platform technology stack.
• Assist in technical sales conversations.
• Create growth and opportunity for our clients utilizing technical solutions from our partner, Microsoft.

• Strong consulting skills gained through experience in a consulting organization.
• Excellent communication and customer service skills.
• Proven track record of working closely with clients to determine their needs and ensure their ongoing satisfaction.
• Genuine interest and ability to quickly switch between multiple clients and initiatives on a frequent basis.
• Experience in Agile software development as a team member.
• Strong meeting facilitation skills.
• Experience in all phases of product, software, and testing life cycles.
• Ability to serve as a liaison between business and technical teams.
• Strong proficiency in T‑SQL and Data Warehousing.
• Strong proficiency in Apache Spark and Delta Lake for data engineering.
• Strong proficiency in Fabric or Azure Data Factory pipelines.
• DAX, M/Power Query.
• Data modeling – Kimball dimensional modeling, semantic/tabular models.

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

$128,000 - $180,000 CAD

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.