Lead Data Engineer

Location

Church, Lancashire | United Kingdom

Job description

Our client seeks a Lead Data Engineer to join their team. Role Profile: The Senior Data Engineer will develop and maintain the systems used to transform data (ETL, ELT) into accurate fact and dimension datasets. Ensure these datasets are used as a single source of truth for the business reporting needs, including reports built outside the team by power users. Work with members of the data team and external power users to promote best practices for writing SQL scripts and reports. Lead the design and implementation of business wide data architectural approaches that scale to handle business demands. Act as a data governance champion within the group while always promoting best practises and controls. Key Responsibilities:Assess, research, and analyse business and system needs, exploring alternative options to recommend data technology solutions and designs that meet business needs and deliverables including component reusability, data sharing and security.Leads detailed design phases for data and information projects/programmes identifying, tracking, and resolving technical issues.Prepares high-level and detailed data and information technical specifications for projects in accordance with Group security and architecture documentation objectives.Conducts data platform analysis, making recommendations to assist in the design and implementation of a Data and IT strategy.Assists with determining the best mix of development, interfacing applications, third party vendor solutions to meet data project requirements and business objectives.Contributes to successful project completion by identifying risks and developing / recommending mitigation strategies in line with best practice data standards.Identifies opportunities to improve data quality and management information by both data input enhancements, database management, and reporting.Designs & maintains comprehensive reports, datasets to support business reporting needs.Ensures adequate technical documentation and staff training as required.Builds and maintains reports (PowerBI and others) or datasets using the best fit, of available toolsets, ensuring that the data is correct and that the datasets in the report do not impact performance.Creates and maintains advanced SQL Stored Procedures to populate fact tables at specific intervals for use in reporting.Builds and maintains ETL SSIS packages to process data from internal systems and 3rd parties and then populate to allow for reporting. Ensure that this data is correct and that any issues are reported and actioned in good time.Builds or maintains SSIS packages for tasks other than ETL.Builds databases to the supplied schema and data dictionary.Produces existing reports when required, analyses and tests the results.Planning, Implementation & Support.Develop detailed plans and accurate estimates for completion of build, system testing and implementation phases of projects.Manage 3rd party development, testing and plans, co-ordinate implementations.Manage enhancements to data input, databases, and database environment.Perform performance turning to improve performance over multiple functions.Provide support of business applications databases and data sets.Provide out of hours support as required to meet business demands. If you have the required skills please apply online at searchandselect.com quoting reference number: 14240

Job tags

Salary