drjobs Data Architect Modeller 0142-0812

Data Architect Modeller 0142-0812

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Toronto - Canada

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.

Description
Senior Data Architect Dimensional Modeling and amp; Data Lake Integration
  • Were looking for a Senior Data Architect to design and lead the implementation of an enterprisegrade data lake architecture integrating legacy Hyperion data with modern platforms like OneStream Azure Data Lake and other financial and HR systems.
  • In this role you will define a unified dimensional model ensure data consistency and enable advanced analytics and AIreadiness across the organization. Youll work closely with stakeholders in Finance HR and IT to deliver a governed futureproof data platform that powers crossfunctional decisionmaking.

Key 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 with a focus on scalability and performance.
  • Implementing data quality rules data lineage tracking and proactive monitoring to ensure auditability integrity and compliance.
  • Develop and enforce data quality frameworks including automated monitoring validation rules and reconciliation processes.
  • Implement and maintain data security controls such as encryption rolebased access controls (RBAC) policies privacy standards and adherence to governance standards
  • Leading the development of metadatadriven processes and data marts that power selfservice analytics and executive reporting.
  • Driving highperformance data solutions that are futureready for AI machine learning predictive analytics and enable PowerBI analytical reports

Required Skills and amp; Qualifications
  • Proven experience in dimensional data modeling data lake architecture and enterprise data integration.
  • Strong knowledge of OneStream Hyperion and financial systems such as Oracle EBS or equivalent.
  • Handson expertise with Azure Data Lake Power BI and cloudbased analytics environments.
  • Proficient 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 selfservice analytics.
  • Excellent communication and stakeholder engagement skills across business and technical teams.
  • Bachelors or Masters degree in Computer Science Information Systems Data Engineering or related field.

Must Haves:
  • Architect and develop a robust dimensional data model across OneStream Hyperion Oracle EBS HCM and Workbrain systems. Finance within a company
  • 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 with a focus on scalability and performance.
  • Implement and maintain data security controls such as encryption rolebased access controls (RBAC) policies privacy standards and adherence to governance standards

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.