Data Architect

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.
• 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-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 Lakehouses 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 being released across Microsoft Fabric.
• Coach team members around Microsoft Data Platform technology stack.
• Assist in technical Sales conversations.
• Create growth and opportunity for our clients utilizing technical solutions from our partner, Microsoft.

Skills, Knowledge and Expertise

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