Job Summary

Main Duties

• Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
• Document any changes to data architecture.
• Document source-to-target mappings.
• Re-engineer manual data flows to enable scaling and repeatable use.
• Support the build of data streaming systems.
• Write ETL / ELT scripts and code to make sure the process performs optimally.
• Develop data models to support self-service business intelligence reporting that can be re-used to enforce data standards and quality.
• Build accessible data for analysis.
• Recognise opportunities to re-use existing data flows.
• Lead the build of data streaming systems.
• Lead work on database management
• Define and implement database architectures that meet business requirements for data availability within budgetary constraints.
• Support Geographical Information System (GIS) and the visualisation of data to aid organisational and operational needs.
• Provide third line support of incidents and problems through systematic investigation and root cause analysis. To determine options for remediation and apply these accordingly.

Responsibilities and Skills

• Communication skills (data). You know about the need to translate technical concepts into non-technical language and understand what communication is required for internal and external stakeholders.
• Data analysis and synthesis. You know how to undertake data profiling and source system analysis and can present clear insights to colleagues to support the end use of the data.
• Data development process. You can design, build and test data products based on feeds from multiple systems using a range of different storage technologies and/or access methods. You know how to create repeatable and reusable products.
• Data innovation. You know about opportunities for innovation with new tools and the use of data.
• Data integration design. You can deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof.
• Data modelling. You understand the concepts and principles of data modelling and can produce, maintain, and update relevant data models for specific business needs. You know how to reverse-engineer data models from a live system.
• Metadata management. You can work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You know how to maintain a repository to ensure information remains accurate and up to date.
• Problem resolution (data). You know about the types of problems in databases, data processes, data products and services.
• Programming and build (data engineering). You can design, code, test, correct and document simple programs or scripts under the direction of others.
• Technical understanding (data engineering). You understand core technical concepts related to the role and can apply them with guidance.
• Testing. You can execute test scripts. You understand the role of testing and how it works.
• To support and maintain the Force Geographical Information System (GIS) through a full spectrum of GIS activities.
• To undertake Continuing Professional Development (CPD) activities such as instructor-led-training, e-learning and workshops in order to keep abreast of new technologies so that they can be implemented within force.

Person Specification

The successful application should possess the following:

• A relevant degree or equivalent industry recognised qualification
• At least 3 years of professional experience across a variety of software applications
• At least 3 years previous technical experience in a client server environment preferably using Microsoft technologies, and experience of using Visual Studio and source control software
• Enhanced literacy skills, e.g. composing original letters, statements or writing minutes.
• Enhanced computer/keyboard skills, e.g. the ability to input/retrieve information from spreadsheets/database systems, where accuracy is important, but speed is not a key demand.
• Advanced numerical skills, e.g. the use of complex statistical and/or algebraic formulae, forecasting, use of alternative number systems
• Able to work under pressure to meet specific deadlines whilst ensuring attention to detail.
• Able to work on one's own initiative as well as part of a team.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.