Business Intelligence Engineer London, England
Job description
About Peach
Company Peach is a high growth, global technology company that streamlines complex workflows and powers the creative industry. Our technology, Peach, is an online platform used by agencies and advertisers to control and distribute advertising content in over 100 countries. We also provide a cross-industry service for TV campaign administration and advertisement clearance as well as expert TV admin support for agencies, production companies and advertisers. Financially strong, Peach has over 220 employees and is headquartered in Soho, London. With over 21 office locations, Peach’s worldwide presence across Europe, Asia Pacific, Australasia, the Middle East and the Americas is changing the way advertising works.
Company Vision
Become the largest global SaaS provider for managing advertising content driven by our passion for solving customer needs with innovative products and smart service.
Our Mission
Manage the world’s advertising content and make it easy for brands, agencies and media owners to interact with each other.
Company Values
- Be creative
- Break down barriers
- Always improving
- Support and challenge
- Inspired by our customers
- Aim for extraordinary
Overview of role
Peach is seeking a highly analytical and resourceful Senior BI Engineer/Developer to be part of a growing BI function to support the Finance, Sales and Operational teams based in London.
In this role you will be responsible for end-to-end development of building a reporting suite, designing reports & dashboards in Power BI, maintenance of the semantic layer as well as adding functionality to the new reporting system to be used for organisation reporting.
As a Senior BI Engineer/Developer, you will be a self-starter, inquisitive and bring your strong consulting, design, development, delivery, and support experience to bear and deliver outstanding data platform and analytics dashboards. This is a fantastic opportunity to work collaboratively alongside our existing team of talented Analysts and Product Engineers.
Responsibilities and key tasks
- Understand and design business intelligence and reporting architecture, map out the end-to-end data processes/data flows and extract large datasets from multiple sources such as Google sheets, Netsuite, Hubspot, and Zendesk
- Develop dashboards in Power BI to support data-driven decision making using your extensive knowledge in DAX and Power queries
- Model and test data using SQL, and build and maintain dimensional or fact tables for dashboard development and strong knowledge in relational database management (RDMS)
- Develop tabular and multidimensional models that are compatible with data warehouse standards
- Analytically translate data into informative reports, visuals and deliver training to stakeholders to promote self service analytics
- Work with stakeholders to gather requirements and understand business needs
Experience and skills required
- Experience in visual communication of analysis in Power BI, developing wireframes, proof-of-concepts and specifications of dashboards
- Extensive knowledge of ETL, SQL (DDL and DML), stored procedures and SSIS packages
- Understanding of data modelling outside BI visualisation tools and map out end-to end data processes and data flows
- Understanding the importance of interoperability and dependencies within differing datasets
- Agile and flexible way of working with the ability to adjust to new demands with a sense of urgency and comfortable in dealing with ambiguity
- Organised, detail oriented, strategically focused with the ability to multitask in a fast-paced, constantly evolving environment
- Ability to work independently with limited support, while aligned to weekly and daily agile governance (weekly sprints, reporting)
Background required
- 5+ years of data analytics experience
- Big 4 professional services environment (or those with similar skills gained in industry) experience
- Prior experience working in a high growth start-up advantageous
- Bachelor's degree/University degree or Master's degree in engineering, statistics or related field
- Experience using SQL and PowerBI essential
- Experience in AWS cloud desirable
Job Type: Full-time
Salary: From £65,000.00 per year
Benefits:
- Casual dress
- Company events
- Company pension
- Cycle to work scheme
- Discounted or free food
- Employee discount
- Gym membership
- Life insurance
- Private medical insurance
- Referral programme
- Sick pay
- Store discount
- Work from home
Schedule:
- Monday to Friday
Supplemental pay types:
- Yearly bonus
Ability to commute/relocate:
- London, W1G 0JW: reliably commute or plan to relocate before starting work (required)
Application question(s):
- Do you have experience using SQL?
- Do you have experience using PowerBI?
Experience:
- Data analytics: 5 years (required)
Work authorisation:
- United Kingdom (required)
Work Location: Hybrid remote in London, W1G 0JW
