Task description and requirements
The Astek Group
Founded in France in 1988, Astek is a global player in engineering and technology consulting. With its expertise in various industrial and tertiary sectors, Astek supports its international clients in the intelligent deployment of their products and services, as well as in the implementation of their digital transformation.
Since its inception, the Group has based its development on a strong culture of entrepreneurship and innovation, and on the support and upskilling of its 7800 employees who are committed every day to promoting the complementarity between digital technologies and complex system engineering.
In Canada, the firm specializes in IT consulting services and engineering. Our teams successfully drive our clients' development strategies. Around common values, we have gained their trust and address their business challenges by putting their needs at the center of our actions and priorities.
This ecosystem of expertise enables Astek Canada to adapt quickly to evolving technologies, and all employees participate collaboratively in their development.
Are you ready to take on a new challenge, give your career a boost, and participate in innovative and stimulating projects?
Join a rapidly growing Group in Canada and worldwide that achieved a turnover of €600 million in 2023.
Your mission would be:
• Design and implement data models and schemas to support analytical reporting requirements, reports, and dashboards, manage data model and data pipelines.
• Build Analytics and provide support on aspects such as data model changes and security configuration.
• Enable Fusion Analytics Warehouse (FAW) augmentation to support external data integration with other data platforms.
• Collaborate with data engineers and ETL developers to design, implement, and optimize data integration processes for loading data from various source systems into the Oracle Fusion Analytics data warehouse.
• Monitor and optimize the performance of the Oracle FAW, including database queries, data pipelines, and system resources.
• Identify and address performance bottlenecks and optimization opportunities. Requires close collaboration with Oracle product support team.
• Implement data modeling best practices and standards to ensure data consistency and integrity.
• Provide data modeling expertise and support to cross-functional teams.
• May prepare or review product documentation, written instructions or technical literature for accuracy and completeness.
• Participate in the fulfillment of ad-hoc data requests from internal business owners.
• Participate and guide vendor teams in implementing solutions to fit current architecture.
Your tech stack:
• Bachelor’s degree in computer science, Information Systems, or related field.
• Proven experience in data modeling, database design, and data architecture.
• Implementation experience in FAW, at least one implementation experience preferred.
• Excellent analytical and problem-solving skills. (mandatory).
• Functional understanding of Oracle Fusion Applications (ERP and EPM modules).
• Ability to communicate complex technical concepts to non-technical stakeholders.
• Good analytical skills.
• Excellent SQL query and debugging skills.
Your profile:
• Bachelor’s degree in computer science, Information Systems, or related field.
• Proven experience in data modeling, database design, and data architecture.
• Implementation experience in FAW, at least one implementation experience preferred Excellent analytical and problem-solving skills.
• Functional understanding of Oracle Fusion Applications (ERP and EPM modules).
• Ability to communicate complex technical concepts to non-technical stakeholders Good analytical skills.
• Excellent SQL query and debugging skills.
• Experience in Oracle Autonomous data warehouse (ADW), Oracle Analytics Cloud (OAC), Data Modelling, Oracle SQL Developer, Data warehouse, analytics, and advanced analytics concepts.
• Strong knowledge of SQL, database management systems, and data modeling tools.
• Excellent problem solving, debugging, performance tuning skills.
Let's meet!
Do you like our common project?
Apply here and join our team!
Our Advantages:
• A tailored CARE policy deployed by our HR teams for our employees.
• Our Diversity Charter.
• Activities among colleagues such as Teambuilding or Happy Hours.
