BI Developer

Lorien; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

Lorien is seeking a BI Developer / Analytics Engineer to design and deliver dashboards with Amazon QuickSight, ensuring reliable data pipelines and insightful analytics for business stakeholders. You will bridge backend data processing with frontend visualization, working with SQL-driven transformations and AWS services.

The role emphasizes creating clear KPIs and dashboards, collaborating with cross-functional teams, and operating in a hybrid London setting with on-site presence 2–3 days per

Qualifications

• Experience building dashboards and translating business needs into visual, actionable insights.
• Strong command of Amazon QuickSight for interactive dashboards and storytelling with data.
• Solid SQL skills for data wrangling, transformation, and dataset preparation.

Responsibilities

• Design, develop, and deliver dashboards using Amazon QuickSight.
• Wrangle and transform data with SQL to prepare datasets for analysis.
• Connect to diverse data sources and AWS cloud data services (S3, Athena, Redshift, Glue).
• Translate business needs into KPIs, charts, and narratives for stakeholders.
• Collaborate with business users to gather requirements and specifications.

Skills

Dashboard development

Data visualization

Communication

Cross-functional collaboration

Tools

Amazon QuickSight

SQL

Python

AWS services

Job description

BI Developer / Analytics Engineer - Amazon Quick Sight

About the Role

We are looking for a skilled BI Developer / Analytics Engineer to join a team focused on creating comprehensive dashboards and robust data pipelines. This is a great opportunity for someone with strong expertise in dashboard development, data transformation, and analytics who can bridge the gap between backend data processing and frontend visualization — ensuring operational teams have access to reliable, actionable insights.

Key Responsibilities

• Design, develop, and deliver user-friendly, visually compelling dashboards, primarily using Amazon QuickSight.
• Execute complex data wrangling, cleaning, and transformation tasks, primarily using SQL, to prepare datasets for analysis.
• Discover, connect to, and process data from a variety of sources, combining traditional relational databases with modern AWS cloud data services (e.g. S3, Athena, Redshift, and Glue).
• Translate business needs for data presentation and narrative into non-technical KPIs, charts, and dashboards.
• Work closely with business stakeholders to gather, understand, and translate requirements into technical specifications.

Required Skills & Experience

• Professional background as a BI Developer, Analytics Engineer, Data Analyst, or similar role involving dashboard development.
• Proven expertise in dashboard creation and development, with deep practical experience and a strong command of Amazon QuickSight essential for this role.
• Extensive experience in advanced SQL for data manipulation and transformation across complex datasets.
• Solid understanding of data engineering concepts (e.g. ETL pipelines, data quality, and governance).
• Experience with Python for data processing, automation, and other analytics workflows where applicable.
• Strong communication skills and the ability to work collaboratively with cross-functional teams.
• Duration: 6 months
• IR35 Status: Inside IR35
• Working Pattern: Hybrid — 2 to 3 days per week on-site in London