Location: City of London Job Type: Contract Industry: Life Sciences Job reference: BBBH400699_1742308394 Posted: 14 minutes ago
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).
