ETL Developer

InfoSum is the world’s leading data collaboration platform and used by the world's largest enterprise businesses to collaborate across data sources and deliver richer customer experiences that prioritise consumer privacy. Off the back of our Series B funding of $65 million in 2021, we are investing in our people and teams.

As our ETL developer, you will form part of the Data Science team who operate within the core technology function in InfoSum. You will own the transformation tooling and work closely with the domain area specialists to improve, optimise and validate the core capabilities of the InfoSum platform. You will also manage bespoke data driven projects to support stakeholders with individual experiment needs and define success metrics in close collaboration with the core tech team and analysts to help evaluate and communicate experiment insights to relevant stakeholders. You will also be working closely with our customers to help understand their data and workflows with the intention of building ETL pipelines to support their needs.

InfoSum is a people-first organisation, we can offer you the personal and professional flexibility needed to get the job done, to grow with us, and help challenge the status quo. If you want to work with a business that encourages collaboration, champions the idea that the sum is greater than its parts, then we want to hear from you.

What will you be doing?

• Design, implementation and maintenance of database extract and load processes (ETL) using InfoSum’s ETL language and tools - Develop functions / procedures used by said ETL processes
• Perform dimensional modelling - building fact, dimension and aggregate tables for common operations
• Develop and manage data delivery services
• Extracting and processing data from various databases and other external sources with good optimisation techniques to speed up query execution
• Transforming client business requirements into optimal data solutions
• Developing monitoring tools to allow timely response to service breakdown
• Developing reports and data extracts as the business requires
• Communicating with external and internal stakeholders
• Cross-functional collaboration to fulfil joint change request assignments
• Create dashboard visualisation
• Getting up to speed with new ETL and stream processing tools and languages like Benthos and Bloblang

Requirements

• Strong SQL is essential. Experience with T-SQL.
• Highly proficient in ETL process development
• Strong experience with ETL tools such as Spark, AirFlow, Flink, AWS Glue, Informatica, SSIS or other ETL tools
• Highly proficient in Data Modelling
• Scripting Languages - experience with Python, Bash or PowerShell
• Performance tuning experience
• Experience working with large, complex data sets (Terabytes to Petabytes scale)
• Strong problem solving skills
• Strong communication, presentation and stakeholder management skills
• Good understanding of data governance concepts such as data ownership, data stewardship etc

Benefits

You will receive a competitive salary, 8% pension contribution, 12.5% annual discretionary bonus (based on personal and company performance), private health care, 25 days annual holiday (not inclusive of bank holidays) and the opportunity to receive share options. We have a fantastic brand new office in Basingstoke complete with a fully stocked fridge, in-house Chef for catered lunches and snacks.

For this role, we would ideally like for someone to be based locally and come into the office a couple times a week, however, if you are not local or require more flexibility, we can offer remote contracts with the expectation of office attendance 2 times a month.