Responsibilities will include:

Analyse the stakeholder reporting requirements from a data and functional perspective

• Identify, analyse and interpret trends in data sets
• Investigate and resolve data issues by identifying issues and liaising effectively with appropriate business and tech teams
• Transform and load the data into our standard database structure
• Acquire new data from various data sources and aggregate or consolidate data while maintaining quality assurance of data output to stakeholders
• Monitor production runs to ensure accuracy and on-time delivery of reports
• Adjust, maintain and configure existing ETL processes to ensure required data is made available within the data warehouse
• Engage in regular interaction with internal stakeholders to ensure that they’re being kept up-to-date with respect to data insights
• Ask questions or escalate to find solutions where appropriate
• Co-ordinate and produce bespoke data sets
• Process, cleanse, and verify the integrity of data used for analysis
• Collaborate with Data Scientists and Data Engineers on several projects

THE COMPETENCIES WE’RE AFTER

• Strong analytical skills with the ability to source, organise and analyse significant amounts of information with attention to detail and accuracy
• Can work quickly and accurately, within reasonable deadlines
• Effective communicator (verbal, written and interpersonal) and presentation skills
• Analytical and problem-solving skills
• Able to think creatively and relay insights from data
• Ability to work well in a team as well as individually

THE SKILLS AND EXPERIENCE WE’RE LOOKING FOR

• BSc degree or similar field (or equivalent)
• Demonstrated work experience in data analysis and reporting within financial services or the fintech space
• Strong SQL skills required to write and debug SQL, experience with functions, stored procedures, tables, views, etc.
• 3+ years experience with PostgreSQL and MSSQL
• 3+ years of Python experience
• Experience with visualisation tools, Mixpanel and Google Data Studio will be advantageous
• Excellent understanding of databases, data structures and concepts
• Experience with Agile methodologies