Data Solutions Architect

This is a fully remote position, open to applicants in Canada.

📋 Description

• Deliver in-depth technical knowledge and leadership across cloud data technologies.

• Facilitate tool selection, tackle intricate engineering challenges, and advocate for best practices during project engagements.

• Spearhead the design and implementation of data platforms tailored to client business needs.

• Conduct whiteboard design sessions with both internal and external teams.

• Identify and convey technical risks throughout the duration of projects.

• Gather project requirements, define deliverables, and collaborate with Principal Consultants to create technical roadmaps.

• Oversee data engineering teams as they execute project roadmaps.

• Direct technical tasks and priorities while providing necessary technical support.

• Manage project scope within customer engagements and communicate any changes in requirements.

• Foster strong customer relationships as a trusted advisor.

• Design comprehensive data solutions on Microsoft Fabric, incorporating Lakehouse, Data Warehouse, Real-Time Intelligence, and Data Factory.

• Facilitate technical design sessions and produce solution designs, data flow diagrams, and runbooks.

• Develop and enhance data pipelines utilizing Azure Data Factory and Fabric Data Engineering workloads.

• Establish and enforce data governance frameworks with Microsoft Purview.

• Implement comprehensive data lineage tracking and auditability.

• Set up data quality standards, monitoring, and remediation processes.

• Translate requirements into scalable platform designs in collaboration with product owners, engineers, and business stakeholders.

• Advocate for CI/CD, infrastructure-as-code (Bicep/Terraform), and DevOps methodologies in Azure data environments.

• Mentor engineering teams and contribute to the establishment of internal standards and reusable accelerators.

⛳️ Requirements

• Over 7 years of experience in data or solutions architecture roles, with hands-on delivery experience (preferably Azure).

• Profound practical knowledge of Microsoft Fabric, including Lakehouse, Warehouse, Pipelines, Notebooks, and OneLake.

• Strong expertise across the Azure data stack: ADF, Synapse Analytics, Azure Databricks, ADLS Gen2, Azure SQL.

• Proficiency in Python and/or Spark (PySpark) for data transformation, along with SQL for analytical workloads.

• Hands-on experience with Microsoft Purview for data cataloguing, lineage, classification, and governance policy enforcement.

• Demonstrated ability to implement data quality frameworks, including expectations, anomaly detection, and lineage-aware testing.

• Experience in constructing intricate data engineering pipelines and executing ETL/ELT tasks.

• Familiarity with relational databases such as Oracle, SQL Server, MySQL, Postgres, or MariaDB, as well as managed cloud RDBMS services like Amazon Aurora.

• Experience with NoSQL databases such as MongoDB, Cassandra, CouchDB, ElasticSearch, Neo4j, DynamoDB, or BigTable.

• Proven experience in building batch processing and real-time processing systems.

• Experience in developing Data Warehouses, Data Lakes, and unified analytics platforms.

• Familiarity with at least 3 of the following: real-time streaming solutions; analytics and BI solutions; AI/ML solutions; ML and AI model design and optimization; caching systems and object stores.

• Ability to discuss and design solutions involving data lineage, data quality gates, data anonymization, data governance, data security, data replication, data caching, data lifecycle management, data catalogs, and networking.

• Understanding of compliance frameworks such as HIPAA, PCI, GDPR, and PIPEDA.

• Excellent written and verbal communication skills, along with strong presentation abilities.

• Experience in authoring technical documentation.

• Background in technical mentoring.

• Experience in a customer-facing delivery role within a consulting or professional services environment.

🏝️ Benefits

• Competitive compensation package (CAD 170K-180K / year).

• Retirement Savings Matching Program (RRSP).

• Partnership with Perkopolis Discounts.

• Remote-first work environment.

• Flexible work hours and location.

• Paid parental leave options.

• Employer-paid health and dental premiums.

• GreenShield+ Counselling for Mental Health support.

• $500 annual Health Care Spending Account.

• Training reimbursement for courses on platforms like Udemy, Coursera, a-cloud-guru, etc.

• Peer recognition rewards.