Data Analyst
Phare Consulting Group · Altstadt, Düsseldorf · Full time · Remote
At a glance
Data Analyst at Phare Consulting Group, working with Python, SQL and Power BI / Tableau — fully remote.
- Location
- Altstadt, Düsseldorf
- Work mode
- Remote
- Job type
- Full-time
- Technologies
- Python, SQL, Power BI / Tableau
- Language
- English-speaking role
Key requirements
- Load client sales, price, and customer data into the analysis database and identify gaps and errors.
- Agree on data fixes with clients and perform price, volume, and margin analyses using SQL and Python.
- Create and maintain Power BI dashboards for project teams.
- Document all data sources and analysis steps.
- Present findings to the project team.
Hirepins insights
- Python is asked for in 23% of the 13 live IT jobs in Germany on Hirepins.
- SQL is asked for in 23% of the 13 live IT jobs in Germany on Hirepins.
About this role
Phare Consulting Group is hiring a Data Analyst in Germany to clean, validate, and analyze sales and pricing data for German clients. The role involves SQL, Excel, and building Power BI dashboards, suitable for candidates with a quantitative degree and some business data analysis experience.
Key details
- Location: Altstadt, Düsseldorf
- Work mode: Remote
- Contract: Permanent, full-time
- Level: Mid-level
What you'll do
- Load client sales, price, and customer data into the analysis database and identify gaps and errors.
- Agree on data fixes with clients and perform price, volume, and margin analyses using SQL and Python.
- Create and maintain Power BI dashboards for project teams.
- Document all data sources and analysis steps.
- Present findings to the project team.
What you'll need
Must have
- A degree in economics, statistics, computer science or a related field
- SQL
- Excel, including pivot tables
- Some experience analysing business data from a job, internship or thesis
Nice to have
- Python or R
- Power BI or Tableau
- Experience with pricing, sales or customer data
Tech stack
SQL, Excel, Python, Power BI, Tableau
What's on offer
- 30 days of holiday plus public holidays
- Employer contribution to a company pension (bAV)
- Yearly budget for courses, certifications and books
- Laptop and home desk setup
- Flexible hours around shared core hours
How to stand out for this role
Likely interview topics
- Data cleaning and gap identification techniques
- SQL query building for price, volume, and margin analysis
- Creating and customizing Power BI dashboards
- Communicating findings to clients and project teams
- Documenting data sources and analytical steps
Keywords to mirror in your CV
Data Analyst, SQL, Power BI, Python, pricing data, customer data
What to show
- A case study showing how you cleaned a sales dataset, identified errors, and documented the process.
- An interactive Power BI dashboard built from sample pricing or sales data, with accompanying SQL queries.
- A short Python script or notebook performing price, volume, and margin calculations on a realistic dataset.
How to apply
Use the "Apply on company website" button to continue to Phare Consulting Group's careers page and submit your application there.
Source: Adzuna