Jobs

Senior BI Analyst


Job details
  • Opus People Solutions
  • Ipswich
  • 2 weeks ago

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 delivery or our data strategy, including supporting data-driven decision making processes across the organisation, optimising internla 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:

2 years experience in an analytical role with exposure to statistical analysis and data modelling techniques, and be comfortable with large datasets (Essential)

Experience in SQL, PowerBI, Python (Essential)

Will have advanced Excel skills (Essential)

Degree-educated in a relavant subject (Desirable)

Experience with Git operations, GitHub copilot and CI/CD flows (Desirable)

Will be an effective communicator and able to work with stakeholders cross-functionally
Knowledge of cloud computing platforms, in particular Azure Databricks, ETL and ELT processes, as well as experience with big data technologies and frameworks a plus

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Senior BI Analyst

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 delivery or our data strategy,...

Ipswich

Senior BI Analyst

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 delivery or our data strategy,...

Opus People Solutions Ipswich

Senior Business Intelligence Analyst

Job Title: Senior BI AnalystLocation: DublinSalary: €(phone number removed)HybridReperio are working with a multi-national company in the sports industry who are seeking a skilled Senior BI Analyst to join their Insights and Data team here in Ireland. The successful candidate will work closely with key stakeholders to understand business needs,...

Dublin

BI Analyst

Job Title: BI AnalystSalary: £35,000 - £55,000 DOELocation: Cambridge - 2 days a week onsiteThis role as a BI Analyst is within the Consultancy service provision of the company working as part of growing team developing strategic estate planning models, Bespoke BI solutions and Project management.The analyst will work on...

Cambridge

BI Analyst

Job Title: BI AnalystSalary: £35,000 - £55,000 DOELocation: Manchester City Centre - 2 days a week onsiteThis role as a BI Analyst is within the Consultancy service provision of the company working as part of growing team developing strategic estate planning models, Bespoke BI solutions and Project management.The analyst will...

Manchester

BI Analyst

Job Title: BI AnalystSalary: £35,000 - £55,000 DOELocation: Birmingham - 2 days a week onsiteThis role as a BI Analyst is within the Consultancy service provision of the company working as part of growing team developing strategic estate planning models, Bespoke BI solutions and Project management.The analyst will work on...

Birmingham