This role requires a deep understanding of data warehousing, business intelligence (BI), and data governance principles, with a strong focus on the Microsoft technology stack. The Data Architect & Solutions Specialist will be responsible for developing and maintaining the overall data architecture, including data models and data flows. They will design and implement data warehouses, data marts, and data lakes on the Microsoft Azure platform. This role also involves designing and developing complex BI reports, dashboards, and scorecards using Microsoft Power BI, and working with data engineers to implement ETL/ELT pipelines using Azure Data Factory. Additionally, this role entails establishing and enforcing data governance policies and standards.