Data Architect
Toronto
Blanc Labs
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Data management Data pipelines Data quality Data warehouse ETL Microservices MS SQL Pandas Pipelines Python Security Spark SQL
Perks/benefits: Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs