If you are a Techstars portfolio companyclaim your profile.

Data Architect



Toronto, ON, Canada
Posted on Thursday, April 11, 2024
Blanc Labs is a premier partner for global enterprises, leading the way in digitization, automation, and the development of next-generation digital products and services. Our expertise in digital transformation powers businesses to accelerate service delivery, drive customer engagement, and foster growth.
The Data Architect will be responsible for designing and maintaining the enterprise data warehouse for various projects, while also providing ongoing support for activities that impact all enterprise databases. They will work within a high-performing team to design, build, optimize, and maintain innovative solutions on Microsoft Azure's Data Platform, using cutting-edge cloud services. Additionally, the incumbent will be accountable for ensuring data integrity, enabling effective, accurate, and timely generation of all enterprise reports.

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
Blanc Labs is enabling a digital future. Headquartered in Toronto, we partner with clients in North & South America to digitize and automate their operations and build their next generation of digital products and services. We empower clients to enhance their digital offerings and bring creative solutions to the market faster. Learn more at www.blanclabs.com.
Blanc Labs is an equal opportunity employer and is committed to providing employment in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. Accommodations within reason due to a disability or medical need are available on request for candidates taking part in the recruitment process.