Data & Reporting Specialist

Stellenbeschreibung:

Design, develop, and maintain data and reporting solutions that support operational and financial business requirements
Develop and optimize ETL processes using advanced Excel VBA and Macros to extract, transform, and load data into SQL Server environments
Create and maintain SQL Server data models, queries, stored procedures, and functions to ensure scalable and reliable data management
Develop Power BI dashboards and reports that provide visibility into business performance, trends, and key operational metrics
Collaborate with business stakeholders to gather reporting requirements and translate them into practical analytical solutions
Identify opportunities to improve reporting processes, data quality, and operational efficiency through automation and standardization
Support continuous improvements within reporting, business intelligence, and data management processes

Requirements

Degree in Computer Science, Information Systems, Data Analytics, Finance, or a related field
Advanced experience with Excel VBA and Macro development in an operational or financial reporting environment
Demonstrable experience with SQL Server, including data modeling, query development, stored procedures, and functions
Hands‑on experience creating Power BI reports, dashboards, and data visualizations
Strong analytical and problem-solving skills with the ability to work with complex datasets and reporting requirements
Ability to collaborate effectively with stakeholders and translate business needs into reporting solutions
Experience with Microsoft PowerApps and Power Automate development is advantageous

Core Competencies

Demonstrates expertise in developing and optimizing ETL processes using Excel VBA and SQL Server, alongside creating impactful Power BI dashboards and reports. Strong analytical skills and stakeholder collaboration are essential for translating business needs into effective reporting solutions.