Data Warehouse Engineer

*this role is open to remote working within the UK. Successful candidates will be required to travel to their closest UNiDAYS campus (London or Nottingham) on occasion.

The role in a nutshell

The 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.

Day to day responsibilities 

• The role is responsible for all stages to deliver data and support report output projects. Projects will start with requirements gathering from a range of stakeholders (both inside and out of the organisation) to be merged and prioritised, leading to a data design specification of the work, then peer reviewed and discussed with the team.
• Projects will continue with full stack development; implementation of data mart design in the data warehouse, development of any required ETL (primarily in Talend Data Integration environment and secondary dbt), testing/QA/proof of correctness,
• supporting development of any new/updated reports (Tableau environment), production release, and documentation.
• Support to colleagues is essential for this role, including; career development, coaching, and co-development/design.
• 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 analysis; monitoring, response to support tickets, fixes to issues.
• Other responsibilities will include participating (and sometimes running) team meetings, providing expert domain advice to the business (e.g. helping evaluate the data elements of a vendor selection), representing the team in various cross department contexts. 
• Work for this role will both be allocated by more senior members of the team or delegated for self-allocation.
  You will evaluate and measure your own performance and seek feedback for continuous improvement. You also commit to regular check-ins with your line manager and to be proactive in completing your quarterly, Mid-Year and End of Year reviews to ensure your manager has enough time to complete before the deadline.

What we need from you

• Data Warehouse star schema design 
• 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 shell scripting

KNOWLEDGE: What You know

Perks

We've accomplished a lot since we started in 2011, but in many ways, this is just the beginning. This is the chance for you to get in on ground zero. An opportunity to make a difference within the business with global reach. We are the world’s largest Student Affinity Network, with over 22 million verified members in 115 markets including the US, UK, Germany, India, Canada and Australia. We work with 800 of the world’s biggest brands globally, taking their products and services into the hearts and minds of tomorrow’s professionals, delivering engagement, building affinity and sales. You’ll also be working for a Great Place to Work CertifiedTM company who have been recognised on the UK’s Best WorkplacesTM for Wellbeing and UK's Best Workplaces for Women 2022 list. To find out more about our workplace initiatives, see our UK exclusive case study with Great Place to Work and be sure to visit our profile for more information.

We offer a fast paced, fun & social working environment where you can truly make an impact. We believe that work should enhance and complement your life which is why we leave it up to you to decide where you work. You can choose to work from your assigned campus (either Nottingham or London) or from home, whatever works best for your individual needs. Your manager may request you attend team meet ups at your campus but other than that it is up to you! We work hard at UNiDAYS, but we also believe in fair compensation for hard work. That's why we're pleased to offer all employees full access to our comprehensive benefits package.

Our perks include:

• 25 days holiday per year increasing with length of service, plus flexible bank holidays
• Competitive salaries
• 4pm finishes every Friday
• Company bonus scheme
• Company pension scheme
• Private health insurance (Vitality)
• Income protection policy
• Life assurance policy
• Employee Assistance Program
• Enhanced parental leave pay
• Core hours with flexibility around how/when you manage your time
• Regular team building activities
• The latest tech and hardware will be supplied from day one
• Good Vibes Program: we know we’ve all had to adapt to new ways of working and UNiDAYS has always taken pride in the community we’ve created in the office but we’re just as committed to creating an innovative approach to fostering connections and improving engagement outside of the office! We want to boost your remote working experience so think virtual parties, pottery classes, wellness classes and guest speakers just to name a few!
• Support for home working for all new team members. We will help assess your home set up and you can expense £150 towards any additional furniture you may need to be safe and comfortable when working from home

About our Product & Engineering team

The driving force behind this fantastic tech business are the talented Product and Engineering team, who work collaboratively to ensure that UNiDAYS stays one step ahead of the competition, with the ultimate goal of giving students the power to make every experience more valuable and rewarding.

The Product and Engineering teams at UNiDAYS are comprised of a bunch of passionate people who work in a fun, fast paced and social environment. Everyone is equal and encouraged to work with each other, whilst having the autonomy to solve problems in the best way they see fit.

The UNiDAYS tech team are passionate about the local Tech Community, hosting and sponsoring local meet ups and hack events. Career development is an important facet of the UNiDAYS tech experience.

Listen to the episode on The Diverse Podcast here: https://podcasts.apple.com/gb/podcast/47-how-to-build-your-dream-career-in-tech/id1515585546?i=1000587931714

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.