About the Job You’re Considering
Location\: Canada (Toronto, Ontario, Montreal, Vancouver)
Capgemini Engineering seeks a Sr. Business Intelligence Engineer to develop database solutions for reporting and analytics. The objective is to establish a flawless data aggregation layer and reporting structure that satisfies our expanding business requirements. You will empower teams to access and analyze data independently, contributing as part of a self-organized team of seasoned data engineers. You will work in a stimulating and inventive environment, crafting the foundation for decision-making at a company handling billions of events per day. Investigate, build, and successfully implement solutions for existing technical challenges, while offering mentorship, instruction, direction, and leadership to achieve project goals.
Your Role
- Acquire tasks from the project lead or Team Lead (TL), prepare functional and design specifications, and approve them with all collaborators.
- Ensure assigned areas are delivered within set deadlines and required quality objectives.
- Provide estimations, agree on task duration with the manager, and contribute to the project plan of assigned areas.
- Analyze the scope of alternative solutions and make decisions about area implementation based on experience and technical expertise.
- We lead functional and architectural design of assigned areas, ensuring design decisions meet architectural and design requirements.
- Address area-level risks, provide, and implement mitigation plans.
- Report about area readiness/quality, and raise red flags in crisis situations beyond AOR and resolve crisis situations within AOR.
- Design, develop, and maintain robust data models to support analytical and product data needs across the organization.
- Implement and optimize ETL/ELT processes to ensure data quality, reliability, and performance.
- We take ownership of and define critical metrics for the business, including their measurement plans, data requirements, and reporting.
- Design, develop, and implement large-scale, high-volume, high-performance data models and pipelines for Data Lake and Data Warehouse.
- Initiate and conduct code reviews, build code standards, conventions, and guidelines and suggest technical and functional improvements to add customer value to the product.
- Collaborate with other teams to achieve project goals.
Your Skills and Experience