07.07.2025 aktualisiert
PB
100 % verfügbar
Senior Data Analyst | 7+ Years | SQL, Python, Power BI, Tableau
Darmstadt, Deutschland
Weltweit
Bachelor of Engineering - Computer ScienceSkills
A/B TestingAmazon Web ServicesData AnalysisANOVAAtlassian ConfluenceAtlassian JiraAutomatisierungBusiness IntelligenceBig DataWirtschaftliche EffizienzProzessoptimierungCloud ComputingComputerprogrammierungDatenbankenDatenvalidierung
1. Data Analysis & Business Intelligence
- Conducted in-depth data analysis using SQL, Python (Pandas, NumPy) to identify patterns, trends, and anomalies across multiple datasets.
- Created interactive dashboards in Power BI and Tableau to visualize KPIs for business stakeholders, improving decision-making and operational efficiency.
- Led the development of sales and productivity dashboards using DAX, enhancing reporting accuracy and data transparency.
- Executed comprehensive ETL testing and data migration validation using Informatica PowerCenter, IBM DataStage, and SQL to ensure data integrity.
- Validated and optimized large datasets during migrations from legacy systems to Snowflake and Oracle, reducing redundancy and improving data quality.
- Developed and implemented Python scripts to automate data cleansing, transformation, and comparison, leading to a 30% reduction in processing time.
- Built automated SQL scripts for system integration testing, increasing reliability and execution efficiency in test environments.
- Collaborated with stakeholders to define key performance indicators (KPIs) and built corresponding reports to track business performance.
- Conducted variance analysis and plan/actual comparisons to support strategic decisions across business units.
- Provided data insights to inform test hypotheses and supported outcome analysis for product optimization efforts.
- Familiar with hypothesis testing, statistical significance, and A/B test design, with the ability to interpret and present results clearly.
- BI Tools: Power BI, Tableau, Excel
- Databases: SQL Server, Oracle, DB2, Snowflake
- Languages: Advanced SQL, Python
- ETL Tools: Informatica PowerCenter, IBM DataStage
- Cloud Platforms: AWS
- Project Tools: JIRA, Confluence, HP Quality Center
- Led and mentored a team of 6 analysts, improving productivity by 20% through effective task management and process improvements.
- Strong communicator with the ability to translate technical insights into business context for diverse stakeholders.
Erfahrung
Berufserfahrung5 - 10 Jahre
Freelancer seit2024
Sprachen
DeutschGrundkenntnisseEnglischverhandlungssicher
Projekthistorie
- Led end-to-end data validation and BI reporting for enterprise-level projects.
- Designed and automated Python scripts for data cleansing and analysis, reducing processing time by 30%.
- Developed Power BI dashboards from scratch using DAX for advanced calculations.
- Defined KPIs and delivered actionable insights to stakeholders, improving operational efficiency by 18%.
- Mentored a team of 6 analysts, increasing team productivity by 20%.
- Collaborated cross-functionally to support data-driven business decisions.
- Conducted comprehensive data validation using Python for large datasets, improving efficiency by 40%.
- Created reusable SQL scripts to streamline System Integration Testing (SIT) and regression testing.
- Built real-time Power BI dashboards to support operational reporting and insights.
- Performed exploratory data analysis with Tableau to uncover customer behavior trends.
- Validated data migration to GCP BigQuery, ensuring accuracy and completeness.
- Managed defect tracking and reporting using JIRA and HP Quality Center.
- Delivered clear project status updates, achieving over 90% stakeholder satisfaction.
- Designed and tested data mappings in Informatica for seamless DB2 to Oracle migration.
- Performed extensive ETL and big data testing to ensure data pipeline accuracy.
- Validated data accuracy and metrics using SSAS cubes for business reporting.
- Ensured data integrity throughout the migration process with end-to-end testing.