| Auckland Jobs |
| Canterbury Jobs |
| Northland Jobs |
| Otago Jobs |
| Southland Jobs |
| Tasman Jobs |
| Wellington Jobs |
| West Coast Jobs |
| Auckland Jobs |
| Canterbury Jobs |
| Northland Jobs |
| Otago Jobs |
| Southland Jobs |
| Tasman Jobs |
| Wellington Jobs |
| West Coast Jobs |
| Oil & Gas Jobs |
| Banking Jobs |
| Construction Jobs |
| Top Management Jobs |
| IT - Software Jobs |
| Medical Healthcare Jobs |
| Purchase / Logistics Jobs |
| Sales |
| Ajax Jobs |
| Designing Jobs |
| ASP .NET Jobs |
| Java Jobs |
| MySQL Jobs |
| Sap hr Jobs |
| Software Testing Jobs |
| Html Jobs |
| Job Location | Toronto, Ontario, M5A 3N7 |
| Education | Not Mentioned |
| Salary | Not Mentioned |
| Industry | Not Mentioned |
| Functional Area | Not Mentioned |
| Job Type | Full time |
Job Summary: This senior-level Data Architect/Modeller role involves designing and implementing an enterprise-grade data lake architecture, integrating legacy and modern data systems to support advanced analytics and AI initiatives. The successful candidate will define a unified dimensional model, ensure data consistency and quality, and work collaboratively with stakeholders across Finance, HR, and IT to deliver a governed, future-proof data platform. This position requires strong technical skills in data modeling, ETL/ELT processes, cloud-based analytics, and data governance, as well as excellent communication and stakeholder management abilities. Location: Toronto, Ontario, Canada Responsibilities: - Architect and develop a robust dimensional data model across OneStream, Hyperion, Oracle EBS, HCM, and Workbrain systems. - Design and optimize fact and dimension tables, data marts, and calculated metrics within the Azure Data Lake to support analytical and operational reporting. - Lead ETL/ELT strategy and implementation to integrate historical and current data sources, focusing on scalability and performance. - Implement and maintain data security controls, including encryption, RBAC policies, privacy standards, and adherence to governance standards. - Develop and enforce data quality frameworks, including automated monitoring, validation rules, and reconciliation processes. - Develop metadata-driven processes and data marts to support self-service analytics and executive reporting. - Drive high-performance data solutions ready for AI, machine learning, and predictive analytics, enabling PowerBI analytical reports. Required Skillsamp; Certifications: - Proven experience in dimensional data modeling, data lake architecture, and enterprise data integration. - Strong knowledge of OneStream, Hyperion, and financial systems (e.g., Oracle EBS). - Hands-on expertise with Azure Data Lake, Power BI, and cloud-based analytics environments. - Proficiency in ETL/ELT development, data transformation, and scripting (SQL, Python, etc.). - Solid 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. - Excellent communication and stakeholder engagement skills. - Bachelor #39;s or Master #39;s degree in Computer Science, Information Systems, Data Engineering, or a related field. Preferred Skillsamp; Certifications: - None explicitly listed in the provided text. Special Considerations: - Candidates must be willing to work 2 days per week onsite. Scheduling: - A hybrid schedule with 2 days per week in the office is required. Specific scheduling details will likely be discussed during the interview process.