Job Openings BI Data engineer

About the job BI Data engineer

Mission Overview:

As a Keystone Solutions consultant, you will be deployed on a consultancy mission at our client to operate within the IT Front Data Management & Engineering area as a Data Engineer in the IT Front Data Team. You will support the projects Transparency, Arizona, Verdi, as well as BAU support tasks, delivering robust data foundations and solutions while collaborating closely with stakeholders. All responsibilities below will be performed under Keystone Solutions' consultancy model, working with the client's teams on site or in a hybrid setup as needed.


Consultancy Model at Keystone Solutions:

This is a consultancy role through Keystone Solutions. You will work on site at client locations (or hybrid, depending on client context) as a Keystone Solutions consultant, integrating with client teams while benefiting from Keystone's coaching, training, and community of experts. You will bring Keystone's standards of excellence, adaptability, and proactive communication to each engagement.


Key Responsibilities:

  • Support the projects: Transparency, Arizona, Verdi and BAU support tasks in the area of IT Front Data Management & Engineering.
  • Maintain existing jobs, fix failures, manage changes/releases, and support new onboardings.
  • Handle incident troubleshooting/root-cause analysis.
  • Orchestration & Automation.
  • Stakeholder collaboration.


Expected Deliveries:

  • Data Pipelines
  • Data Modelling & Storage
  • Complex SQL Qeuries
  • Tune SQL and jobs
  • Maintain existing jobs, fix failures, manage changes/releases, and support new onboardings.


Role and Responsibilities During the Mission:

  • Building and operating the data foundation that analytics, reporting depend on.
  • Build, maintain, and optimize batch/streaming pipelines (ingestion transformation serving).
  • Design schemas and models (e.g., dimensional, Data Vault), and manage & interrogate data lakes/warehouses (e.g. S3/ADLS + Redshift).
  • Handle incident troubleshooting/root-cause analysis.
  • Orchestration & Automation.
  • Stakeholder collaboration.


Required Knowledge and Technologies:

  • SQL (advanced)
  • Python
  • AWS (Glue, S3, Redshift)


Competencies:

  • Strong experience building and maintaining large-scale data pipelines and optimizing complex queries across big datasets. Hands-on Data Engineering, ETL/ELT pipelines, data ingestion, transformation, optimization, debugging & incident resolution.
  • Proven experience and ability working with project managers, business – and functional analysts, and source-system owners to clarify requirements and deliver datasets/data products.


Mindset and Working Style:

  • Positive mindset including a will-can-do mentality, ability to work independently and manage / prioritize his/her own work.
  • Efficient and transparent communicator, teamplayer. Demonstrate a proactive attitude.


Seniority and Experience:

  • Seniority expected: Senior
  • Years of Experience: 10 yr +


Languages:

  • Dutch: Nice to have
  • English: Full professional proficiency
  • French: Full professional proficiency


Role Alignment:

  • Roles: Senior Business Intelligence (BI) Engineer
  • Skills: AWS (Glue, S3, Redshift) – Level: Expert – Most recent experience: Any time
  • Skills: Python – Level: Expert – Most recent experience: Any time
  • Skills: SQL (advanced !) – Level: Expert – Most recent experience: Any time


Consultancy Advantages: Dynamic Projects

  • Work on diverse challenges across multiple client projects such as Transparency, Arizona, and Verdi, plus BAU initiatives—broadening your exposure to different data domains and architectures.
  • Engage with varied stakeholder groups and source systems, continuously refining your delivery and communication skills.


Consultancy Advantages: Turbo-Charged Learning and Development

  • Access Keystone Solutions' coaching, peer reviews, and knowledge-sharing to enhance mastery in SQL, Python, and AWS (Glue, S3, Redshift).
  • Stay sharp with evolving best practices in data modeling (dimensional, Data Vault), orchestration, and performance tuning across big datasets.


Consultancy Advantages: Ambition Skyrocketing within a Consultancy Framework

  • Accelerate your career through high-impact engagements, owning end-to-end responsibilities from ingestion to serving.
  • Demonstrate a proactive attitude and will-can-do mentality, taking on increasing responsibility across clients and platforms.


Keystone Solutions Values in Action

  • As a K-Stone, you embody transparent communication, reliability, and teamwork—bringing these values to every client engagement.
  • You collaborate efficiently, prioritize effectively, and deliver with integrity, ensuring stakeholder trust and consistent outcomes.


Application Questions to Address in Your Resume:

  • Tell me about a production data pipeline you built that failed. What was the root cause and what did you change to prevent it from happening again?
  • How do you design a data model when business requirements are unclear or keep changing?
  • How do you recognize that a SQL query or pipeline is poorly designed—and what's your approach to optimizing it?
  • PLEASE ANSWER THE ABOVE QUESTIONS IN YOUR RESUME

If you are ready to tackle technical and strategic challenges in a dynamic consultancy environment, apply today at Keystone Solutions Career Portal.


Or refer someone