Data Analyst
Posted Updated
Summary
Phare Consulting Group is hiring a remote-in-Germany Data Analyst to clean, validate and model client sales and pricing data, run price/volume/margin analyses in SQL and Python, and build Power BI dashboards for project teams.
What This Job Is:
Several German clients have given Phare years of sales and pricing data so we can test their next price changes. The data has to be cleaned, checked and modelled by someone close to those clients, so Phare is hiring a Data Analyst in Germany. You work from home anywhere in the country; leadership sits in Miami, six hours behind, so a few calls land in your afternoon.
Your Tasks:
#LI-Remote
Several German clients have given Phare years of sales and pricing data so we can test their next price changes. The data has to be cleaned, checked and modelled by someone close to those clients, so Phare is hiring a Data Analyst in Germany. You work from home anywhere in the country; leadership sits in Miami, six hours behind, so a few calls land in your afternoon.
Your Tasks:
- Load client sales, price and customer data into our analysis database;
- Find gaps and errors in it and agree fixes with the client;
- Build price, volume and margin analyses in SQL and Python;
- Create Power BI dashboards for the project teams;
- Document each data source and every step applied to it;
- Present what you find to the project team.
- A degree in economics, statistics, computer science or a related field
- SQL and Excel, including pivot tables
- Some experience analysing business data, from a job, an internship or a thesis
- Python or R (bonus)
- Power BI or Tableau (bonus)
- Pricing, sales or customer data (bonus)
• Open-ended contract (unbefristet), full-time, remote within Germany
• Thirty days of annual leave, public holidays on top
• Phare pays into a company pension (bAV)
• Money for courses, certifications and books every year
• We provide your work computer and home desk setup
• Flexible working hours
#LI-Remote