onsite
Business Intelligence / Data Analyst - Controlling - Sanacorp Pharmahandel GmbH
Data Analyst
Drive data‑driven decision making in controlling by designing, maintaining and enhancing BI solutions. Leverage SQL, Power BI and advanced Excel to transform complex datasets into actionable insights for finance and operations.
About the role
Key Responsibilities
- Design, develop and maintain Power BI dashboards and reports for controlling and finance teams.
- Extract, transform and load (ETL) data from ERP and other source systems using SQL and data integration tools.
- Analyze financial and operational data to identify trends, variances and improvement opportunities.
- Collaborate with cross‑functional stakeholders to define KPIs, data models and reporting requirements.
- Ensure data quality, integrity and compliance with internal controls and regulatory standards.
Requirements
- Proven experience (3+ years) in business intelligence or data analysis within a controlling or finance environment.
- Strong SQL skills and hands‑on experience with Power BI (data modeling, DAX, report publishing).
- Advanced Excel proficiency (pivot tables, advanced formulas, VBA optional).
- Solid understanding of financial statements, budgeting and variance analysis.
- Excellent communication skills in German and English, with the ability to translate technical findings into business insights.
Skills
sqlpower biexceldata analysis