Data Architect

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

AtLantern, 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.

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

$130,000 - $180,000 USD

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