Data Analytics & Automation Specialist

Jobtailor; Köln; Vor Ort; EUR 70.000 - 100.000; Vollzeit

Zusammenfassung

Jobtailor in Köln, Germany, seeks a data analytics professional to build scalable data structures and develop predictive models. You will leverage Python, SQL, VBA and the MS Power Platform to elevate sales controlling, ensure high data quality and support digital transformation in Sales & Marketing.

You will translate data into actionable strategies, analyze market potential, and present insights to senior management. Excellent German and English communication is essential.

Qualifikationen

• University degree in (business) informatics, computer science, economics with a quantitative focus or a comparable field of study.
• Several years of relevant professional experience in quantitative data analysis, data science or market analysis, and experience in Sales & Marketing – preferably in the automotive sector.
• Strong analytical and communication skills with the ability to think critically and creatively.
• Expert knowledge of MS Office applications (especially Excel including VBA, PowerPoint) and the MS Power Platform.
• Very good programming and database skills in Python and SQL, and experience with Google Dataform & BigQuery.
• Extensive knowledge in Artificial Intelligence; practical experience with AI implementation projects is a strong advantage.
• Excellent written and spoken German and English skills.

Aufgaben

• Build efficient and scalable data structures.
• Develop and manage compliance‑compliant applications (using Python, SQL, VBA and the MS Power Platform) to elevate sales controlling and ensure the highest data quality.
• Analyze complex dealer, customer and campaign data to predict future customer behavior and preferences.
• Develop custom forecasting and predictive models to make trends visible early and identify concrete growth and optimization opportunities.
• Support the digital transformation in Sales & Marketing.
• Analyze existing business processes, identify automation potential and design modern solutions – from establishing automated data flows to digitizing entire processes, for example through the targeted use of AI technologies.
• Translate raw data into actionable business strategies.
• Uncover new market potential in financing, leasing and insurance businesses, define tailored target audiences for marketing campaigns and support strategic growth initiatives from concept to implementation.
• Provide insights that form the basis for business decisions.
• Create meaningful management reports and present recommendations directly to senior management.
• Conduct data‑driven competitive analyses, evaluate market position and performance against industry benchmarks, and derive strategic actions.

Kenntnisse

Data analysis

Python

SQL

Excel (VBA)

Power Platform

Google Dataform

BigQuery

AI knowledge

German & English

Data modeling

Ausbildung

University degree in business informatics / CS / economics

Tools

Google Dataform

BigQuery

MS Power Platform

MS Excel/VBA

Jobbeschreibung

Job Responsibilities

• Build efficient and scalable data structures.
• Develop and manage compliance‑compliant applications (using Python, SQL, VBA and the MS Power Platform) to elevate sales controlling and ensure the highest data quality.
• Analyze complex dealer, customer and campaign data to predict future customer behavior and preferences.
• Develop custom forecasting and predictive models to make trends visible early and identify concrete growth and optimization opportunities.
• Support the digital transformation in Sales & Marketing.
• Analyze existing business processes, identify automation potential and design modern solutions – from establishing automated data flows to digitizing entire processes, for example through the targeted use of AI technologies.
• Translate raw data into actionable business strategies.
• Uncover new market potential in financing, leasing and insurance businesses, define tailored target audiences for marketing campaigns and support strategic growth initiatives from concept to implementation.
• Provide insights that form the basis for business decisions.
• Create meaningful management reports and present recommendations directly to senior management.
• Conduct data‑driven competitive analyses, evaluate market position and performance against industry benchmarks, and derive strategic actions.

Requirements

• University degree in (business) informatics, computer science, economics with a quantitative focus or a comparable field of study.
• Several years of relevant professional experience in quantitative data analysis, data science or market analysis, and experience in Sales & Marketing – preferably in the automotive sector.
• Strong analytical and communication skills with the ability to think critically and creatively.
• Expert knowledge of MS Office applications (especially Excel including VBA, PowerPoint) and the MS Power Platform.
• Very good programming and database skills in Python and SQL, and experience with Google Dataform & BigQuery.
• Extensive knowledge in Artificial Intelligence; practical experience with AI implementation projects is a strong advantage.
• Excellent written and spoken German and English skills.