ABOUT THE JOB YOU’RE CONSIDERING

As a BI Engineer, you will build and scale data models, pipelines, and self-service analytics across the organization
and highly loaded database solutions for various businesses cases including reporting, product analytics, marketing optimization and financial reporting.
You’ll focus on developing a reliable aggregation layer and reporting structure that meets growing business needs, enabling teams to access and analyze data independently. And contribute as part of self-organized team of experienced data engineers working in a challenging, innovative environment for our client, creating the foundation for decision-making at a company dealing with billions of events per day.
Investigate, create, and implement the solutions for existing technical challenges. Provide guidance, instruction, direction, leadership to a development team with the purpose of achieving project goals.

YOUR SKILLS AND EXPERIENCE

• University degree in Computer Related Sciences or similar.
• 8+ years of professional experience, 6+ years 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, 3 Nf, data vault)
• Proficiency in a programming language Python.
• Experience building reporting and dashboarding solutions using data lake/Snowflake or similar ecosystem
• Expert in Database fundamentals, SQL and performance tuning.
• Experience in maintaining data integrity and reliability by leveraging data quality frameworks and orchestration tools for seamless pipeline execution.
• Experience with modern data warehousing platforms (e.g., Snowflake, DataBricks, Redshift) and knowledge of data visualization tools (e.g., Looker, Tableau).
  Life at Capgemini

• Obtains tasks from the project lead or Team Lead (TL), prepares functional and design specifications, approves them with all stakeholders.
• Ensures that assigned area/areas are delivered within set deadlines and required quality objectives.
• Provides estimations, agrees task duration with the manager and contributes to project plan of assigned area.
• Analyzes scope of alternative solutions and makes decision about area implementation based on his/her experience and technical expertise.
• Leads functional and architectural design of assigned areas. Makes sure design decisions on the project meet architectural and design requirements.
• Addresses area-level risks, provides and implements mitigation plan.
• Reports about area readiness/quality, and raises red flags in crisis situations which are beyond his/her AOR.
• Responsible for resolving crisis situations within his/her 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.
• Own and define business KPIs, 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.
• Initiates and conducts code reviews, creates code standards, conventions and guidelines.