I am currently partnered with a Local Government agency in London on a long-term programme of work & they require a Developer experienced in Data and Analytics solution design and implementation using Agile and equivalent methodologies who will be working as part of a development team whose responsibility is to deliver complex data and BI products.
Detailed knowledge of ETL, data warehousing, data modelling and experience dealing with big data is expected. Along with good knowledge of data schema structures, design and how they can be correctly applied to deliver robust solutions that meet specifications.
Knowledge of emerging data technologies as well as database design, AI concepts and data migrations are required.
The role is INSIDE IR35 & will require up to 2-days per week in my clients office in Central London.
Initial contract term will be for 12-months with strong indication of extension or renewal thereafter
Required Knowledge / Skills
- Detailed working knowledge of ETL/ELT, data warehousing/business intelligence methodologies and best practice including dealing with big data, cloud technology and unstructured data and the relative required approaches
- Knowledge of star schema structure & design, detailed understanding of Kimball & Inmon and hybrid data warehouse design
- Detailed knowledge using cloud data products like Data Factory, Event Hubs, Data Lake, Synapse, Azure SQL server.
- Detailed knowledge in developing in Databricks and experience in coding with PySpark. Spark SQL
- ETL coding standards: ensuring that code is standardised, self-documenting and can be reliably tested
- Knowledge of best practice data encryption techniques and standards
- Knowledge of relevant national and international legislation pertaining to the Government/Public Sector IT - e.g. Data Protection Act, EU Procurement Directives and Freedom of Information Act, including knowledge of basic confidentiality and data protection requirements that apply to the processing of customer information
- Knowledge and interest in the latest and emerging technologies likely to be employed in designing and delivering Enterprise Wide quality solutions in the chosen platform
- Understanding and experience of tooling and technology that support all aspects of the Data and Analytics development lifecycle in an agile scrum environment
- Experience in design and development of complex data and analytics solutions in an iterative manner for large enterprise business /data warehouse implementations
- Experience in delivery of data and analytics solutions/applications to automate business processes and to meet user function and quality characteristics, including but not limited to; performance, availability, scalability, security, and integrity;