We are seeking a Junior Business Analyst to join our growing team, supporting the data and reporting needs of our digital B2B platform. In this role, you’ll work closely with cross-functional stakeholders—including product, marketing, sales, and technology teams—to maintain clean, accurate datasets; develop and optimize ETL pipelines; and create insightful reports and dashboards. This is an exciting opportunity to develop your analytical, technical, and communication skills while contributing to a platform that empowers businesses to transact and collaborate more effectively.
Key Responsibilities
- Data Cleansing & Management
- Clean, validate, and consolidate existing datasets from multiple sources (e.g., user activity data, sales leads, product usage).
- Monitor data quality and proactively identify issues for resolution.
- Maintain documentation of data flow processes and data definitions.
- ETL Creation & Maintenance
- Support the creation, monitoring, and optimization of ETL (Extract, Transform, Load) pipelines for the B2B platform.
- Collaborate with senior analysts and data engineers to ensure data is accurately transformed and made available for analysis.
- Troubleshoot ETL workflows, addressing errors or delays promptly.
- Ad Hoc Queries & Scheduled Reporting
- Use SQL and business intelligence tools (e.g., Power BI) to perform deep-dive analyses of platform usage, customer behavior, and sales performance.
- Develop and maintain scheduled reporting (weekly, monthly, quarterly) to provide stakeholders with timely insights.
- Respond to ad hoc reporting requests to support product, marketing, and sales initiatives.
- Power BI & SQL
- Build and refine Power BI dashboards to visualize KPIs such as user engagement, conversion rates, and revenue trends.
- Write and optimize SQL queries for data extraction, analysis, and performance tuning.
- Collaborate on data model designs that support robust reporting and analytics.
- Presentation & Communication
- Prepare clear, concise presentations and reports to communicate findings to both technical and non-technical stakeholders.
- Participate in meetings with cross-functional teams to share insights and recommendations that drive business decisions.
- Gather feedback from stakeholders and iterate on reporting solutions to better meet business needs.
Skills & QualificationsRequired
- Bachelor’s degree (or equivalent) in Business, Data Analytics, Computer Science, Information Systems, or a related field.
- Familiarity with SQL (ability to write basic-to-intermediate queries) and Power BI (or equivalent BI tool such as Tableau).
- Knowledge of data cleansing and validation techniques.
- Strong attention to detail and ability to spot data inconsistencies.
- Good written and verbal communication skills, including the ability to explain data insights to non-technical audiences.
Preferred
- Experience with ETL tools or processes (e.g., SSIS, Talend, Airflow, or custom pipelines).
- Basic knowledge of data warehousing concepts and data modeling.
- Familiarity with digital B2B or e-commerce platforms, understanding user journey metrics and conversion funnels.
- Some exposure to scripting languages (e.g., Python, R) for data manipulation and automation.
- A strong interest in learning about B2B platform dynamics, market trends, and best practices in data governance.
Personal Attributes
- Analytical Mindset: Eager to explore data patterns, identify trends, and derive actionable insights.
- Problem Solver: Willing to troubleshoot issues systematically and propose practical solutions.
- Team Player: Comfortable collaborating with technical teams and business stakeholders, learning from senior team members.
- Organized: Able to prioritize tasks and manage competing deadlines in a fast-paced environment.
- Self-Starter: Motivated to keep learning and improving, with a can-do attitude toward new challenges.
What We Offer
- A chance to work on a high-growth digital B2B platform, shaping how businesses interact and transact online.
- Mentoring and training from senior analysts, data engineers, and product leaders.
- Competitive salary and benefits package (pension, healthcare, etc.), plus opportunities for professional development.
- A supportive and inclusive work culture that values curiosity, innovation, and collaboration.
- Hybrid working depending on role requirements and location.
Job Types: Full-time, Permanent
Pay: £42,054.00-£46,322.00 per year
Additional pay:
Benefits:
- Casual dress
- Company events
- Private medical insurance
- Work from home
Schedule:
Work Location: Hybrid remote in London SW1W
Application deadline: 31/01/2025
