Data Modeller

Frontier Agriculture; United Kingdom; Remote; GBP 40,000 - 60,000; Full time

Job summary

A leading agricultural firm in the UK is seeking a Data Modeller for a permanent, full-time position. This role involves developing data models and collaborating with various teams to enhance our data architecture. Strong SQL knowledge and experience with data modelling tools are required. Join us to contribute to a culture focused on innovation and inclusivity. The position is primarily home-based with occasional site visits.

Benefits

Competitive salary

Flexible working arrangements

25 days holiday with option to purchase more

Dedicated Learning & Development team

Employee Assistance Program

Enhanced parental leave benefits

Life Assurance scheme

Cycle to Work Scheme

Qualifications

• Experience in designing and implementing database structures.
• Ability to create and maintain conceptual, logical, and physical data models.
• Familiarity with ETL processes in Azure Data Factory and Azure Databricks.

Responsibilities

• Develop and maintain complex data models for business data analysis.
• Collaborate with stakeholders to understand data requirements.
• Contribute to and maintain the Data Governance model.

Skills

Strong understanding of SQL

Data modelling concepts

Proficiency in data modelling tools

Database structure design

Data warehousing in Azure

Cross-functional collaboration

Performance tuning

Agile/Scrum experience

Tools

Erwin

Vertabelo

PowerDesigner

Job description

We are looking for a Data Modeller to join the Frontier team, on a permanent, full-time basis. This is a fully homebased role but there will be a requirement to attend sites when needed.

You will be responsible for developing and maintaining the data models, understanding and communicating the data relationships to our data engineers and the wider development teams. Working with other Modellers, Developers, Product Managers, and Delivery Leads in Scrum teams, you will build efficient programs and systems that serve Customer needs.

At Frontier, the Technology Team strive to deliver brilliant experiences for customers and colleagues. We want to hear from passionate, enthusiastic people from any background. We work with a variety of technologies from front-end native and web applications through to the backend systems that hold our organisation together and the hardware they run on. We are a data-driven organisation. We are transforming our technology landscape and the way we work, and this is a fantastic opportunity to join a team at the start of a change journey. Join us to make a real and valuable difference as you build your career at Frontier.

The Benefits

• Competitive salary
• Opportunities for a mixture of home and site working (to be agreed with Line Manager)
• 25 days holiday per calendar year with option to purchase 5 more days
• Dedicated Learning & Development team to support you and your career
• Employee Assistance Program providing 24 hours support & advice in areas such as health and wellbeing for yourself, your family & friends (up to 5 people in total)
• Increased Maternity, Paternity & Adoption leave benefits for eligible employees
• Life Assurance scheme and pension plan with employer contributions of up to 7%
• Cycle to Work Scheme, employee retail discount scheme and free eye test vouchers

About You

• Strong understanding of SQL and data modelling concepts
• Proficiency in data modelling tools such as Erwin, Vertabelo, or PowerDesigner
• Experience in designing and implementing database structures
• Ability to create and maintain conceptual, logical, and physical data models
• Familiarity with data warehousing and ETL processes in Azure Data Factory and Azure Databricks
• Knowledge of industry best practices for data modelling and database design
• Ability to collaborate with cross-functional teams to gather and analyse data requirements
• Experience in performance tuning and optimization of database queries
• Experience in Scrum/Agile teams

Your Role

As a Data Modeller your role will involve:

• Active participation in all Agile ceremonies
• Develop and maintain complex data models for business data analysis and reporting purposes
• Collaborate with stakeholders and cross-functional teams to understand data requirements and design appropriate data models that align with business needs
• Contribute to and Maintain the Data Governance model
• Evaluate and recommend data modelling tools and technologies to improve efficiency and accuracy of data modelling processes
• Create and maintain data dictionaries and metadata repositories to ensure consistency and integrity of data models
• Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality
• Document and communicate data model designs and standards to ensure understanding and compliance across the organization
• Stay current with industry best practices and trends in data modelling and incorporate new techniques and methodologies into our data modelling processes

About Us

Frontier is a successful and growing business. We are the largest crop production and grain marketing company in the UK, with over 1,000 employees and a turnover of more than £1.5 billion.

With a vision to be the first-choice employer in UK agriculture, we are committed to delivering a culture where people are at the heart of our success.

Award winning for our commitment to people, we have been recognised by Great Place to Work institute since 2012 and we are proud to be ranked by them in the top 30 UK best large places to work.

Our business approach is underpinned by our core values - Integrity, Customer focus and Expertise - or 'ICE'. These values support our whole philosophy and way of working and we are always looking to attract talented individuals with either industry knowledge or specialist skills that will help us deliver consistently to these values.

Commitment to Diversity and Inclusion

We have a clear commitment to equality of opportunity and diversity encouraging fairness and equality of treatment for all. As such we encourage applications from all backgrounds.

We recognise the value of a workforce in which people from diverse backgrounds are encouraged to introduce fresh ideas and contribute to the business goals.

We are committed to providing a diverse and inclusive environment with inclusive employment policies, such as progressive flexible working and parental policies.