At a Glance
- Tasks: Design and build innovative data structures and streamline existing databases.
- Company: Join Bookouture, the UK's leading digital publisher with a creative culture.
- Benefits: Enjoy 28 days annual leave, private medical insurance, and discounts on books.
- Other info: Flexible working with a blend of office and homeworking, plus excellent career development opportunities.
- Why this job: Make an impact in a data-driven environment while working with cutting-edge technology.
- Qualifications: Experience with SQL Server, database design, and data visualisation tools required.
The predicted salary is between 45000 - 55000 £ per year.
Bookouture is the UK's most successful and innovative digital publisher of commercial fiction.
We are part of Hachette UK and following fourteen years of market-leading growth have sold over 100 million books to readers worldwide with a further 14 billion Kindle pages read of our titles.
In the role of Data Engineer, reporting to the Data & Analysis Director, you'll be responsible for designing new data structures from the ground up as well as evolving those already in place - ensuring this data-driven business has robust data systems, with accurate information and reporting available at all times.
We're looking not only for experience with business-critical database design and management, but a confident team player who makes a habit of improving the way things are done, embraces change, and brings creativity to every problem.
- What you'll be doing
- Design and build new SQL Server databases from scratch - schema design, tables, views, stored procedures and indexing - to support new business systems and reporting requirements.
- Build ingestion workflows for new data sources from scratch - retailer and platform feeds, advertising and marketing data, third-party APIs, etc - designing and building the end-to-end ingestion process from source to reporting layer with appropriate validation and error handling.
- Analyse and streamline existing on-premise relational databases (SQL Server) and ETL packages (SSIS).
- Work closely with department heads across the division to support any projects requiring access to our data or collaboration with the Data Department and vice versa
- Maintain and review existing data visualisation dashboards (Tableau Cloud) and develop new reporting streams
- Work with the Publishing Innovation Director to develop data structures suitable for use in machine-learning projects
- Respond to team requests, including troubleshooting issues, generating ad-hoc reports, and building automations for currently manual tasks
- Constantly appraise existing workflows to maximise efficiency and reduce the chance of errors
Who we are looking for
Experience/Knowledge
- Computer science background with extensive workplace experience of relational databases
- Proficient in relational database schema design and structural planning (essential)
- Significant experience working with SQL Server, writing queries, building stored procedures, and developing data flows (essential)
- Experience working with SSIS packages to manage and improve daily import processes (derived columns, lookups, conditional splits for incremental loads)
- Experience of Microsoft Azure integrations
- Confident and effective user of AI tools for operational projects
- Experience integrating systems via REST APIs and managing data between platforms
- Experience building and optimising automations in Python (data syncs, API integrations, scheduled jobs)
- Experience with data visualisation tools (Tableau, Power BI or similar)
- Personal Attributes/Skills
- Strong problem-solver who isn't satisfied with a working solution if a better one exists.
- Performance-minded, with a focus on proactively optimising processes for speed and reliability
- Detail-oriented, with a sharp eye for data quality, edge cases, and inconsistencies
- Pro-active and self-directed, able to drive a task from problem to tested solution
- Adaptable and comfortable switching tools, languages, or approaches when the situation calls for it.
- Clear and confident communicator.
You will be working often with less technical staff, understanding what is being asked of you and explaining what is and isn’t possible clearly is integral.
Consistent updates on projects to stakeholders and teams involved is also key.
What we offer
Our staff are our greatest asset, and our benefits reflect this
- 28 annual leave days per year, increases to 29 days after 2 years' service and goes up to 30 days after 5 years' (+ bank holidays)
- Private medical insurance
- 2 community days per year
- Summer hours (finishing at 1pm on Fridays during the summer months)
- Retail discounts through Hachette rewards
- Cycle to Work scheme
- Wide-ranging training library
- Development programmes (including mentoring)
- Up to 70% off book purchases
- A charity bookshelf
- An active range of staff-led employee networks that are voluntary, including Age Wise, Gender Balance, Thrive, Pride, All Together, Wellbeing, Women in Tech and religious networks
- Season ticket loans
• And much more!
The role will be based at our London office, with a blend of in-office (3 days) and homeworking (2 days) per week.
Our commitment
Hachette employs people on the basis of their abilities.
We aim to attract and develop talent from a base as broad as the world of readers we want to reach, with a wide and representative range of age, faith, disability, race, gender, sexuality and socio-economic, regional and cultural backgrounds.
We want everyone to have the opportunity to perform at their best during our recruitment process.
If you need any adjustments, you can let us know at the 'Reasonable Adjustments' section of your application.
We'll make sure you're supported throughout the process.
The Book Trade Charity offers financial support to people looking to enter the book trade but who may struggle to afford the costs of attending interviews and undertaking junior roles.
- For more information visit www. booktradeentrysupport. org
- #J-18808-Ljbffr
Data Engineer employer: Bookouture
At Bookouture, we pride ourselves on being an exceptional employer that values our staff as our greatest asset. With a vibrant work culture in our London and Sheffield offices, we offer generous benefits including 28 days of annual leave, private medical insurance, and extensive training opportunities to foster employee growth. Our commitment to diversity and inclusion ensures that every team member can thrive, making it a rewarding place for those looking to make a meaningful impact in the publishing industry.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Bookouture!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Bookouture.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Bookouture.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Bookouture, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Bookouture, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Bookouture. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Bookouture
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Bookouture!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
