Job Title: Data Warehouse Developer
Hours: Monday to Friday 9 am - 5.25-day annual leave entitlement, plus bank holidays.
- A Continuous Learning Program to keep you in the loop with relevant progression within the business and changes to economic mechanics, policies, and procedures.
- Free onsite parking.
- Employee assistance programme, and financial well-being support
- Great discounts with leading high street names.
- Workplace Pension is provided by Scottish Widows
About the position of Data Warehouse Developer
Working for a leading home improvements lender driving positive market change, we have a newly created vacancy available for a Data Warehouse Developer, reporting to the Head of IT. You will be 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 required for the role of Data Warehouse Developer
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 a data warehouse capability
Integrate data from multiple internal and external sources into the data warehouse.
Ensure data quality and integrity through validation and cleansing processes.
Implement data warehousing best practices for data ingestion and transformation.
Optimize database performance, including indexing, partitioning, and query optimization.
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.
Support the IT team with ad hoc requests such as reporting, hardware refreshes etc.
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.
Experience required for the role of Data Warehouse Developer
Experience in developing and implementing Data Warehouse solutions for managing data and information
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, etc.)
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.
Must have previous knowledge and experience of all data warehousing processes.
Certifications in data warehousing or related technologies.
Experience with cloud-based data warehouse solutions is a MUST.
Familiarity with data governance and data security best practices
For more information regarding the role of Data Warehouse Developer please contact us on