Data Warehousing Developer

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. 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. 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. 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. 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.