At a Glance
- Tasks: Lead data warehouse redesign and optimise data models for performance and scalability.
- Company: Join a dynamic team at UNiDAYS, shaping the future of data solutions.
- Benefits: Enjoy flexible working, competitive salary, and 25 days holiday plus perks.
- Other info: Collaborative culture with opportunities for career growth and mentorship.
- Why this job: Make a real impact in a fast-paced, fun environment while developing your skills.
- Qualifications: Expertise in SQL, ETL development, and experience with AWS technologies required.
The predicted salary is between 60000 - 80000 £ per year.
The Senior Data Warehouse Engineer role encompasses full stack BI development skills, from stakeholder requirements gathering, through specification, data mart design, report building and quality management. You will work closely with analytics, data engineering and platform teams to deliver cutting‑edge data solutions and help shape the organisation’s data‑driven future. In your capacity as a Senior Data Warehouse Engineer, you will be a seasoned professional leading many initiatives whilst continuing to learn and grow in the role and further develop your skills alongside acting as an authority within the responsibilities laid out below.
Job Requirements
- Data Warehouse maintenance and schema design - Star, Snowflake, normalisation, de‑normalisation
- SQL development
- ETL & ELT development - Talend tools and/or dbt preferable, or equivalent
- Support Report developers - Tableau tools preferable, or equivalent
- End to end BI development (requirements to report delivery)
- AWS technology stack development - S3, Redshift, RDS, Athena, etc
- Big Data platform development - BigQuery
- Working with Insight Analysts/Data Scientists and their environments - e.g. R, Jupyter, Scala
- Some form of non‑BI programming experience - e.g. application, website, systems development
- Experience of developing in, or learning, industry useful programming languages - e.g. Java and Python
- Platform familiarity and understanding - Linux and or Unix command line including Bash/Shell scripting
- Experience with version‑controlled repositories - Git‑based workflows
- Experience with data pipeline orchestration and scheduling
- Nice to have: knowledge of data governance, lineage, and quality monitoring practices.
- Nice to have: software experience of Airflow, Fivetran and Google Big Query
Job Responsibilities
- Lead the architectural redesign of the existing data warehouse to align with modern ELT best practices.
- This role, along with the rest of the team, is also responsible for the continued availability of the existing data platform at UNiDAYS for both reporting and Insights; monitoring, response to support tickets, fixes to issues.
- Optimise data models in Amazon Redshift for performance, scalability, and cost efficiency.
- Ensure data quality, lineage, and documentation standards are enforced across pipelines.
- Collaborate with data analysts, engineers, and stakeholders to capture requirements and validate solutions.
- Set up CI/CD practices for dbt deployments and promote version‑controlled transformations.
- Support incremental loading strategies and design effective partitioning and snapshotting techniques.
- Assist with production rollout, monitoring setup, and knowledge transfer to internal teams.
- Support to colleagues is essential for this role, including career development, coaching, and co‑development/design.
Competencies
- Data Architecture & engineering: Independently builds scalable pipelines, models data flows, strong understanding of warehouse/lake architecture such as star schema, design and configure of batch/streaming systems to optimise processing.
- Programming & Automation: Expert proficiency in SQL and one of; dbt, python, shell script etc. for pipeline automation, development of ETL, testing/QA/proof of correctness, production release and deployments, optimise data models for performance, scalability, cost efficiency, setup/follow CI/CD practices and implement partitioning and snapshotting techniques.
- Data Quality & Governance: Monitoring, testing and ensuring reliability, compliance, and security of data systems, response to support tickets and fixes to issues, and maintain lineage standards.
- Collaboration & Handoff: Translating business/analyst needs into engineering solutions, clear documentation (data design specification etc.), co‑development and co‑design, peer reviews, discussions with the team.
- Project & Stakeholder Management: Independently scoping, estimating, prioritising and delivering data projects across teams, representing the team in various cross‑department contexts and integrate themselves in Agile practices.
- Influence and Leadership: Setting best practices, mentoring, driving platform decisions, cross‑team alignment, career development and coaching and propose improvements.
Job Benefits
- We offer a fast‑paced, fun, and social working environment where you can truly make an impact.
- We believe work should enhance and complement your life, which is why we provide a flexible hybrid working model.
- Our Perks Include:
- 25 days holiday per year increasing with length of service, plus bank holidays
- Competitive salaries
- 4pm finishes every Friday
- Company pension scheme
- Private health insurance (BUPA)
- Dental Insurance (BUPA)
- Income protection policy
- Life assurance policy
- Employee Assistance Program
- Enhanced parental leave pay
- Regular team building activities
- £150 towards your home office set up
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status or disability status.
Senior Data Engineer employer: UNiDAYS
At UNiDAYS, we pride ourselves on being an exceptional employer, offering a vibrant and collaborative work culture that empowers our employees to thrive. With a flexible hybrid working model, competitive salaries, and a comprehensive benefits package including private health insurance and enhanced parental leave, we are committed to supporting your professional growth and well-being. Join us in shaping the future of data solutions while enjoying a fun and social environment that values diversity and inclusivity.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at local meetups. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data projects, especially those involving SQL, ETL processes, and BI tools. This gives potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions. Practice explaining your past projects and how you tackled challenges, especially around data quality and governance.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive!
We think you need these skills to ace Senior Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Data Engineer role. Highlight your experience with data warehousing, SQL development, and any relevant tools like Talend or dbt. We want to see how your skills align with our needs!
Showcase Your Projects:Include specific projects that demonstrate your expertise in BI development and data architecture. If you've led initiatives or optimised data models, let us know! Real-world examples can make your application stand out.
Be Clear and Concise:When writing your cover letter, be clear about why you want to join StudySmarter and how you can contribute. Keep it concise but impactful – we appreciate straightforward communication!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at UNiDAYS
✨Know Your Data Warehousing Inside Out
Make sure you brush up on your data warehousing concepts, especially star and snowflake schemas. Be ready to discuss your experience with schema design and how you've optimised data models in the past.
✨Show Off Your SQL Skills
Prepare to demonstrate your SQL prowess. You might be asked to solve a problem on the spot, so practice writing queries that involve complex joins and aggregations. Familiarity with ETL/ELT processes will also give you an edge.
✨Familiarise Yourself with Tools and Technologies
Get comfortable with the tools mentioned in the job description, like Talend, dbt, and AWS services. If you have experience with Tableau or BigQuery, be ready to share specific examples of how you've used them in your projects.
✨Collaboration is Key
Be prepared to discuss how you've worked with cross-functional teams in the past. Highlight your ability to translate business needs into technical solutions and your experience in mentoring or supporting colleagues in their development.
