Data Warehouse Developer - North West (Part remote) Our client is looking to expand their team of developers to help build quality software and also contribute to how they deliver a modern reporting platform. Using the latest tools you will be working with a team of like-minded individuals to deliver high-quality applications that meet their development standards, principles and patterns. Technical Skills Required Data focussed developer with the following skills: - Experience as a Data Warehouse Developer using the Microsoft stack including SQL Server (2012 - 2019), SSIS, SSAS, SSRS, Power BI
- Strong SQL for querying and creation of tables/views and stored procedures
- Experience in designing ETL processes including knowledge of data warehousing strategies and theories
- Develop new, maintain and improve existing ETL processes using SSIS and Azure Data Factory
- Understand dimension modelling ideally within a financial services sector
Demonstrable understanding of how to develop quality software through: - Testing frameworks and practices, including meeting NFRs
- Use of appropriate principles and patterns along with writing clean and secure code
- Integrating with monitoring and alerting frameworks
Ways of Working and Tooling: - Strong experience of agile development practices as part of a delivery squad/cell
- Strong experience and/or appreciation of agile project management software; e.g. Jira, TFS
- Strong experience and/or appreciation of Git based version control systems
- Strong experience and/or appreciation of CI/CD practices and tooling; e.g. TeamCity, Octopus, Azure DevOps, Jenkins…
Support: - Desirable experience providing third level support for production systems
Personal - Collaborative, able to communicate effectively with the team on day-to-day tasks and during ceremonies
- Self-motivated with a can-do attitude and takes pride in work
- Logical, analytical mind-set, able to solve problems without over-engineering
|
