Data Warehouse Developer

3 weeks ago

Wath upon Dearne, United Kingdom Optimise by Recruitment Full time

Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.


This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design, development, and maintenance of the company’s data warehouse. This role involves working closely with business stakeholders, data analysts, and the IT team to ensure the data warehouse meets business needs and performance standards.


Responsibilities:

  • Design and develop data models and schemas for the data warehouse.
  • Build and maintain ETL (Extract, Transform, Load) processes to integrate data from various sources.
  • Develop complex SQL queries and scripts to ensure efficient data retrieval and manipulation.
  • Responsible for the build and deployment of data warehouse capabilities.
  • Ensure data quality and integrity through validation and cleansing processes.
  • Implement data warehousing best practices for data ingestion and transformation.
  • Optimise database performance, including indexing, partitioning, and query optimisation.
  • Monitor and troubleshoot performance issues to ensure high availability and efficiency.
  • Work closely with business analysts and stakeholders to understand data requirements.
  • Collaborate with IT and development teams to ensure proper integration of the data warehouse with other systems.
  • Maintain and support existing data warehouse infrastructure.
  • Develop and maintain documentation for data models, ETL processes, and workflows.
  • Provide support for data-related issues and ad hoc queries from end-users.


Requirements:

  • Minimum 3-5 years’ experience developing and implementing Data Warehouse solutions within financial services (ideally Consumer Credit).
  • Proven experience in data warehousing, data modelling, and database design.
  • Proficiency in SQL (SSMS) and experience with ETL tools (e.g., SSIS, SAS DI, Informatica, Talend).
  • Experience with data warehouse platforms (e.g., Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake).
  • Familiarity with BI tools (e.g., Power BI, Tableau).
  • Strong understanding of database management systems (DBMS).
  • Knowledge of data warehousing concepts such as star schema, snowflake schema, and data marts.
  • Experience with scripting languages (e.g., SQL, Python, Shell scripting) is desirable.
  • Excellent problem-solving skills and attention to detail.
  • Effective communication and collaboration skills.
  • Ability to manage multiple tasks and meet deadlines in a dynamic environment.
  • Certifications in data warehousing or related technologies preferred.
  • Experience with cloud-based data warehouse solutions is a must.
  • Familiarity with data governance and data security best practices.


What We Offer:

  • Competitive annual salary up to £40,000, potentially up to £60,000 if combined with Credit Risk Analyst role.
  • Free parking and a company pension.
  • Continuous learning program and employee assistance program.
  • Access to discounts with leading high street names.


From the moment you join the team, they are committed to providing continuous learning opportunities tailored to your needs and their requirements. Together, as a team, they inspire and uplift each other, striving to achieve excellence in everything they do. Join them in their journey to 'be the best they can be'

  • Data Warehouse Developer

    2 weeks ago

    Wath upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 days ago

    Wath upon Dearne, Rotherham, United Kingdom Optimise by Recruitment Full time

    Job DescriptionOptimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance. This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath-Upon-Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath upon Dearne, United Kingdom Optimise By Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.Read the overview of this opportunity to understand what skills, including and relevant soft skills and software...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance. This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    3 weeks ago

    Wath upon Dearne, United Kingdom Optimise By Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.Read the overview of this opportunity to understand what skills, including and relevant soft skills and software...

  • Data Warehouse Developer

    3 weeks ago

    Wath-Upon-Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    4 days ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    5 days ago

    Wath-Upon-Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    4 days ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance. This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    5 days ago

    Wath Upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    5 days ago

    Wath upon Dearne, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    4 days ago

    Wath upon Dearne, United Kingdom Optimise By Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.Ensure all your application information is up to date and in order before applying for this opportunity.This newly...

  • Data Warehouse Developer

    3 weeks ago

    Wath Upon Dearne, UK, Rotherham, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...

  • Data Warehouse Developer

    5 days ago

    Wath Upon Dearne, UK, Rotherham, United Kingdom Optimise by Recruitment Full time

    Optimise by Recruitment are excited to be partnered with one of the most successful UK lenders in their market. They are a dynamic financial service business that provides innovative solutions in credit risk assessment and sustainable finance.This newly created role of Data Warehouse Developer reports to the Head of IT and is responsible for the design,...