BI Architect

Our banking client is hiring a BI Architect on a contract basis. This is a 9 month contract to start with a potential extension, located in downtown Toronto with an onsite requirement of 3-4 times per week.

Please reach out at jaredg@corgta.com to learn more.

*No third-party agencies please*
__________
Candidate Requirements/Must Have Skills:
1.   8+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
2.   8+ years hands-on with Power BI (DAX, M, modeling, Premium capacities).
3.   8+ years of advanced SQL (optimizations, stored procedures, performance tuning).
4.   8+ years with Databricks (PySpark, Delta Lake, workflows, notebooks).
5.   8+ years with Dimensional modeling (Kimball), semantic modeling, governance, and star schema design.
6.   8+ years designing Lakehouse architecture and modern data stack solutions.
7.   8+ years working with CI/CD for analytics, Git, and DevOps pipelines.

Nice-To-Have Skills:
1) Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL).
2) Data Lake file formats: Parquet, Delta, ORC, DuckDB (nice to have).
3) Experience in Risk Analytics, Banking, or Credit Risk domains.
4) Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python.
5) Architect and refine Lakehouse and Medallion-based data structures using Delta/Parquet/DuckDB formats.
6) Knowledge of Security, Privacy, and Compliance standards in financial institutions.
7) Experience working in enterprise environments with structured SDLC processes.