This job is with St. James's Place, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.
The Data and Insights Division is comprised of four key areas: 1. Data Governance and Intelligence 2. Data Acquisition, Quality, Strategy and Literacy; 3. Data Insights; 4. Data Architecture, Platform and Engineering. This presents an opportunity to design a data strategy aligned with the organization's goals and execute the delivery of data effectively. D&I enables SJP to leverage value from its data through actionable insights and data led decision making.
The Data Architecture, Platform and Engineering(DAPE) Division integrates architecture, platform and engineering to establish guidelines, principles and development standards aimed at building a secure, resilient data platform for the future. It plays a key role in supporting the SJP data ecosystem, driving towards the SJP data strategy and advancing the decommissioning roadmap.
The role holder will be responsible for assisting Senior Data Engineers in designing, implementing and maintaining scalable data pipelines and systems allowing large datasets to be managed, processed and analysed effectively. They will understand that data flows need to be optimised, data quality measured, and appropriate technologies utilised. Throughout the development lifecycle they will ensure best practice standards are followed, and all work aligns to the appropriate guidelines.
What You'll Be Doing
* Helping design and implement scalable and efficient data pipelines as per requirements, ensuring robust ETL/ELT processes, enabling SJP to move from multiple sources to a centralised platform.
* Assisting in writing and optimising SQL queries and scripts to process data.
* Supporting the integration of data from different systems, ensuring that it is structured correctly for analysis.
* Maintaining data workflows and ensuring data is ingested and processed without errors and assisting in updating and maintaining existing data systems to help keep them current and efficient.
* tying connected with the latest data engineering technologies and trends, including cloud-based data platforms, data lakes, and real-time data processing.
* Continuously improving technical skills by learning new data engineering tools and techniques.
* Help monitor data pipelines to ensure they are running smoothly and troubleshoot minor issues as they arise.
* Help with identifying and resolving data issues, including missing or inconsistent data.
Who we're looking for:
We are looking for a passionate data professional who is keen to learn and develop their skills and learn from those around them. The successful candidate will have experience working in data engineering and/or data integration roles and will have exposure working with data tools including Snowflake, SQL, AWS and/or Azure.
Essential Criteria
* Experience working in a data engineering and/or data integration role
* Some knowledge and skills with data tools and technologies including Snowflake, SQL, AWS and/or Azure
* Exposure working alongside PMS, BAs, Testers, Developers and to project lifecycle best practice.
* Some skills in root cause analysis, troubleshooting and resolving performance issues/defects.
Desirable Criteria
* Strong Snowflake development experience
* Some stakeholder management and relationship building skills
* Bachelor's degree or equivalent in Data Science, Computer Science, Mathematics or similar STEM subject.
Special Requirements:
* Some business travel may be necessary
#J-18808-Ljbffr