Senior BI Developer

Harnham - Data & Analytics Recruitment; Birmingham; Hybrid; GBP 48,000; Full time

Job summary

An established industry player in insurance and finance is seeking a Senior BI Developer to enhance their data systems and reporting capabilities. In this pivotal role, you will collaborate with a dedicated data team, guiding the delegation of tasks and improving data flow. Your expertise in SQL, Power BI, and ETL processes will be crucial in rebuilding legacy reporting systems and creating visually compelling dashboards. This position offers a hybrid work arrangement, allowing you to balance in-office collaboration with remote flexibility. If you are passionate about data and enjoy working in an Agile environment, this opportunity is perfect for you.

Qualifications

• Strong experience in SQL for data querying and manipulation.
• Proven experience building Power BI reports with a strong eye for visual storytelling.

Responsibilities

• Data mapping and working with various data sources for seamless integration.
• Developing and optimizing SQL queries to pull data from disparate data warehouses.

Skills

SQL

SSIS

Azure Data Factory

Power BI

Tableau

Stakeholder Communication

Agile Methodologies

BI Engineering

BI Development

Job description

Job Description

Job Title: Senior BI DeveloperSalary: £48,000Location: West Midlands Work Arrangement: hybrid - 1 day week in office

About the Company:

A UK-based insurance and finance company are looking to bring a Senior BI Developer onto their team.

Role Overview:

In this position you will play a crucial role in helping to redesign and improve the flow of data within the company. You will be working alongside a dedicated data team. While there are no direct line management responsibilities, you will be expected to lead the delegation of tasks and guide the team's workflow.

The role will also involve collaborating with a range of stakeholders across product, solution design, and IT, focusing on improving data systems and reporting capabilities.

Key Responsibilities:

• Data mapping and working with various data sources to ensure seamless integration into new systems.
• Rebuilding legacy reporting and redesigning data structures for better insights.
• Developing and optimizing SQL queries to pull data from disparate data warehouses.
• Building and maintaining SSIS pipelines or Azure Data Factory (ADF) to support ETL processes.
• Creating visually appealing reports and dashboards using Power BI
• Communicating with stakeholders-ensuring clarity in data-related discussions and helping them interpret insights effectively.
• Working in an Agile environment, contributing to iterative development cycles.

Skills and Experience:

• Strong experience in SQL for data querying and manipulation.
• Familiarity with SSIS or Azure Data Factory for building ETL pipelines.
• Proven experience building Power BI reports with a strong eye for visual storytelling (Tableau also acceptable).
• Comfortable working with disparate data sources and integrating data across multiple systems.
• Excellent stakeholder communication skills-ability to explain technical concepts to non-technical audiences.
• Experience with Agile methodologies.
• A background in BI Engineering or BI Development.

Assessment Process:

1. Online Assessment: 1-hour test covering general quantitative and inductive reasoning.
2. Interview: Skills-based interview, including a presentation where you'll discuss your approach to a typical project and how you would tackle key challenges in the role.