[BE17] Data Analyst

Data Analyst – Job Description
SCRM – LIDL Digital Hub

About the role
We are looking for a Product Data Analyst who will share our passion for excellence and continuous challenge. We are seeking a driven and detail-oriented Product Data Analyst to join our agile team. This key role will be centered around a specific product and will require an individual who is confident in making data-driven decisions autonomously, with the backing of a knowledgeable and collaborative team. This role will involve a balance of in-depth data analysis, data quality assurance, cross-functional collaboration, and a business-oriented approach, all in service of our mission to continuously improve our products. We seek individuals who are meticulous, capable problem-solvers and possess a strong aptitude for data analysis. If you are excited by the prospect of uncovering trends in large datasets and translating data-driven insights into actionable strategies, we would be delighted to hear from you.

In this Role, you'll get to:

1. Act as a data referent for a designated product within an agile squad, leading all data-related activities and decisions.
2. Define product tracking requirements enabling the measurement of product performance.
3. Perform comprehensive data analysis, leveraging large datasets to generate actionable insights that will shape product development and improvements.
4. Ensure the quality and consistency of product-related datasets within our data ecosystem, identifying areas for continual improvement.
5. Develop, implement, and manage efficient data pipelines to support data extraction and analysis, enhancing the quality of insights for both product development and customer experience.
6. Champion a culture of data-informed decision-making within the squad and the wider organization, educating team members on the benefits of a data-focused approach.

Required Skills:

1. A Bachelor's degree in a technical field or equivalent experience.
2. A solid understanding of data structures and data manipulation methodologies.
3. Familiarity with data management tools and their application to both structured and unstructured data.
4. Knowledge of Python (Pandas, Matplotlib...) and SQL for data extraction and manipulation.
5. Excellent collaboration and communication skills, with a demonstrated ability to work effectively in a multidisciplinary agile team.

Extra points:

1. Experience with Databricks (preferably Azure), Snowflake, and BigQuery.
2. Experience with PySpark and SQL for advanced data manipulation and analysis.
3. Familiarity with Git (Azure DevOps) for version control and CI/CD operations.
4. Experience with NoSQL systems and Big Data tools (MongoDB, CosmosDB, HDFS, HBASE...).
5. Practical experience using Jira, Confluence, and other Atlassian tools in agile development.
6. Previous experience in a Cloud environment, preferably Azure.
7. Experience with orchestration tools such as Airflow and DBT.
8. Previous experience in A/B testing design and results analysis.
9. Previous experience working in Mobile App products with Firebase as a tracking tool.

Our Stack:

1. Databricks with PySpark for large-scale data processing and analytics.
2. Snowflake and SQL for structured data storage and querying.
3. Visual Studio / PyCharm for code development.
4. JIRA and Confluence for knowledge management and team collaboration.
5. Azure DevOps for version control and development operations.
6. Airflow and DBT for data orchestration and transformation.
7. PowerBI as a dashboarding tool.

About us
Who we are SCRM was created in 2015 with a vision of the future that foresaw "business and technology forever remaining intertwined", and a steadfast mission to guide traditional businesses towards digital evolution through their clients, data, commercial strategies, and omnichannel communication. Specialising in digital strategy, automation, and real-time offer and content customisation, SCRM owes its success and efficiency to the use of cloud computing and the development of data platforms which rely on artificial intelligence for automatic decision-making in large-scale consumer and retail markets.

SCRM Lidl International Hub - Three years later, Lidl has absorbed the company and turned it into their international hub of digitalisation and customer intelligence. Amongst our missions as Lidl's International Hub, we would highlight the following:

1. The conceptualisation and development of Lidl Plus, a Lidl international relational programme, and its benefit plan, which will offer discounts, exclusive services, agreements with third-party entities, and financial services as its fundamental features;
2. The creation of a cloud-based international platform for big data;
3. The development of an international marketing automation platform;
4. The conceptualisation, development, and management of business intelligence platforms;
5. The creation of an omnichannel payment platform;
6. The development of advanced analytics and machine learning platforms favouring customer recommendation, foresight, and analysis systems;
7. The creation and implementation of an omnichannel, single sign-on strategy to generate business opportunities amongst the group's diverse range of commercial platforms and services.

Perks of being part of our team:

1. Competitive salary package
2. Benefits plan
3. Meal voucher
4. Transport voucher
5. Childcare voucher
6. Health & Accident insurance
7. Hybrid work model
8. Flexible schedule and no dress code!
9. Summer hours July (Optional) and August
10. 23 days of holidays per year and Holy Thursday off
11. Language lessons: German, English & Spanish
12. Employee referral bonus
13. Long service awards
14. Company Sabbatical (3 months) after 5 years
15. Training budget
16. Wellbeing voucher (To do your favourite sports)
17. Filtered water, biscuits, fresh fruit, wide selection of teas and Nespresso coffee

SCRM is a company committed to diversity and equal opportunities. SCRM provides equal employment opportunities to any job applicant or employee and confirms that it is committed to ensuring that there shall be no direct or indirect discrimination against, or harassment of, job applicants or employees on grounds of race, creed, colour, ethnic origin, nationality, gender, gender reassignment or transsexualism, religious or other similar beliefs, age, marital or family status, sexual orientation, or disability.