👷‍♀️ Position overview

As a Data Analyst/ Engineer Apprentice, you will be involved all along ELT-V (extract, load, transform, visualize) cycle in the modern data stack context, leveraging data to drive business growth, optimize processes, and enhance decision-making.

As a part of the Data team you will be halfway between tech and business and have a chance to build communication with all kinds of stakeholders, while evolving in a fast growing, highly collaborative and open to all your ideas environment.

🛠️ Your responsibilities

As a Data Analyst/ Engineer Apprentice, you will report directly to the Data Lead and:

• Guarantee the smooth functioning of all Data Platform architecture (data ingestion, storage and transformation tools)

• Contribute to the Data Platform development and tech debt reduction

• Enrich data collection in all levels following the star schema approach

  • Collect, clean, and organize large multisource datasets for various projects

  • Analyze data using statistical methods and data visualization techniques.

  • Ensure the quality and accuracy of the end-user datasets you are providing

• Develop end products as reports, dashboards, and data visualizations to communicate findings effectively.

• Contribute to the Colonies data culture development and “data as a product” vision

• Stay up-to-date with industry trends and best practices in data

🚧Your profile

You are studying in an Engineering school, and you are reaching your last year. You are studying data analytics and/or AI/ML.

You are totally confident with your SQL skills for complex models building and Python for ML, web scrapping, data engineering.

You have basic knowledge of modern data stack tools such as Fivetran, dbt, all Google Cloud Platform tools, Looker and Looker studio or their analogues.

You have a problem-solving mindset and ability to extract efficiently essential insights from complex datasets.

Resourceful and quick learner, never blocked by some missing skills or knowledge.

Autonomous in setting priorities and managing your daily workload.

You are able to present the result in a clear way to non technical stakeholders.

You have relational ease using French or English.

🔩 Our stack

• Cloud provider: Google Cloud Platform

• Data Warehouse: BigQuery

• Orchestration & Transformation: dbt Cloud

• Coding language: SQL, Python

• BI tool: Looker + Looker Studio

• Web Analytic tool: Heap

• Roadmap management: Jira

• Documentation: Notion

• Communication: Slack

🏗️ Typical day at Colonies

When starting your day, you will take some news from your remote colleagues on slack while drinking your coffee.

You check your ongoing sprint with your team to sync on any blockers.

Then come your first meeting of the day: you make a weekly project point with the finance team on the data accuracy and new KPIs to follow. You check with them to properly understand their needs, objectives and prioritize them in your current workload. You will then go to investigate the most optimal data model transformations and related requests you may have in the backlog, and organize your following planning.

You receive a Slack alert that there is an error on a connector. You check the ingestion tool and identify the source of the problem, sync with your team and communicate on possible impacts, and when the system will be back to normal. You then go back to your planned daily tasks.

End of day! Thanks for helping at improving Colonies business understanding to better serve our investors and tenants!