Essential Duties and Responsibilities

• Lead the design and implementation of robust and scalable data architectures across enterprise, with an initial focus on data lakes/warehouses, data pipelines, and master data management.
• Collaborate with cross-functional teams to understand business requirements and translate them into effective data solutions.
• Creat data architecture artifacts and own the architecture governance and practices.
• Define and design innovative Data & Analytics architectures and solutions that leverage the right trade-off between clients’ realities, latest and disruptive technologies, current and future business needs, budget constraints, data availability, and resource requirements.
• Oversee the design of the data lake/warehouse infrastructure, ensuring it meets the organization’s scalability, security, and performance requirements.
• Promote and implement best practices for data lake/warehouse governance, metadata management, and data catalogues.
• Design and optimize end-to-end data pipelines for efficient data flow and integration, ensuring data quality and consistency.
• Work closely with data engineers, BI engineers, and reporting analysts to streamline the ETL (Extract, Transform, Load) processes.
• Define and implement master data management strategies to ensure the accuracy, consistency, and reliability of critical business data.
• Establish and enforce data quality standards, consistency, and processes across the organization.
• Evaluate and select appropriate tools and technologies for different components of the data architecture.

What You’ll Need to Be Successful

• A track record of at least 12 years in Data Architect and Data modernization within a Cloud Data Warehouse environment, specifically in Azure. 
• Demonstrated expertise in crafting, constructing, and validating data pipelines that integrate data from diverse sources into a centralized data platform or Enterprise Data Warehouse.
• You have good understanding of the different data architecture patterns: Data Fabric, Data Mesh, Data Warehouse, Data Marts, data modeling, ontologies & knowledge graphs, MicroServices
• Experience building Microsoft Azure, SQL Databases/Data Warehouses is an asset.
• The ability to recognize and delineate data gaps and challenges when engaged in data migration efforts during system implementations.
• 10+years of DBA experience with MS SQL Server, SQL Server Analysis Services, and SQL Server Integration Services
• 10+ years’ experience with data architecting, large-scale data modelling, and business intelligence.
• Demonstrates experience in implementing enterprise data management, processes, procedures, and decision support.
• Strong proficiency with Python; Microsoft Fabric, Synapse, Pandas, and/or Apache Spark