Sr. Business Intelligence Engineer at Capgemini
Toronto, ON, Canada -
Full Time


Start Date

Immediate

Expiry Date

02 Sep, 25

Salary

0.0

Posted On

03 Jun, 25

Experience

6 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Business Intelligence, Scala, Data Engineering, Data Analytics, Reliability, Python, Dimensional Modeling, Communication Skills, Sql, Performance Tuning, Data Vault, Data Integrity

Industry

Information Technology/IT

Description

YOUR SKILLS AND EXPERIENCE

  • 8+ years of professional experience.
  • University degree in Computer Related Sciences or a similar field.
  • 6+ years of experience working in business intelligence, data analytics, data engineering, or a similar role.
  • Strong SQL skills and experience with data modeling techniques (e.g., dimensional modeling, 3Nf, data vault).
  • Proficiency in a programming language such as Python or Scala.
  • Experience building reporting and dashboarding solutions using data lake/Snowflake or a similar ecosystem.
  • Expert in database fundamentals, SQL, and performance tuning.
  • Experience in maintaining data integrity and reliability by bringing to bear data quality frameworks and orchestration tools for seamless pipeline execution.
  • Excellent communication skills and experience working with technical and non-technical teams.
  • Comfortable working in a fast-paced environment, self-starter, and self-organizing.
  • Ability to think strategically, analyze, and interpret market and consumer information.
Responsibilities
  • 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.
Loading...