Senior BI Analyst

We are looking for a Senior Business Information Analyst to join our client working in Mayfair, London. 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 AccountabilitiesData 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