Data & Reporting Specialist

Jobtailor; Hamburg; Vor Ort; EUR 65.000 - 95.000; Vollzeit

Zusammenfassung

Jobtailor in Hamburg is seeking a data and BI professional to design, develop, and maintain data and reporting solutions that support operational and financial needs. You will optimize ETL processes using Excel VBA and Macros to feed SQL Server environments and build robust data models.

You will create Power BI dashboards and reports that reveal performance, trends, and key metrics, and collaborate with stakeholders to translate business requirements into practical analytics.

Qualifikationen

• Advanced experience with Excel VBA and Macro development in a reporting environment.
• Demonstrable experience with SQL Server data modeling, queries, and stored procedures.
• Hands-on experience creating Power BI reports and dashboards.
• Strong analytical skills to handle complex datasets and reporting needs.
• Ability to translate business needs into reporting solutions with stakeholders.

Aufgaben

• Design, develop, and maintain data and reporting solutions for operations and finance.
• Develop ETL processes using Excel VBA to load data into SQL Server.
• Create SQL Server data models, queries, stored procedures, and functions.
• Develop Power BI dashboards and reports to reveal performance and trends.
• Collaborate with stakeholders to translate reporting requirements into solutions.
• Identify opportunities to improve reporting processes, data quality, and efficiency.
• Support continuous improvements in BI and data management processes.

Kenntnisse

Excel VBA

SQL Server

Power BI

Data Modeling

ETL Processes

Ausbildung

Degree in CS/IS/Analytics/Finance

Tools

PowerApps

Power Automate

Excel Macros

SQL Server

Jobbeschreibung

• 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.

Highest-signal resume keywords

• Excel VBA Development
• SQL Server Data Modeling
• Power BI Dashboard Creation
• ETL Process Optimization
• Analytical Problem-Solving

ATS Optimization Keywords

Hard Skills

• ETL Processes
• SQL Queries
• Stored Procedures
• Data Functions
• Data Visualization
• Data Management
• Reporting Solutions
• Data Quality Improvement
• Automation
• Standardization

Soft Skills

• Collaboration
• Stakeholder Engagement
• Analytical Thinking
• Problem-Solving

Industry Keywords

• Data Analytics
• Business Intelligence
• Operational Reporting
• Financial Reporting

Tools & Technologies

• Power BI
• Excel Macros
• Microsoft PowerApps
• Power Automate
• SQL Server