Data Architect
Velocia
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