Technical Architect - Decommissioning Project (Calgary) …, Alberta

Technical Architect – Decommissioning Project Location: Calgary, AB Position Overview The Technical Architect will enable the ingestion, transformation, and delivery of business‑consumable data as part of the project decommissioning initiative. This role is critical to ensuring that data extracted from the project application is transformed into usable, governed datasets within the enterprise data platform or equivalent architecture supporting business reporting and operational continuity following system shutdown. Key Responsibilities Enable end‑to‑end data ingestion and transformation pipeline for project application data. Deliver business‑ready datasets to meet reporting and operational requirements post‑application shutdown. Support or establish medallion data architecture (bronze, silver, and gold layers). Mitigate risks associated with data usability and reporting readiness, identified as the highest risk area in the program. Design and deliver end‑to‑end data products in Microsoft Fabric using repeatable patterns that support key business flows. Build and optimize Fabric Data Factory pipelines and notebook‑based, Spark‑job‑based transformations to populate OneLake, Lakehouse, and/or Warehouse layers and downstream data marts. Define technical requirements and deliver solutions that meet service level agreements through efficient modeling, partitioning, caching, and query optimization across Fabric compute engines. Implement monitoring and observability for pipelines and models (refreshes, failures, data drift) and proactively resolve performance, reliability, and cost/capacity issues. Design, integrate, and document technical components (data contracts, lineage, definitions) for seamless data extraction, governance, and analysis. Present insights on data and its quality via presentations and visualizations. Define and develop automation within Microsoft Fabric. Support the corporation's broader technical and operational requirements by adopting best practices in our data systems. Work in a team environment, interacting with multiple groups daily, within the department and throughout the corporation. Skills & Qualifications Deep hands‑on expertise with Microsoft Fabric workloads: Data Factory (pipelines), Lakehouse, Warehouse, Real‑Time Analytics, Semantic Models, and (where applicable) Data Activator. Robust understanding of OneLake concepts, shortcuts, and Lakehouse architecture; ability to design scalable medallion‑style (bronze/silver/gold) data models and performant analytics solutions. Strong knowledge of Python and Spark; ability to build and optimize notebooks/jobs in Fabric (or Databricks) for ELT/ETL, data quality, and advanced transformations. Working knowledge of governance and administration in Fabric: workspaces, domains, sensitivity labels, RLS/OLS, and capacity management; understanding of Purview integration. Knowledge of analytics engineering practices: metric definitions, semantic layer design, data quality expectations, and documentation for trusted self‑serve BI. Strong Power BI expertise, including Semantic Models, DAX fundamentals, and performance tuning. Experience ingesting batch and streaming/event data (e.g., Event Hubs, Kafka, logs) and shaping it for analytics using Fabric pipelines, notebooks, and Real‑Time Analytics. Experience performing root‑cause analysis on data pipelines, models, and reports to answer business questions, improve reliability, and reduce time‑to‑insight. Working knowledge of DevOps/DataOps and Git; experience with Azure DevOps deployment pipelines, CI/CD automation, and setting promotion. Working knowledge of Azure fundamentals (identity, networking, security) and Entra ID; familiarity with private endpoints and secure data access patterns. Experience integrating enterprise data sources (SQL Server, APIs, files, SaaS) and designing robust ingestion patterns (incremental loads, CDC, scheduling, monitoring). Minimum of 4+ years of advanced Python development (performance tuning). Equity Statement At Compugen, we are committed to diversity, equity and inclusion. We actively recruit from all groups, including women, Indigenous people, persons with disabilities and members of visible minorities. We recognize the importance of removing barriers to participation and provide accommodation upon request to all applicants throughout the recruitment process. If you require an accommodation, our People & Culture representative will work with you to meet your needs in a confidential and respectful manner. We believe everyone deserves a seat at the table—and we are taking deliberate action to make this a reality. #J-18808-Ljbffr Apply on Kit Job: kitjob.ca/job/2pkob4