Job Title: Lead Data Analyst
Contract Length: Until End of Year (possibility of extension)
Location: London (Hybrid)
Job Overview:
We are seeking an experienced and driven Lead Data Analyst to join our Global Customer Service Team on a contract basis. The successful candidate will play a key role in elevating our Power BI reporting suite, driving user engagement, and identifying opportunities for a wide range of stakeholders. If you're a data-driven professional with advanced technical skills and a passion for transforming data into actionable insights, we want to hear from you!
Key Responsibilities:
- Elevate our Power BI reporting suite by improving and enhancing the dashboards to drive user engagement and identify opportunities across various business functions.
- Write and optimize SQL queries to extract, manipulate, and analyze data from Snowflake and Google BigQuery data warehouses.
- Consolidate data from external partners using advanced Microsoft Excel skills (including formulas, functions, pivot tables, etc.).
- Implement and maintain a data framework that ensures consistency, scalability, and ease of reporting.
- Collaborate with various stakeholders across the business to understand their data needs and provide insights that help drive strategic decisions.
- Deliver actionable insights and recommendations to senior leadership and key stakeholders in the business.
Essential Skills and Experience:
- Advanced Power BI skills - Strong experience designing and enhancing reports and dashboards, with a focus on driving engagement and identifying insights.
- SQL proficiency - Expertise in writing SQL queries to interact with Snowflake and Google BigQuery data warehouses.
- Advanced Excel skills - High competency in using Microsoft Excel for complex data manipulation, consolidation, and analysis (formulas, functions, pivot tables).
- Experience implementing and maintaining a data framework that ensures data consistency and reliability across teams.
Desirable Skills and Experience:
- Python - While not essential, knowledge of Python would be a nice-to-have for automating tasks and data manipulation.
- Power Automate - Experience with Power Automate or a willingness to learn and implement it to optimize processes would add significant value to the role.
- Stakeholder management - Ability to communicate with business stakeholders to gather requirements and manage expectations (not critical, but beneficial).
