Data Engineer

Job Description

Job Title: Data EngineerLocation: Newcastle/ HybridDuration: PermSanderson Recruitment are currently seeking a Data Engineer for on of the largest forces in the North East.The Role: Are you an enthusiastic and experienced Data Engineer interested in playing a key role in serving your community through the provision of exciting new technology that will support our staff to deliver an outstanding public serviceAs a passionate Data Engineer, you will take a leading role in crafting, shaping, and maintaining the cutting-edge Force data structures and models, driving our strategic data management to new heights. Your expertise will be pivotal in nurturing the growthand success of our central data hub.This thrilling opportunity will allow you to unleash your creativity and innovation as you construct brand new data pipelines and enhance existing ones, leveraging the latest and most appropriate technologies. Your meticulous attention to detail will ensurethat each pipeline and the hub itself undergoes extensive data quality and integrity checks, guaranteeing the utmost reliability and accuracy.Responsibilities:

• As a Data Integration Specialist, your role will be to revolutionise how we handle data at the Force. Youll be responsible for crafting and delivering cutting-edge data integration solutions, transforming Exact Transform Load (ETL) processes into dynamicand efficient data structures. Your expertise will be crucial in designing reusable metadata that sets the foundation for seamless data interoperability.
• One of your exciting challenges will be to perform and support ETL processing, enhancing the Forces data connectivity and efficiency. Youll take the lead in evaluating and optimising existing ETL processes, such as Stored Procedures, Packages, Functions,and Cursors, while also exploring new ETL technologies to stay ahead of the game.
• Your support and guidance will be vital in ensuring that data within projects and initiatives is effectively and sustainably utilised. By understanding the unique needs of the Force, youll help drive responsive and secure data and information provision,empowering the organisation to make informed decisions.
• Your innovative mindset will shine as you uncover opportunities for data-driven breakthroughs. Youll be at the forefront of identifying and harnessing existing and future data capabilities, fostering a culture of forward-thinking and progress.

Requirements:

• Possess a degree, HND, or equivalent qualification, and/or have extensive relevant experience.
• Demonstrated expertise in data analysis and delivery within data integration environments, including data warehousing, data lakes, and enterprise service bus.
• Proficient in utilising Microsoft SQL and PowerShell to create effective ETL solutions and experienced in both relational and multi-dimensional data models.
• Proven track record with relational database technologies such as Oracle and SQL Server.
• Skilled in handling diverse data types beyond traditional RDMS, including CDC and various file types.
• Familiarity with data interoperability and Integration frameworks and well-versed in ETL best practices.
• Experience with orchestration, logging, monitoring, and alerting solutions.
• Knowledgeable in master data management and data life-cycle management.
• Awareness of the Ethical Standards Framework related to data management.
• Expertise in data conformity methods for enterprise data management.
• Previous experience using an ITSM tool.

Please Note:Due to the nature of this organisation all applicants must be a resident of the UK for a minimum period of 3 years to ensure vetting checks can be successfully performed. A job offer will be dependent upon vetting clearance, medical information andreferences.