About the role
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 & Data Lake Integration
- We're looking for a Senior Data Architect to design and lead the implementation of an enterprise-grade 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 AI-readiness across the organization. You'll work closely with stakeholders in Finance, HR, and IT to deliver a governed, future-proof data platform that powers cross-functional decision-making.
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, role-based access controls (RBAC) policies, privacy standards, and adherence to governance standards
- Leading the development of metadata-driven processes and data marts that power self-service analytics and executive reporting.
- Driving high-performance data solutions that are future-ready for AI, machine learning, predictive analytics, and enable PowerBI analytical reports
Required Skills & 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.
- Hands-on expertise with Azure Data Lake, Power BI, and cloud-based 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 self-service analytics.
- Excellent communication and stakeholder engagement skills across business and technical teams.
- Bachelor's or Master's 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, role-based access controls (RBAC) policies, privacy standards, and adherence to governance standards
About Foilcon
IT Services and IT Consulting
1-10
At Foilcon, we are focused on delivering results to our clients. To be their go to partner for technical services, application developement, integration and training. This leads us to our goals of being a great partner and being the good guys.
With our global resources, we bring the rest of the world within reach to our customers.
Our nimble, experienced team moves from ideas to execution rapidly.
Our motto..There is always a way
About the role
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 & Data Lake Integration
- We're looking for a Senior Data Architect to design and lead the implementation of an enterprise-grade 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 AI-readiness across the organization. You'll work closely with stakeholders in Finance, HR, and IT to deliver a governed, future-proof data platform that powers cross-functional decision-making.
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, role-based access controls (RBAC) policies, privacy standards, and adherence to governance standards
- Leading the development of metadata-driven processes and data marts that power self-service analytics and executive reporting.
- Driving high-performance data solutions that are future-ready for AI, machine learning, predictive analytics, and enable PowerBI analytical reports
Required Skills & 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.
- Hands-on expertise with Azure Data Lake, Power BI, and cloud-based 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 self-service analytics.
- Excellent communication and stakeholder engagement skills across business and technical teams.
- Bachelor's or Master's 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, role-based access controls (RBAC) policies, privacy standards, and adherence to governance standards
About Foilcon
IT Services and IT Consulting
1-10
At Foilcon, we are focused on delivering results to our clients. To be their go to partner for technical services, application developement, integration and training. This leads us to our goals of being a great partner and being the good guys.
With our global resources, we bring the rest of the world within reach to our customers.
Our nimble, experienced team moves from ideas to execution rapidly.
Our motto..There is always a way