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:
* 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 relevant 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.
#J-18808-Ljbffr