Job Title: Data Warehouse Developer
Location: Rotherham
Salary: Up to £40,000
Hours: Monday to Friday 9 am - 5.30 pm
Benefits:
- 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.
- If you are a member of a professional body, then do let us know because we may consider covering the cost of your annual subscription/membership.
- 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. The ideal candidate will be heavily experienced in this area and able to demonstrate successful examples.
To successfully integrate with the team, you will be experienced at working at pace, and working closely with business stakeholders, whilst demonstrating excellent organisational and interpersonal skills.
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.
- Ability to manage multiple tasks and meet deadlines in a dynamic environment.
- 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
Stellar Select is acting as an employment agency and is a corporate member of the REC
Due to a high volume of applications, we will only contact you if your application has been successful. We aim to contact all successful contacts within two business days