BI Consultant – Data Modeling & ETL Specialist

About the role

The Business Intelligence Consultant will design, build, and maintain robust data models and transformation pipelines that power reliable reporting and analytics. Working within the Product Research & Development department, you will collaborate closely with BI developers and business stakeholders to translate requirements into performant, scalable data solutions.

Key responsibilities

• Write, maintain, and continuously optimise SQL‑based code for data transformation and reporting.
• Design, build, and maintain relational data models (facts, dimensions, star/snowflake schemas) to support BI use cases.
• Develop, monitor, and enhance ETL processes that ingest and transform data from multiple sources.
• Validate and test data pipelines to ensure high data quality and integrity.
• Document data models, transformations, and business logic for transparency and reuse.

Required profile

• Strong analytical mindset with a detail‑oriented approach to data quality and documentation.
• Excellent collaboration skills to work with both technical and non‑technical stakeholders.
• Problem‑solving attitude focused on continuous improvement of data processes.

Required skills

• SQL (performance tuning and scalable query design).
• Relational data modeling (facts, dimensions, star/snowflake schemas).
• ETL process design and maintenance.
• Data validation, testing, and troubleshooting.