Data Warehouse Engineer (SQL)
Monzo Bank
2d ago

We're looking for a Data Warehouse Engineer to join our brand new Data Warehouse team.

Our Data Warehouse team works in the intersection between data, engineering and our collectives - Money, Borrowing, Operations and Financial Crime and beyond.

The team is responsible for building downstream data models from backend services with the desire to make our Data Warehouse a genuine competitive advantage for Monzo.

We want a team capable of building an amazing Data Warehouse to support decision making, Business Intelligence, key financial reconciliation processes and best in class analytics and Data Science.

You'll be an individual contributor in our Data Warehouse Engineering team, working across a variety of projects to spot patterns in the way we build our Data Warehouse.

You’ll help us minimise our cloud costs, drive best practices across all of our Data Discipline and scale and automate our data governance.

Data At Monzo

Our Data team's mission is to Enable Monzo to Make Better Decisions, Faster

At the core of this mission sits our data platform. We're great believers in powerful, real-time analytics and empowerment of the wider business.

Every engineer at Monzo is responsible for collection of relevant analytics events from their microservices. We optimise for simplicity and re-usability all our data lives in one place and is made available via our data warehouse in Google BigQuery.

90% of day-to-day data-driven decisions are covered by self-serve analytics through Looker which gives data scientists the head space to focus on more impactful business questions and analyses.

Our Technology Stack

We rely heavily on the following tools and technologies (note we do not expect applicants to have prior experience of all them) :

  • Google Cloud Platform for all of our analytics infrastructure
  • dbt and BigQuery SQL for our data modelling and warehousing
  • Python for data science
  • Go to write our application code
  • AWS for most of our backend infrastructure
  • You will :

  • Drive best practices for our Data Warehouse - payload design, logical data modelling, implementation, metadata and testing standards.
  • Own cost optimisation of our Data Warehouse, spotting opportunities to refactor to reduce the cost of our batch jobs
  • Support the building of robust data models downstream of backend services (mostly in BigQuery SQL) that support internal management information as well as financial / regulatory reporting
  • Scale a Monzo wide approach to data contracts between our services and data warehouses
  • Investigate and effectively work with colleagues from other disciplines to address and improve data quality
  • Drive the thinking on a scalable approach to prioritise data governance issues
  • You Should Apply If

  • You have experience and a passion for data warehousing, big data and ETL projects as a designer or architect
  • SQL is second nature to you
  • You are an expert with general data warehousing concepts
  • You have experience teaching and training others
  • You’ve worked on a wide range of Data Warehouse problems - supporting Machine Learning, regulatory reporting, Business Intelligence and financial reporting projects
  • You have experience building robust and reliable data sets requiring a high level of control
  • You strive for improvement in your work and that of others, proactively identifying issues and opportunities
  • Nice To Haves

  • Experience working within a finance function
  • Experience working in a highly regulated environment
  • Knowledge of accounting / ERP systems and principles (e.g. NetSuite, Oracle EBS, SAP)
  • Knowledge of regulatory reporting and treasury operations in retail banking
  • Experience with strongly-typed languages (e.g. Go, Java, Scala...)
  • Working knowledge of Python, Airflow and dbt
  • Used to AGILE ways of working (Kanban, Scrum) tracked in JIRA or Trello
  • Logistics

  • This role will be remote until we open our London office again.
  • We can help you relocate to London & we can sponsor visas.
  • We offer flexible working hours and trust you to work enough hours to do your job well, at times that suit you and your team.
  • Diversity and inclusion is a priority for us if we want to solve problems for people around the world, our team has to represent our customers.
  • So we need to attract the best talent and create an environment that supports and includes them. You can read more about diversity and inclusion on our blog.

  • If you prefer to work part-time, we'll make this happen whenever we can - whether this is to help you meet other commitments or strike a great work-life balance.
  • The application process consists of a 30-min phone call with a recruiter, an initial call with someone from the team, followed by a practical written exercise and 2-3 on-site interviews remotely via hangouts.
  • We promise not to ask you any brain teasers or trick questions.

    Equal Opportunity Statement

    At Monzo, embracing diversity in all of its forms and fostering an inclusive environment for all people to do the best work of their lives with us.

    This is integral to our mission of making money work for everyone.

    We're an equal opportunity employer. All applicants will be considered for employment without attention to ethnicity, religion, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity status or disability status.


    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form