Intermediate Data Engineer (Group Insights And Analytics) at PPS

Minimum Requirements    

Qualifications:

• An appropriate qualification (BSc – IT / Data Engineering or similar). 

Experience:

• Three years experience in a Data Engineering role building and optimizing data pipelines. Developing data acquisition, warehousing and reporting solutions.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases, technologies, languages and visualisation engines (Power BI, Tableau).
• Experience building analytics tools that utilize the data pipeline to provide actionable insights into customer management, operational efficiency and other key business performance metrics

Knowledge:

• Knowledge and understanding of the best practices of the financial services / graduate professional client market.
• Knowledge of information management practices including information lifecycle management, data modelling, master data management and carrying out business audits and requirements gathering.
• Knowledge and understanding of relevant database and query solutions, applications and tools.
• Knowledge and appreciation of the need for consistency in data management and governance.

Duties and Responsibilities    

• Implementing data strategies and systems, to build and maintain the data architecture that will drive various initiatives across the organisation.
• Automate extremely high volumes of data delivery and creatively solve data volume and scaling challenges. Contribute to the design and architecture of innovative solutions to difficult problems.
• Work with team and stakeholders to continually assess and redefine data technology stack to support changing data patterns and business use cases and to bridge the gaps between Data Analytics (Engineering), Business, and Product by raising with the Group Head and Senior Data Engineer.
• Monitor the infrastructure with IT which is required  for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies.
• Work with IT to source and load a wide range of data across our business into the data lake so that it can be used by analysts and developers to develop data solutions for the business.
• Manage the data ingestion framework using specified toolsets and will need to understand and continuously seek techniques to ingest data, as well as ensure a high degree of quality and confidence.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Liaise between technical teams and specialists and business stakeholders, fostering inter-departmental coordination and co-operation.
• Data Governance (Quality, Accessibility, Ownership and Security). Engage with stakeholders to obtain an understanding of their data practices to contract, manage and meet expectations.
• Identifies data quality issues, conducts root cause analysis and provides feedback to the Senior Data Engineer.
• Influence decision making by providing an advisory service, guidance and support on data quality practices.
• Maintaining a thorough understanding of the business and data strategy.Identify opportunities to influence the improvement or enhancement of business processes and methodologies by researching and recommending improvement initiatives and effective ways to operate and add value to PPS.
• Train other employees in the organization on how to access the Data Ecosystem and how to make the best use of its content.