BI Reporting Analyst - Very Strong SQL User
On site
London, United Kingdom
£ 38 / hour
Freelance
21-03-2025
Job Specifications
BI Reporting Analyst - Very Strong SQL User
4-Month Contract
Day rate: £280/day inside IR35
Location: London UK
Start: ASAP
We are seeking a highly motivated and experienced Data Analyst to join a dynamic Customer Success team on a 4-month contract. This role requires a strong technical background, especially in SQL, as you will be expected to demonstrate your SQL proficiency during the interview process. You will be responsible for developing and maintaining dashboards that focus on analysing revenue-generating activities and customer experience metrics. You will collaborate closely with key business stakeholders to create user-friendly, executive-level dashboards that provide actionable insights.
Day to Day:
Maintain Digital Recommendations reporting and add new use cases.
Support the CS analytics team on experiments related to revenue-generating activities.
Maintain Agent Recommendations reporting and provide insights to the Growth & Retention teams.
Improve Retention reporting to reflect revenue metrics.
Support the transition of data structures from the existing market model to a new regional model.
Support Growth & Retention business reviews with insights to enhance revenue-generating programs.
Create dashboards to visualize end-to-end customer journeys, supporting improvements in the Customer Experience.
Key Responsibilities:
1. Dashboard Development:
Design and build interactive, intuitive dashboards to monitor retention and revenue-generating activities.
Develop and maintain scalable ETL processes to integrate data and support dashboard creation.
Utilize SQL and Python to query databases, perform data manipulation, and automate analysis.
2. Experimentation:
Support the Growth & Retention teams by analysing and reporting on A/B testing results.
Provide historical data for key metrics to establish baseline performance and experiment targets.
3. Collaboration:
Work closely with Customer Success, Sales, and Marketing teams to understand reporting needs and refine dashboard functionalities.
Present data-driven insights to business stakeholders and executives in a clear, concise manner.
4. Quality Assurance:
Ensure data accuracy and integrity by implementing best practices in data governance and quality control.
Troubleshoot and resolve any data-related issues quickly.
Technical Skills:
Strong expertise in SQL for reporting, querying, data manipulation, and ensuring robust data solutions. This skill will be rigorously tested during the interview process.
Proven experience in building dashboards using tools such as Tableau, Qliksense, or similar platforms.
Familiarity with ETL processes and tools.
Experience with A/B testing methodologies and analysis.
Industry Experience:
Experience with call center data, including understanding relevant metrics and KPIs.
Familiarity with web data and digital support tools, along with associated KPIs.
About the Company
RedCat Digital is a digital-focused recruitment agency with a difference. Our values of fair, informed, trusted inform every decision we make. Those principles have led us to 22 years of successful, partnership-driven relationships with our candidates and clients. We know that recruitment is not a one-dimensional, quick-fix process. That's why we have solutions for every stage, designed to suit your business needs. Whether that's a specific key hire, an entire team, a solution required for a statement of work or anything ... Know more
Related Jobs
- Company Name
- Subsea7
- Job Title
- SCM Data Analyst
- Job Description
- Subsea7 is seeking a SCM Data Analyst to join our team on an initial 6-month contract. We are open to applicants from Aberdeen, London or Paris. As a business, Subsea7 produces vast amounts of data which play an important role in supporting the way we work. With ever increasing importance placed on data analytics, the need to ensure this data is managed and governed appropriately is critical to deliver predictable performance. Working closely with the SCM Director of Governance and Sustainability, the Group SCM Data Analyst will support the SCM Function by identifying and co-ordinating the visualisation of all material SCM data globally. A key aspect of the role will be the analysis and trending of data, looking for opportunities for business improvement and to change the way that we deliver our work. The successful candidate will have an impact on our business at a Group level, raising awareness of how our Company operates and critically how we can improve our competitiveness. We are looking for someone who is self-motivated, keen to learn and take on more responsibility and able to work autonomously. Although the role is focused on SCM data analysis, there will be opportunities to support other Group SCM activities. What will you be doing? Interact with IT and SCM Corporate to support request for processing, manipulation and examination of SCM data from various sources into consolidated and user-friendly formats and reports. Extract information from data sets to identify correlations and patterns, using statistical or AI tools. Provide data analysis from SAP and other digitalisation-related systems deployed across SCM. Support the business in reaching their targets and performance metrics, including but not limited to Sustainability objectives, by coordinating supplier screening efforts. Support the business in the adoption of common codification for procurement and logistics activities. Collaborate with the Data Governance team to ensure SCM data accuracy and integrity. Sustainability data Develop and improve Sustainability data registers and dashboards by domain (Business Ethics, Human Rights & Labour practices, Green House Gas Emissions, Environment) and Regions/Business Units. Contribute to the preparation and coordination of all material Environment, Social and Governance (ESG) reporting disclosures and data collection to meet compliance and regulatory requirements, as well as clients and other stakeholders. Performance Monitoring Cash Management: Work with Finance to monitor global SCM payment terms and explore opportunities to optimise our cash management by Regions/Business Units and type of activity. Productivity: Develop and track global and regional indicators by type of activity. Enable Global Process Owners to reap the benefits of digitalisation. Cost of Loss & Knowledge Management: Analyse Cost of Loss (COL) and Supplier Performance Issues (SPI) data associated to SCM activities and ensure that key learnings and takeaways are properly captured and disseminated across the SCM organisation. Compliance Process compliance: Analyse process deviation indicators and similar compliance indicators to monitor our process compliance globally and by Regions/Business Units. Data governance : Verify and confirm data quality assurance through the application of our internal data governance process. Support SCM data steward and data owner and interface with other data stewards from other disciplines. Codification: Enhance buyer’s PO by checking, correcting and guiding buyers in using codification in S4 Hana. Create and maintain S4 Hana SCM internal catalogues and train the team in its usage. What experience would we like you to have? A bachelor’s degree in business analysis, data sciences or related subject. Strong experience in business analysis or a related field. Ideally in procurement or digital project delivery environments. Experience in creating detailed reports and giving presentations. Accomplished analytical skills and ability to work with detail and high accuracy Knowledge of Enterprise Architecture (ideally SAP S4 Hana) Competency in Microsoft applications including PowerBI and Teams Collaborative team worker who also demonstrates initiative and strong accountability
- Company Name
- Experis IT
- Job Title
- Applied Scientist – Microsoft 365 Copilot (AI & Large Language Models), Python Developer, PHD
- Job Description
- Job Title: Applied Scientist – Microsoft 365 Copilot (AI & Large Language Models) Overview: The team is on the cutting edge of AI innovation, creating and delivering groundbreaking solutions for Microsoft 365 Copilot. We are integrating intelligent, natural language capabilities across all Microsoft 365 apps, empowering users with tools that boost their productivity and efficiency. As an Applied Scientist, you’ll play a critical role in shaping the future of AI-powered productivity by developing advanced features in search and recommendations within Microsoft 365 Copilot. You will have the opportunity to leverage your expertise in AI and ML to create innovative solutions that impact millions of enterprise users worldwide. Responsibilities: Leverage cutting-edge techniques to fine-tune Large Language Models (LLMs) for enterprise users of Microsoft 365 Copilot. Perform offline evaluations of fine-tuned models, measuring relevance, clarity, perceived intelligence, groundedness, and more. Deploy and monitor fine-tuned models in live environments to ensure they deliver value to all enterprise users. Systematically document and analyze your fine-tuning approach, with the aim of publishing your work at leading AI conferences. Continuously look for opportunities to improve product quality, experimenting with new approaches and ideas. Required Qualifications: Enrolled in an ongoing PhD program in Machine Learning, Natural Language Processing, or related fields, with a focus on Large Language Models. Python Development At least 2 years of experience in ML/NLP or a strong publication record. Python development Strong problem-solving and data analysis skills, with hands-on experience in developing or applying machine learning algorithms at scale. A growth mindset, and a passionate advocate for diversity and inclusion in the workplace. Deeply customer-centric with a focus on impactful product development. Excellent verbal and written communication skills, with the ability to explain complex concepts clearly to a wide audience. Preferred Qualifications: Hands-on experience applying Language Models and Transformers to real-world problems. A robust publication record in top-tier AI conferences or journals.
- Company Name
- Trispoke Managed Services Pvt. Ltd.
- Job Title
- Power Bi Developer
- Job Description
- Job Title: Power Bi Developer Job Overview We are seeking an experienced and passionate hands-on Business Intelligence (BI) Engineer to support the design and implementation of new features, as well as modify and maintain existing systems in response to business and technology changes. This role is integral to establishing a data-centric organization and ensuring the success of our BI program. You will be part of a small, highly skilled team, providing best-in-class solutions to our global user base. Roles & Responsibilities We are looking for a highly capable, enthusiastic, and experienced individual to join our team. The BI Engineer will be responsible for designing and building BI capabilities by developing technically sound and forward-looking solutions that present data intuitively. Reporting to the VP of BI, the BI Engineer will play a key role in owning the technical aspects of BI solutions. As part of a growing team, the ideal candidate will be comfortable analyzing, designing, and implementing dashboards with the necessary processes and controls. Strong comprehension of Azure cloud services and previous experience supporting enterprise-wide dashboard deployments. Advocate for data visualization and a results-driven professional passionate about innovation and establishing a data-centric organization. Key Responsibilities Deliver complete Power BI solutions. Design intuitive, interactive dashboards with engaging visualizations. Collaborate with business users and stakeholders to deliver optimal solutions. Provide technical expertise in data acquisition, dataset modeling/development, and report production. Promote best practices and effective use of BI tools within the team. Work closely with business teams to understand and develop BI requirements. Collaborate with Azure Data Engineering colleagues to build underlying data architecture using Data Bricks & Data Lake. Analyze data stores and recommend improvements to enhance data reliability, efficiency, and quality. Exhibit a positive, can-do attitude, openness to change, self-motivation, and a proactive approach. Additional Responsibilities Advocate for the effective and efficient use of certified data sources within the business. Support the Business Intelligence Lead in designing, building, and deploying BI solutions using the Microsoft Azure stack (Power BI & Paginated Reports). Foster the adoption of best practices and design principles for Business Intelligence. Collaborate across teams to solve problems, develop and execute database queries, and conduct analysis. Create visualizations and reports for business units. Develop and update technical documentation. Required Technical Skills & Experience Proven experience in Business Intelligence and enterprise dashboard solutions. Strong expertise in Data Analytics, with a focus on Power BI. Knowledge of Data Warehouse design (dimensional modeling) and data mining best practices. Experience implementing analytical workloads and service-service analytics scenarios. Familiarity with deployment pipelines and workflow management tools. Awareness of current industry trends and challenges, with an interest in future developments. Excellent communication skills and a problem-solving mindset. Desirable Technical Skills Proficiency in agile methodologies, including DevOps tools (Azure DevOps, Agile/Kanban/Scrum, CI/CD Pipeline). Experience with Microsoft/Azure Stack (SQL Server, Data Lake, Delta Lake, and Business Intelligence tools like SSIS, SSAS, SSRS). Familiarity with other BI tools such as QlikSense, Tableau, Looker, ThoughtSpot, and Sisense. Experience in writing and implementing test scripts, documenting issues, and ensuring quality assurance for production deployment. https://www.linkedin.com/company/trispoke-managed-services-pvt-ltd/ And above link for more jobs. #jobsearch #jobhunt #jobseeker #jobopening #jobopportunities #nowhiring #hiring
- Company Name
- Trust In SODA
- Job Title
- Senior Data Engineer
- Job Description
- Senior Data Engineer – OUTSIDE IR35 Start date: ASAP Duration: 3 months (with a view to extend) Location: 1 day every month in the London office Rate: £500 - £560 per day Outside IR35 Responsibilities: Collaborate with our clients to design and build modern data platforms using a variety of technologies Help lead the design and implementation of complex, cloud-based data ingestion and transformation pipelines Implement scalable and secure Data Lakes/Warehouses Help drive effective development patterns and delivery practices Continually improve with our internal development program, including mentoring and paid training/ certifications Skills: Python Nifi Snowflake, SnowSQL SQL Airflow DBT ETL, Spark