Analytics Data Engineer

About Profitero Profitero is a leading global SaaS commerce platform that uses predictive intelligence to help brands anticipate, activate and automate their next best action to fuel profitable growth. Our technology monitors 70 million products daily, across 1200 retailers and 50 countries, helping brands optimise search placement, product content, pricing, stock availability, reviews and more. News outlets, including Good Morning America, The Wall Street Journal and Ad Age frequently cite and trust Profitero as a source of data for their stories. Now’s an exciting time to join our fast-growth business. Profitero has recently joined Publicis Groupe (a $13 billion global marketing services and technology company) as a standalone commerce division, infusing our business with significant product development resources and investment. while giving our employees an incredible launchpad for their careers. Profitero’s tech and data combined with Publicis’ tech, data and activation services positions us to be a true end-to-end partner for helping brands maximise eCommerce market share and profits. Come be a part of our fast-paced, entrepreneurial culture and next stage of growth. Location: We are based in Windsor, we will be looking to move to Reading in January 2025, applicants should be able to commute 3 days per week to the new office location. Overview We are inviting a Data Engineer to join our Analytics team that is creating a next-generation eCommerce intelligence service for retailers and manufacturers. We will be happy to welcome new team members who are not afraid of non-trivial tasks, can offer non-standard technical solutions, and take initiative. About the role: We are developing a new portfolio of analytical services to allow our customers to analyse eCommerce data. The process behind this development includes collection, processing, and presenting a big amount of data to the customer. It is developed using Snowflake, Sigma, and Python. Right now the data is hosted in GBQ, but we are in the process of migration to Snowflake. Profitero provides customers with data on how products perform online from various angles: prices, availability, placement, ratings and reviews, product content, etc. Customers can use dashboards, our web application or API connection to GBQ to get information about products performance online. The migration of existing services to Snowflake will cause us to rewrite certain data pipelines to adjust our client dashboards to the new technology stack. The data engineer in this team will be responsible for implementing those pipelines working with the BI team and Architecture team. Responsibilities: Design and build scalable and resilient Data & Analytics solutions Automate data workflows and optimize data processing for performance and cost Design and development of new data pipelines. Improvement of existing data pipelines by using data engineering best practices. Design and develop efficient, scalable data models that enable fast and accurate reporting while minimizing cost and query complexity Monitor and optimize data warehouse costs, leveraging Snowflake's cost management tools to ensure efficient data processing and storage usage Engage in proof of concepts and experiments Participate in overall testing and production maintenance Work closely with the BI Team and Architecture team to ensure smooth transition from GBQ to Snowflake Who you are: Bachelor's degree in Computer Science, Data Engineering, Data Science, Software Engineering or similar. A master’s degree is a plus. 1 years of related work experience Technical skills: Strong knowledge of Python and SQL with a minimum of 1 years of practical experience in data automation. Ability to write efficient and scalable code for data processing. Hands-on experience with Snowflake, including performance tuning (cloud cost efficiency, data volume handling), understanding cost management, and data sharing features. Knowledge of GBQ is a plus. Solid understanding of designing and optimising data pipelines and data models in a cloud environment. Experience in setting up ETL processes, knowledge of dbt is a plus. Expertise in working with scalable data architectures, including data warehouses, data lakes, and data pipelines. Experience with BI tools like Looker, Tableau, Sigma or similar is a plus. Soft Skills: Strong problem-solving skills with the ability to troubleshoot and resolve complex data issues. Excellent communication and collaboration skills Diligence and time management We expect: Ability to automate data workflows and optimize data processing for performance and cost. Experience developing solutions in a Cloud environment A natural interest in modern data processing technologies and the ability to learn new things Passion to get into the development process quickly and deliver good quality code Nice to have: Working experience in an Agile environment (Jira, Asana, Confluence) Understanding of distributed architecture features and challenges The above lists are not exhaustive, and the job holder is required to undertake such duties as may reasonably be requested within the scope of the post. Company benefits: Profitero is a company that cares about its employees. As a company we feel that as our employees are always going the extra mile, so should we. That’s why we offer fantastic benefit packages to all our employees, including: Competitive base salary Employee healthcare plan Dental care plan Eye care scheme Employee Assistance Programme (EAP) 24-hour online GP service Company pension scheme Cycle to work scheme 25 days holiday plus bank holidays Gym membership at 40% off Frequent social events Employee referral program Personal employee development plan Profitero Hero scheme Flexible working hours The above lists are not exhaustive and the job holder is required to undertake such duties as may reasonably be requested within the scope of the post. Profitero is committed to creating a diverse work environment and is proud to be an equal opportunity employer. All qualified applicants will receive fair consideration for employment. Profitero recruits, employs, trains, compensates and promotes regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected characteristics as required by applicable law.