Analytics Engineer

• Embed directly in the Assets team to automate investor reporting currently done by hand
• First mission is CRG reporting: understand the manual process, identify every data source involved, get them clean and modelled in dbt/BigQuery stack, and build the reporting apps on top (most likely in Hex)
• Map the current manual CRG reporting workflow with the Assets team and identify gaps in available data
• Add, clean, and model new data sources into the dbt transformation layer (Stripe, Qonto, Pipedrive, MS Postgres, Zendesk, among others)
• Build shared dbt marts that serve as the backbone for all downstream analytics
• Develop CRG reporting apps and investor-facing dashboards in Hex, tailored per investor where required
• Reconcile data across sources (financial transactions, occupancy, operational costs) and build tests to keep it trustworthy
• Set up alerting and data quality monitoring (dbt tests, Elementary → Slack)
• Once CRG reporting is live, extend to other high-impact data projects: budget dashboards, a KPI data room, and whatever the business needs next
• Report into the Core Tech team for standards and tooling, but day-to-day spent with the Assets team

• Strong in SQL and dbt
• Experience building and maintaining transformation layers in a production analytics stack (ideally on BigQuery or similar)
• Experience building data apps or interactive reports (Hex experience a plus, similar tools like Streamlit, Retool dashboards, Metabase, Looker count)
• Can write Python for data wrangling, reconciliation scripts, and light automation
• Experience with data reconciliation work (matching transactions across systems, finding discrepancies, building processes to keep data aligned)
• Understand the analytics engineering workflow (sources → staging → marts → consumption layer, with testing and documentation)
• Use AI tools (Copilot, Claude, Cursor, etc.) as part of daily workflow
• Can sit with non-technical stakeholders, understand their reporting needs, and translate that into a data model and a finished app
• Comfortable with ambiguity
• Bias for action and a proven track record of building data products people actually use
• Fluent in French and English

Hex experience