Data Modeller

Tandem Bank

  • United Kingdom
  • £30,000-40,000 per year
  • Permanent
  • Full-time
  • 19 days ago
Job Title: Data Modeller
Working Pattern: Monday to Friday, 36.25 hours per week
Salary: £30,000 - £40,000 and up to 20% bonus and benefits
Location: Flexible - Embrace fully UK remote or hybrid work from any of our vibrant UK offices in London, Cardiff, Durham or Blackpool.At Tandem, we're not just a bank; we're a movement for positive change. If you're an ambitious and dedicated Data Modeller, ready to make an impact, we've got a space with your name on it!The main purpose of the role is to design, implement and maintain data models and transformations of Tandem's data, whilst ensuring data quality, performance, and scalability across Tandem's data infrastructure.We are Tandem - Where impact meets innovationTandem is the UK's greener digital bank on a bold quest to revolutionise the way we save, borrow, spend, and share - all while nurturing our planet, our people and our customers. As one of Europe's fastest growing digital banks, our values of being Brave, Enterprising, Simple, and Together (BEST) ensure our 500-strong team collaborate to drive a brighter, greener future.Your team: Collaborators in changeTandem is proud to offer a workplace with diverse experiences, perspectives, and backgrounds which leads to a unique company culture for our people and a better experience for our customers.The data team you'll be working with are a small group of hard-working and enthusiastic analysts, report developers, and data modellers. You'll have the opportunity to influence data architecture design, collaborate with the team to build a modern Data Warehouse stack, and have regular knowledge-sharing and learning opportunities.You'll also be collaborating with business stakeholders to understand data requirements and optimise data structures, providing accurate and efficient insights into Tandem's data.Your Impact: Building a greener tomorrowAs a Data Modeller at Tandem your focus will be on:
  • Design and implement dimensional and relational data models for business intelligence and analytics use cases
  • Create and maintain data documentation, including entity-relationship diagrams and data dictionaries
  • Develop and implement data quality controls and validation procedures
  • Support the optimisation of data pipelines for data transformation processes
  • Participate in code reviews and maintain modelling best practices
We'd love to hear from you if you have the following skills:
  • Data Modelling
  • Investigates enterprise data requirements where there is some complexity and ambiguity.
  • Plans data modelling and design activities, selecting appropriate techniques and levels of detail to meet objectives.
  • Provides advice and guidance to others using the data structures and associated components. Data Engineering (DENG 3)
  • Database design
  • Interprets installation standards to meet project needs and produces database or data warehouse component specifications.
  • Develops physical database or data warehouse design elements, within set policies, to meet data requirements.
  • Data management
  • Implements standard data management practices based on detailed organisational requirements.
  • Monitors and maintains data quality through regular reviews and validation checks.
  • Communicates the details of data management procedures to others, helping with their understanding and compliance.
  • Business intelligence
  • Supports business intelligence needs of specific management or governance processes or operational areas.
  • Investigates the need for business intelligence reporting and analysis where there is some complexity and ambiguity.
  • Selects and applies non-standard business intelligence tools and techniques to provide insights and aid decision-making. Selects, acquires and integrates data for analysis and verifies the data's quality and integrity.
  • Identifies opportunities to digitise and streamline operational data handling and optimise business intelligence capabilities.
And experience of the following:
  • Github:
  • Proficient with GitHub for version control and collaboration
  • DBT:
  • Experience with DBT for data transformation and modelling
  • Mage.ai:
  • Working knowledge of Mage.ai for data pipeline development
  • Database Systems:
  • Timescale db
  • PostgreSQL
  • Experience with Microsoft SQL Server
  • Power BI:
  • Proficiency in Power BI for semantic modelling and reporting
It would be great, but not essential if you have:
  • ETL/ELT processes
  • Data quality and validation methodologies
  • Task management in JIRA
  • Documentation in Confluence and Miro
  • Familiarity with JetBrains IDEs, particularly DataSpell
Rewards that reflect your value, what's in it for you?At Tandem, your hard work is rewarded in many ways, and we have an enhanced employee benefits package on offer from your very first day with us:
  • 25 days annual leave plus 8 days Bank Holiday
  • An additional day off for a 'celebration day' including, but not limited to, birthdays, weddings, religious holidays, graduations etc
  • Buy or sell up to 5 days holiday a year
  • Healthcare cash plan through Westfield Health
  • Electric Vehicle salary sacrifice scheme
  • Cycle to Work salary sacrifice scheme and a free helmet
  • Salary sacrifice Pension contribution*, 4% employee contributions matched with 4% Tandem contribution (*Subject to salary eligibility)
  • Smart Tech scheme (buy goods with 0% interest)
  • 10% discount on solar panels
  • Tandem Hub for treats, cash back and discounts on UK retailers
  • 2 days per year paid volunteering
  • Free cereal, snacks and drinks in all offices
  • Quarterly team social budgets
Our Green Deal: Your Impact AmplifiedA little welcome gift from us to you, we'll plant a tree in the Tandem Grove and you can enter into our “Green Deal” below:
  • Volunteer 2 days a year for charity
receive an early Friday finish * Raise £200 per annum for charityTandem provide PR and marketing support * Have renewable energy at homereceive an additional 1 day annual leave * Drive an electric carreceive £500 towards a home chargerReady to make your mark?Apply now and let's pave the way to a greener world, together. Our approach to DE&I is reflected in our hiring process so please let us know if you require any reasonable adjustments.Sourcing ModelRecruitment at Tandem works primarily on a direct sourcing model and does not accept resumes from recruitment agencies which are not on the preferred supplier list. We are not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company. You can find our Applicant Privacy Policy on our Careers page.Tandem is an equal opportunity employer and are committed to meeting our responsibilities under the Equality Act (2010). We respect the diverse experience and talents that every individual brings to our Company, and we are determined to ensure that no applicant or employee receives less favourable treatment on the grounds of gender, age, disability, religion, belief, sexual orientation, marital status, or race, or is disadvantaged by conditions or requirements which cannot be shown to be justifiable.Please be aware that background checking (including credit, criminal records and CIFAS Internal Fraud Database Checks) form part of our recruitment process. We will adhere to our duties under the Rehabilitation of Offenders Act 1974.

Tandem Bank