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.