Client‑Facing Data Architect: Azure Synapse & Power BI

Lantern; Denver (CO); On-site; USD 130,000 - 180,000; Full time

Benefits offered by this job

Competitive salary

Training opportunities

Diversity & inclusion

Job summary

Lantern is seeking an experienced Data Architect to design and implement data solutions that drive business insights for clients in our Business Analytics Practice. This role will be client facing and leverage the Microsoft Data Platform stack (Fabric, Azure Synapse, Power BI, SSAS) to establish data platforms and data culture for advanced reporting, analytics, and AI.

The Data Architect will work with clients to understand business and technical requirements, architect analytics solutions, and

Qualifications

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

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

Consulting skills

Excellent communication

Client-facing

Agile experience

Team leadership

T-SQL

Data warehousing

Semantic modeling

Fabric

Azure Data Factory

Tools

Microsoft Fabric

Azure Synapse

Power BI

SSAS

Data Factory

Apache Spark

Delta Lake

Kimball modeling

Job description

Lantern is seeking an experienced Data Architect to design and implement data solutions that drive business insights for clients in our Business Analytics Practice. This role will be client facing and leverage the Microsoft Data Platform stack (Fabric, Azure Synapse, Power BI, SSAS) to establish data platforms and data culture for advanced reporting, analytics, and AI.

The Data Architect will work with clients to understand business and technical requirements, architect analytics solutions, and