At FDJ United, data and analytics are crucial to our growth and innovation as we expand into new markets. We are seeking a Cloud Data Engineer to join our Automaton and Insights (A&I) team. In this role, you will support the development and maintenance of our clickstream data architecture on AWS, helping ensure the generation of high-quality datasets that accurately reflect customer behaviour across various digital platforms.

You will work with cutting-edge technologies, including Snowplow for event tracking, Apache Iceberg as our central data lake, dbt Spark for scalable data transformations, and ClickHouse for high-performance analytics, alongside Open Metadata for data governance.

Working closely with Python Developers and Analysts, you'll help enable the creation of self-serve analytics dashboards that empower teams across the business to generate actionable insights and improve decision-making. If you're passionate about growing your skills in cloud data engineering and eager to learn how data shapes customer understanding, we invite you to start your career journey with us at FDJ United.

Responsibilities:

- Design and implement dbt data models that support decision-making, marketing insights, product reporting, and ad-hoc analysis across the business.

- Build and maintain schemas to enable automated data processing workflows, leveraging Apache Iceberg as the central data lake.

- Develop and optimize data transformations with dbt Spark, ensuring models are reliable, reusable, and well-documented.

- Enhance self-serve analytics by developing well-structured, performant ClickHouse tables that serve as the foundation for business dashboards and reporting.

- Define and maintain a semantic layer that standardizes business metric definitions, enabling consistency for natural language querying tools and self-serve analytics.

- Collaborate on exploratory projects, including proof-of-concept generative AI initiatives, applying engineering expertise to evaluate and integrate emerging technologies.

- Document and share best practices for data transformation and modeling, promoting effective use of Snowplow, dbt, and related tools across the organization.

- Stay curious and proactive in learning about advancements in data engineering, cloud platforms, and AI technologies, bringing fresh ideas to the team.

What will you need?

- Practical experience with data transformations, including working with SQL and Python to manipulate and prepare datasets.

- Exposure to data modelling concepts and some hands-on experience building models in dbt, with an eagerness to strengthen these skills.

- Interest in learning about clickstream data and event-driven architectures, with some familiarity considered a plus.

- Familiarity with cloud platforms such as AWS, and a willingness to deepen knowledge in DevOps and automation practices.

- Awareness of governance frameworks and data catalogues, with an interest in supporting documentation and metadata management.

- Strong working knowledge of SQL and confidence in writing efficient queries.

- Solid programming skills in Python.

- A proactive, growth-oriented mindset with the ability to adapt to ambiguity and learn through iteration. Excellent communication skills to work with senior engineers and analysts, translating business requirements into technical specifications for data models.

Additional experience that would be beneficial

- dbt certification and hands-on experience developing production-grade dbt models.

- 2+ years of experience with Airflow or other orchestration frameworks.

- Experience with modern data stack components such as Spark, Kafka or Iceberg.

- Experience working with large-scale columnar databases (e.g., ClickHouse, Redshift, BigQuery) and performance tuning for analytical workloads.

Ensure that you adhere to the Governance, Risk & Compliance (GRC) obligations for your role.

• Identify and raise any non-compliance incidents promptly to your line manager.
• Challenge processes, policies and projects that will negatively impact compliance within the Group.
• Complete all mandatory compliance training assigned to you.

 Reach out to the Compliance Teams if unsure of any of your compliance obligations or the requirements are unclear.