Sr. Data Engineer

  • Full Time
  • Ottawa


Capgemini Engineering combines, under one brand, a unique set of strengths from across the Capgemini Group: the world leading engineering and R&D services of Altran – acquired by Capgemini in 2020 – and Capgemini’s digital manufacturing expertise. With broad industry knowledge and cutting-edge technologies in digital and software, Capgemini Engineering supports the convergence of the physical and digital worlds. Combined with the capabilities of the rest of the Group, it helps clients to accelerate their journey towards Intelligent Industry. Capgemini Engineering has more than 52,000 engineer and scientist team members in over 30 countries across sectors including aeronautics, automotive, railways, communications, energy, life sciences, semiconductors, software & internet, space & defence, and consumer products.Job Title: Senior Data EngineerType: FTELocation: Remote/Toronto, ON / Vancouver, BCAs a Senior Engineer, you will build distributed data processing solution and highly loaded database solutions for various businesses cases including reporting, product analytics, marketing optimization and financial reporting. 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.Responsibilities: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.Initiates and conducts code reviews, creates code standards, conventions and guidelines.Suggests technical and functional improvements to add value to the product;Constantly improves his/her professional level.Collaborates with other teams.Required Skills:Must have:5+ years of professional experienceUniversity degree in Computer Related Sciences or similar3+ years experience working in data engineering, business intelligence, or a similar roleProficiency in programming languages such as Python, or Java, or Scala3+ years of experience in ETL orchestration and workflow management tools like Airflow, or OozieExpert in Database fundamentals, SQL and distributed computing3+ years of experience with the Distributed data/similar ecosystem (Spark, Hive, Presto) and/or streaming technologies such as Kafka/Flink.Experience working with Snowflake, Redshift, PostgreSQL and/or other DBMS platformsExcellent communication skills and experience working with technical and non-technical teamsNice to have:Knowledge of reporting tools such as Tableau, Superset and LookerComfortable working in fast paced environment, self starter and self organizingThis company is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.