Data Architect

PrecisionERP is seeking a Data Architect/Modeler for a 6 month contract at our client located in downtown Toronto. Work onsite at least 2 days per week. Requirements: Must have at least 7 years experience in dimensional data modeling, data lake architecture, and enterprise data integration. Must have knowledge of OneStream, Hyperion, and financial systems such as Oracle EBS or equivalent. Design experience to optimize fact and dimension tables, data marts, and calculated metrics within Azure Data Lake, Must be able to support analytical and operational reporting with Power BI, and cloud-based analytics environments. Proficient in ETL/ELT development, data transformation, and scripting (SQL, Python, etc.). Good understanding of metadata management, data governance, and lineage tracking. Experience implementing data security, encryption, and compliance controls. Familiarity with building and maintaining data marts for self-service analytics.