Senior BI Analyst

TN United Kingdom; Ipswich; Hybrid; GBP 40,000 - 65,000; Full time

Job summary

An established industry player is seeking a Senior Business Information Analyst to enhance their data strategy in a hybrid work environment. This role involves collaborating with data engineers to manage and analyze data from various sources, optimizing internal processes, and supporting data-driven decision-making. You will create interactive dashboards and reports using PowerBI, translating complex data into actionable insights for stakeholders. If you have a strong analytical background and are passionate about leveraging data to drive business outcomes, this is an exciting opportunity to make a significant impact.

Qualifications

• 2+ years in an analytical role with data modelling techniques.
• Experience with SQL, PowerBI, and Python is essential.
• Effective communication and cross-functional collaboration skills.

Responsibilities

• Collaborate with data engineers to gather and organize data.
• Apply statistical techniques to analyze client data.
• Design and maintain interactive dashboards using PowerBI.

Skills

Statistical Analysis

Data Modelling

SQL

PowerBI

Python

Advanced Excel

Effective Communication

Cloud Computing

Education

Degree in a relevant subject

Tools

PowerBI

SQL

Git

GitHub Copilot

Azure Databricks

Job description

Social network you want to login/join with:

We are looking for a Senior Business Information Analyst to join our client working in Ipswich, Suffolk. This client is working a hybrid model and you can expect to report to the office 2/3 times a week. The purpose of this role is to help deliver our data strategy, including supporting data-driven decision-making processes across the organisation, optimising internal processes, and assisting with management information reports.

Key Accountabilities

Data Collection and Management

• Collaborate with data engineers to gather and organize data from various sources, both internal and external, including cloud-based platforms and on-premises databases such as SQL, Microsoft Dynamics, MongoDB, GA4, BigQuery, and third-party connectors.
• Use SQL to query and manipulate large datasets efficiently, helping design schemas and tables within the data lake's medallion architecture.
• Ensure data accuracy and consistency by cleaning, validating, and preprocessing datasets, addressing issues like missing data, outliers, and duplicates.
• Continuously expand a multi-layered reporting structure, integrating transactional, product, contact, and account-related datasets to deliver a comprehensive customer view for both technical and non-technical stakeholders.
• Ensure compliance with data privacy and security regulations, including GDPR and CCPA.

Data Analysis and Insights

• Apply statistical techniques to analyze client and prospect data, identifying key patterns, trends, and anomalies to support strategic decision-making and commercial outcomes.
• Develop client segments based on demographics, transactions, engagement levels, and other factors, creating tailored personas for deeper customer understanding.
• Create detailed profiles of customer groups, highlighting preferences, needs, and pain points.
• Analyze client feedback and survey data, correlating it with digital engagement and transactional metrics to identify areas for improvement.
• Build predictive models to forecast client behavior, including responses to marketing campaigns, churn, service changes, and customer movement within service tiers.

Data Visualization and Reporting

• Design and maintain interactive dashboards and reports using PowerBI, supporting the migration and reconfiguration of SSRS reports into PowerBI dashboards.
• Translate complex data into clear and actionable visualizations for stakeholders.
• Contribute to the creation and refinement of reporting style guides to ensure alignment with brand identity and best practices.

Stakeholder Collaboration and Support

• Collaborate closely with data engineers to ensure seamless data flow and work with data scientists on advanced analytics, predictive modeling, AI, and machine learning projects.
• Work with cross-functional teams, including advisers, product development, IT, and marketing, to ensure data insights shape future product strategies.
• Partner with stakeholders to identify and address pain points, optimizing processes to scale the business, reduce costs, and enhance client satisfaction.
• Participate in a data analyst rotation program, working within various business units to provide technical expertise, training, and support in accessing, interpreting, and visualizing data for reporting and analytics, fostering a collaborative and innovative data culture.

Skills & Qualifications required:

• At least 2 years of experience in an analytical role with exposure to statistical analysis and data modelling techniques, and comfortable working with large datasets (Essential)
• Experience in SQL, PowerBI, Python (Essential)
• Advanced Excel skills (Essential)
• Degree in a relevant subject (Desirable)
• Experience with Git operations, GitHub Copilot, and CI/CD flows (Desirable)
• Effective communication skills and ability to work cross-functionally with stakeholders
• Knowledge of cloud computing platforms, particularly Azure Databricks, ETL and ELT processes, and experience with big data technologies and frameworks is a plus