Freelance Analytics Engineer (Mid) – Data Optimization & Reporting at Colonies

Paris, Ile-de-France, France -

Full Time

Start Date

Immediate

Expiry Date

18 May, 26

Salary

0.0

Posted On

17 Feb, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Python, DBT, Fivetran, BigQuery, Snowflake, Looker, Data Modeling, Data Quality, KPI Documentation, Data Architecture, Data Governance, GenAI, Automation

Industry

Real Estate

Description

Company: Colonies Location: Remote / Paris (flexible) Contract: Freelance Duration: 8–14 weeks depending on scope Start date : ASAP About Colonies Colonies is a fast-growing real estate operator building and managing flexible living spaces across Europe. Data plays a central role in our operations, finance, and asset management decisions. We already have a modern data stack and several existing reporting tools (including Looker dashboards). We are now looking to rationalize, strengthen, and scale our data foundations to improve reliability, consistency, and usability across teams. About the project We are looking for a Mid-level Analytics Engineer to lead a short-term data optimization and structuring mission. The objective is not to build everything from scratch, but to audit, clean, and consolidate our current setup, improve data quality, and make our reporting more robust and scalable. Key responsibilities Audit and map existing data sources and flows Review current dashboards (Looker) and reporting logic Clean, structure, and harmonize datasets across tools Identify inconsistencies, gaps, and redundant processes Strengthen data models and reporting foundations Improve reliability and documentation of KPIs Collaborate closely with Finance, Asset Management, Ops, Sales, and Tech teams Recommend pragmatic improvements to data architecture, governance, and accessibility Profile 3–6 years experience as Analytics Engineer / Data Analyst / Data Engineer Strong SQL skills (Python is a plus) Experience with modern data stacks (DBT, Fivetran or similar, BigQuery/Snowflake, Looker or equivalent BI tools) Comfortable working with existing systems and improving them pragmatically Autonomous, structured, and business-oriented mindset Startup or fast-growing environment experience is a strong plus Experience using GenAI / automation tools to accelerate workflows is appreciated What we’re looking for Someone hands-on, pragmatic, and impact-driven who enjoys bringing clarity and structure to messy real-world data environments.

Responsibilities

The main responsibilities involve auditing, cleaning, and consolidating existing data setups, improving data quality, and strengthening data models to make reporting more robust and scalable. This includes reviewing current dashboards and harmonizing datasets across various tools.