Lantern
Posted 7mo ago

Data Architect & Engineer

Lantern
Edmonton or Calgary or Toronto
OnsiteFull Time
Responsibilities
  • Strategize solutions
  • Collaborate clients
  • Lead projects
Requirements
  • Experienced data architect designing analytics solutions using Microsoft Fabric
  • Azure Synapse
  • Power BI
  • Client-facing with strong SQL
  • Data warehousing
  • Data modeling
  • Leadership and mentoring
Technical tools mentioned
Microsoft FabricAzure SynapsePower BISQLData FactoryApache SparkDelta LakeDAXM/Power QueryKimball dimensional modeling

Job description

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.

Data Architect 

We are seeking an experienced Data Architect to join our team at Lantern. In 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. This role 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.


Key Responsibilities

• 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.
• Conducting 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
• Creating highly performant and scalable Data Warehouses and Lakehouses using Microsoft Fabric and Azure Synapse.
• Designing and building scalable and efficient data pipelines using Data Factory.
• Adding data validation and quality checks throughout data pipelines.
• Developing enterprise grade Power BI / Analysis Services semantic models.
• Optimizing existing ETL process and data transformations.
• Create technical documentation for solutions that have been built.
• Troubleshoot production systems, address technical issues, etc.
• Team leadership
• Staying up-to-date on the latest features and capabilities being released across Microsoft Fabric.
• Coaching team members around Microsoft Data Platform technology stack.
• Assisting in technical Sales conversations.
• Create growth and opportunity for our clients utilizing technical solutions from our partner, Microsoft.


Skills, Knowledge and Expertise

• Has 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 lifecycles.
• Able to serve as a liaison between both 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.

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!

About Lantern

Delivering Microsoft-driven AI and cloud solutions for enterprise clients.

Year founded
2023
Employees
300
Organization type
Private
Latest investment
Private Equity (2023) — led by Columbia Capital
Headquarters
US

Similar jobs

Data Architect roles near Edmonton, Alberta
2d
Save
Mark Applied
Hide
Data Architect – Senior
Canada or Edmonton
$90-$100/hr HybridContract
SereneAid
SereneAid: Provides comprehensive home health care and personal support services.
5+ YOERequires 5+ years in data architecture and Kimball modeling, strong SQL/database development, Azure training, and 2+ years of public-sector experience. A related post-secondary credential is preferred.
Microsoft T-SQL, Oracle, PL/SQL, Microsoft Azure, SAP/Sybase PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, Microsoft Visio, Power BI, JOIN, JIMS, Enterprise Data Warehouse (EDW), ETL/ELT
3w
Save
Mark Applied
Hide
Manager, Data Management and Architect
Toronto or Ottawa or Edmonton or Halifax or St. John's or Calgary or Sudbury
$128k-$157k/yr OnsiteFull Time
BrokerLink
BrokerLink: Provides personal and commercial insurance brokerage services across Canada.
7+ YOE3+ Mgmt7+ years in data architecture/management, 3+ years leading teams, experience with data platforms, governance, modelling, integration, and cloud; university degree or equivalent; strong stakeholder and delivery skills.
Databricks, Azure Data Lake, Azure Synapse, Microsoft Fabric, Power BI, SQL Server
1mo
Save
Mark Applied
Hide
Senior Data Architect (PostgreSQL + Graph Databases)
Calgary or Edmonton or Canada
HybridFull Time
ELEKS
ELEKS: Custom software engineering and technology consulting services provider.
8+ YOE8+ years in data architecture; expert PostgreSQL architecture, optimization, and modeling; experience with graph databases (Neo4j, Neptune, TigerGraph); ETL/ELT and cloud-native DB experience; strong communication and English.
PostgreSQL, Neo4j, Neptune, TigerGraph
1w
Save
Mark Applied
Hide
Senior Architect - Data & AI
Winnipeg or Wawanesa or Vancouver or Calgary or Edmonton or Lethbridge or North York or Kitchener or Ottawa or Montreal or Quebec City or Moncton or Dartmouth or Canada
$115k-$160k/yr HybridFull Time
Wawanesa Insurance
Wawanesa Insurance: Provides diverse insurance products and services across Canada.
2+ YOEBachelor’s degree or equivalent, 2–5 years of IT architecture experience, 10 years of full lifecycle solution design, enterprise architecture, object-oriented design, modeling, governance, and complex solution delivery experience.
AWS, MLflow, SageMaker Pipelines, CI/CD, MLOps, feature stores
6mo
Save
Mark Applied
Hide
Senior Data Architect
Edmonton, Alberta, Canada
HybridFull Time
Stantec
StantecTSX: STN: Provides professional engineering, architecture, and environmental consulting services.
10+ YOEExperience: 10+ years in data architecture/IT roles; Oracle EBS, data integration, cloud, governance, and leadership.
Oracle EBS, Oracle EBS R12, Oracle Integration Cloud (OIC), Oracle SOA Suite, Oracle Service Bus, Oracle Data Integrator (ODI), Oracle REST/SOAP APIs, Oracle Cloud Infrastructure (OCI), Oracle Autonomous Data Warehouse (ADW), OBIEE, Oracle Discoverer, Oracle Analytics Cloud, SQL