Business Intelligence Analyst

Job Description

Life at Elvie - Meaningful work. Exceptional people

We're Elvie. We create smart products, new solutions, and a fair few taboo-busting conversations while we’re at it. Founded by Tania Boler in 2013, we develop extraordinary innovations designed to improve women’s lives. It's a fascinating and challenging area that requires us to solve problems that no one else has ever tackled before.

At Elvie, you’ll be surrounded by people who want to improve everything and everyone around them. People who are passionate about our mission. People who are driven to solve problems and constantly consider the best ways to improve the health and wellbeing of women.

Find out more about life at Elvie here.

We're deeply proud of our values, which are intrinsic to the way we behave every day. We take them seriously because we want our culture to thrive:

• We make an impact: We’re mission-driven and not afraid to break boundaries. We relentlessly focus on going the extra mile to solve problems.
• We’re fearless innovators: We are passionate, curious, and data-driven. We continuously embrace change and innovation.
• We’re in it together: we fail and learn fast — always as one team — and have fun along the way. We stay authentic and embrace our differences.

About the role:

Okay, we’ve waffled long enough. So let’s get to the good bit: You.

At Elvie, we are building a centralised business intelligence team under our broader Finance department. This team will provide insight through standardised reporting and analysis, drive one source of truth thinking, and improve the efficiency of getting information. You will have the exciting opportunity to be the first engineer on this team, allowing you the creativity and power to make an impact and shape our structures. We need a passionate and dynamic analyst who thrives in a fast paced and continually evolving environment.

You should be able to understand the needs and KPIs of cross-functional teams, such as Operations, Finance, Sales, Marketing, HR, and Customer Care. You have experience integrating multiple data sources and mapping connectors to allow for systems communication. You can interpret large data sets and provide analysis and reflections to drive success. You are organised and willing to take on multiple roles when necessary. We need someone who has experience setting up data structures, complex integrations, and implementing data quality management. You know how to quickly problem-solve and can adapt to conflicting priorities. You are excited by the prospect of coding and developing a new business intelligence structure within a rapidly growing business.

Location: Hybrid working; a mix of working from our London office & working remotely

Employment type: Permanent (please note, you must have the right to work in the UK)

What you’ll be doing

You will work under our Business Intelligence Lead within the Finance team at Elvie. This role is an exciting opportunity to build something from the ground up: a centralised business intelligence function responsible for data visualisations and insights, KPI tracking, data quality management, and efficiency and capacity building. This role is pivotal to our growth plans, as you will be responsible for scoping our data integration and working to create 1 source of truth at the company. You will provide data driven direction that allows us to scale, including directing where changes in data capture are needed in order to pull sustainable insights. You will need to be adaptable and find innovative ways to meet the demands of wider stakeholders.

Data Quality and Reporting (up to 50%)

• Design and build sets of reports to meet the needs of the key stakeholders within Finance, Operations, Marketing, Sales, Customer Care, and HR
• Collaborate with the BI Lead to devise and maintain an accurate performance metric dashboard for the Exec team
• Provide weekly and monthly management reports to analyse the performance against key business plan metrics and help predict future trends
• Document, review and develop data capture processes at all levels of the business, whilst monitoring the quality and integrity of the data
• Be an advocate for data driven decision making
• Work with the BI Lead to enable timely execution of all reporting dashboards, ensuring that trends in patterns are reviewed and processes are optimised/automated where possible
• Assist in the management and maintenance of master data (such as region, product category, and channel fields) in the ERP platform and other related software programmes

Data Engineering (50%+ of time)

• Own and manage source data models: design processes, views and procedures that are in line with the BI team’s mission and Elvie’s brand
• Provide data expertise to support strategic requirements definition and translation, including driving the delivery and management of new data inputs
• Design and maintain testing requirements for new systems to enable multi-way communication (this may include using iPaaS connectors, connecting ERP to BI tools or connecting a data warehouse to Netsuite)
• Upload and update data sources where automation or live connection is not yet available
• Ensure supporting data is maintained and BI team performance is tracked: KPIs include value added, timelines met, number of data sources and reports delivered
• Write and document SOPs to uphold transparency and enable effective onboarding of future BI team members
• Determine capacity requirements for reporting and analytical tools based on future demand and business use, in collaboration with other teams at Elvie

Requirements

• At least 3 years experience in a BI, data engineering, or analyst role
• Experience setting up and improving data warehouse management systems
• Proficient in Netsuite or similar ERP system
• Advanced skills with Visualisation tools, Tableau preferable
• Knowledge of SQL and using third party integrations such as ODBC/iPaaS connectors
• Experience with Alteryx and Celigo highly desirable
• Use of Amazon Seller Central, Avercast, B2B Gateway, Salesforce beneficial
• Highly creative and solutions-oriented, experience with agile project management desirable
• Excellent attention to detail

Benefits

We're on an exceptional journey. And we can offer you a genuinely purpose-led career with a culture built on trust, autonomy, and flexibility. In addition, we'll give you:

• Lots of flexibility: whether it’s working from home, doing the school run, or life admin, we understand that flexibility is essential, and we trust you to do the right thing for you and us
• Share options: we want everyone to have a stake in our success
• An annual discretionary bonus scheme
• 25 days’ annual leave, plus bank holidays
• 3 additional Elvie “in it together” bank holidays for 2022
• 8 extra life leave days; getting married, moving house, menopause or just things that you can’t put a label on that matter to you
• 5=10 leave: 10 days’ additional leave on your 5th and 10th years of service!
• £100 contribution to your home working set up to spend as you see fit
• An annual personal development allowance of £200 and unlimited access to our learning and development platform, Learnerbly
• Generous parental leave policies; maternity, paternity/partner, shared & adoption
• Healthcare plans, life insurance, and an employee assistance program for you and your family
• A tax-efficient group pension scheme
• Group income protection; protect your salary if you get sick
• A free Elvie trainer for you to keep or give away when you join
• Generous employee and friends & family discounts on Elvie products
• Wellbeing support from YuLife and access to SmartHealth app with unlimited GP appointments for you and your family, plus various well-being initiatives throughout the year
• Lovely offices in great locations, with drinks and snacks provided, along with fun social events

What you can expect after you’ve applied:

A member of our recruitment team will reach out to you after they have reviewed your application. You must ensure your application is completed correctly, and we strongly encourage you to add a cover letter or note to let us know why Elvie’s the right fit for you.

We would like to get to know you through your background, attitude, experience and understand your motivation to work with us. Our interview process varies depending on the position, but it typically looks like this:

• 20-minute video call with one of our recruiters
• 30-45 minute video call with the hiring manager
• 45-60 minute video interview with the team (some positions may require you to complete a task/presentation)
• For some positions, there may be an additional interview with one of senior our leadership team

This is undoubtedly a great time to join Elvie. You’ll have a voice, make an impact, and have the opportunity to mould your role. So be ready to learn, have fun, and be inspired by our passionate, talented team — and having a sense of humor helps too. 😉

We can’t wait to hear from you!