Business Analyst; Data Engineer
Aktualisiert am 15.05.2020
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 15.05.2020
Verfügbar zu: 100%
davon vor Ort: 20%
Business Reporting
Data Warehouse
ETL Process
Business Analysis
SQL
Python
Microsoft SQL Server
Qliksense
Redshift
Airflow
Alteryx
Salesforce
Marketo
API
SSRS
VBA
English
Fluent
German
Intermediate
Spanish
Native speaker

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
möglich

Projekte

Projekte

6 Jahre 5 Monate
2017-11 - heute

Sales & Marketing Operations

Senior Data Engineer
Senior Data Engineer
  • Supported executives in defining and implementing Marketing and Sales KPIs.
  • Designed and developed dashboards on Periscopedata and QlikSense reporting applications.
  • Provided regular & adhoc reporting for investors and other stakeholders.
  • Acted as a Sales & Marketing data consultant for other departments, involved in KPI development and general reporting.
  • Provided repeatable reports through multiple technologies including Excel, OLAP (SSAS).
  • Developed data integration pipelines using Python and Airflow against Salesforce and Marketo APIs.
  • Acted as DBA of the Sales Ops reporting infrastructure.
  • Supported data quality and process reengineering efforts.
Tricentis GmbH, Zurich
Switzerland
2 Jahre 7 Monate
2015-05 - 2017-11

Business Intelligence/Process

Lead Business Intelligence/Process Engineer
Lead Business Intelligence/Process Engineer
  • Acted as Product Owner for a $300k ETL/DW development project. Prioritized tasks and facilitated alignment between stakeholders and development team.
  • Manages the Data Analytic team task backlog and appropriately aligned development priorities.
  • Drove efficiency gains through lean services and process focused Business Intelligence applications.
  • Developed and implemented a tender platform supporting price negotiations for a $9 billion valued business. This system serves 2 departments and 30 users with 8,000 clicks per month.
  • Systematized and developed the SQL ETL process for 30+ different data sources and 33,000 lines of code between T-SQL and VBA.
  • Analyzed tendering process value stream and identified opportunities to reduce lead time in 50% with no automation.
Walgreens Boots Alliance Development GmbH, Bern
Switzerland
5 Monate
2015-01 - 2015-05

Completed market research

Freelance- Business Analyst
Freelance- Business Analyst

Completed market research of online retail stores (FMCG), establishing basket price benchmark.

  • Evaluated and provided recommendations for outbound logistics options, driving efficiencies in purchased goods delivery.
Lakeside Invest & Consult, Konstanz, Germany
2 Jahre 8 Monate
2012-02 - 2014-09

Manufacturing

Senior Manufacturing Analyst- R & D
Senior Manufacturing Analyst- R & D
  • Identified equipment design requirements that enabled cost savings of $300k per machine.
  • Created business cases for global projects worth $5 million of total investment, while supporting the Project Manager in achieving alignment between key stakeholders (marketing, platform, engineering).
  • Developed & documented a print stability KPI data mart (T-SQL) which enabled generation of reports and analyses from a diversity of software solutions (Tableau, JMP, SSRS & Excel).
  • Managed a Business Intelligence intern including technical work, scoping, and priority setting.
  • Successfully conducted presentations for the CEO & leadership team regarding new technologies; including qualitative and quantitative analyses.
Vistaprint Schweiz Gmbh, Winterthur, Switzerland
7 Monate
2011-08 - 2012-02

Internship

Supply Chain Analyst
Supply Chain Analyst
University of St. Gallen, St. Gallen, Switzerland
6 Monate
2008-02 - 2008-07

Business Intelligence Internship- Supply Chain

Johnson Controls International, Valencia, Spain

Aus- und Weiterbildung

Aus- und Weiterbildung

2010

Budapest University of Technology and Economics, Hungary

Master?s Thesis: ?Lean Public Transportation.? 

2007-2010

Universitat Politecnica De Valencia, Valencia, Spain
Master?s: Industrial Management Engineering 

Specialization: Operations/ Supply Chain Management

2002-2007

La Universidad de La Laguna, Tenerife
Bachelor of Science: Computer Science 

Specialization: Business IT

Kompetenzen

Kompetenzen

Top-Skills

Business Reporting Data Warehouse ETL Process Business Analysis SQL Python Microsoft SQL Server Qliksense Redshift Airflow Alteryx Salesforce Marketo API SSRS VBA

Produkte / Standards / Erfahrungen / Methoden

Personal Statement:
The how we do it, is as important as the what we do. To empower teams and organizations in their data journey, is to combine business needs, streamlined processes and effective technology. My passion is to provide cross-functional solutions, that align stakeholders short-term needs with a long-term transformative view.

Software Skills:

  • Programming Languages: T-SQL, Python, SSAS, VBA
  • Reporting: Excel, QlikSense, Periscopedata, SSRS
  • Systems Knowledge: SQL Server, Salesforce, Marketo, Windows Server, Linux
  • Statistical Packages: R
  • ETL: Airflow, SSIS

Business Intelligence Expertise:

  • Process re-engineering (Lean)
  • Project management (Agile)
  • Dimensional modeling (Kimball)
  • Extract, Transform, Load (ETL)
  • Programming (T-SQL, Python)

Key Personal Skills:

  • Value stream focus.
  • Data-driven.
  • Strategic planner.
  • Entrepreneur.
  • Expert organizational skills.

Other work experience:

10/2009 - 01/2010
Universidad Nova, Lisbon, Portugal
Internship- Lean Research Associate

11/2010 - 04/2011
Ingenieria y Consultoria Insular, S.L.

Spain Junior IT Project Manager 

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
möglich

Projekte

Projekte

6 Jahre 5 Monate
2017-11 - heute

Sales & Marketing Operations

Senior Data Engineer
Senior Data Engineer
  • Supported executives in defining and implementing Marketing and Sales KPIs.
  • Designed and developed dashboards on Periscopedata and QlikSense reporting applications.
  • Provided regular & adhoc reporting for investors and other stakeholders.
  • Acted as a Sales & Marketing data consultant for other departments, involved in KPI development and general reporting.
  • Provided repeatable reports through multiple technologies including Excel, OLAP (SSAS).
  • Developed data integration pipelines using Python and Airflow against Salesforce and Marketo APIs.
  • Acted as DBA of the Sales Ops reporting infrastructure.
  • Supported data quality and process reengineering efforts.
Tricentis GmbH, Zurich
Switzerland
2 Jahre 7 Monate
2015-05 - 2017-11

Business Intelligence/Process

Lead Business Intelligence/Process Engineer
Lead Business Intelligence/Process Engineer
  • Acted as Product Owner for a $300k ETL/DW development project. Prioritized tasks and facilitated alignment between stakeholders and development team.
  • Manages the Data Analytic team task backlog and appropriately aligned development priorities.
  • Drove efficiency gains through lean services and process focused Business Intelligence applications.
  • Developed and implemented a tender platform supporting price negotiations for a $9 billion valued business. This system serves 2 departments and 30 users with 8,000 clicks per month.
  • Systematized and developed the SQL ETL process for 30+ different data sources and 33,000 lines of code between T-SQL and VBA.
  • Analyzed tendering process value stream and identified opportunities to reduce lead time in 50% with no automation.
Walgreens Boots Alliance Development GmbH, Bern
Switzerland
5 Monate
2015-01 - 2015-05

Completed market research

Freelance- Business Analyst
Freelance- Business Analyst

Completed market research of online retail stores (FMCG), establishing basket price benchmark.

  • Evaluated and provided recommendations for outbound logistics options, driving efficiencies in purchased goods delivery.
Lakeside Invest & Consult, Konstanz, Germany
2 Jahre 8 Monate
2012-02 - 2014-09

Manufacturing

Senior Manufacturing Analyst- R & D
Senior Manufacturing Analyst- R & D
  • Identified equipment design requirements that enabled cost savings of $300k per machine.
  • Created business cases for global projects worth $5 million of total investment, while supporting the Project Manager in achieving alignment between key stakeholders (marketing, platform, engineering).
  • Developed & documented a print stability KPI data mart (T-SQL) which enabled generation of reports and analyses from a diversity of software solutions (Tableau, JMP, SSRS & Excel).
  • Managed a Business Intelligence intern including technical work, scoping, and priority setting.
  • Successfully conducted presentations for the CEO & leadership team regarding new technologies; including qualitative and quantitative analyses.
Vistaprint Schweiz Gmbh, Winterthur, Switzerland
7 Monate
2011-08 - 2012-02

Internship

Supply Chain Analyst
Supply Chain Analyst
University of St. Gallen, St. Gallen, Switzerland
6 Monate
2008-02 - 2008-07

Business Intelligence Internship- Supply Chain

Johnson Controls International, Valencia, Spain

Aus- und Weiterbildung

Aus- und Weiterbildung

2010

Budapest University of Technology and Economics, Hungary

Master?s Thesis: ?Lean Public Transportation.? 

2007-2010

Universitat Politecnica De Valencia, Valencia, Spain
Master?s: Industrial Management Engineering 

Specialization: Operations/ Supply Chain Management

2002-2007

La Universidad de La Laguna, Tenerife
Bachelor of Science: Computer Science 

Specialization: Business IT

Kompetenzen

Kompetenzen

Top-Skills

Business Reporting Data Warehouse ETL Process Business Analysis SQL Python Microsoft SQL Server Qliksense Redshift Airflow Alteryx Salesforce Marketo API SSRS VBA

Produkte / Standards / Erfahrungen / Methoden

Personal Statement:
The how we do it, is as important as the what we do. To empower teams and organizations in their data journey, is to combine business needs, streamlined processes and effective technology. My passion is to provide cross-functional solutions, that align stakeholders short-term needs with a long-term transformative view.

Software Skills:

  • Programming Languages: T-SQL, Python, SSAS, VBA
  • Reporting: Excel, QlikSense, Periscopedata, SSRS
  • Systems Knowledge: SQL Server, Salesforce, Marketo, Windows Server, Linux
  • Statistical Packages: R
  • ETL: Airflow, SSIS

Business Intelligence Expertise:

  • Process re-engineering (Lean)
  • Project management (Agile)
  • Dimensional modeling (Kimball)
  • Extract, Transform, Load (ETL)
  • Programming (T-SQL, Python)

Key Personal Skills:

  • Value stream focus.
  • Data-driven.
  • Strategic planner.
  • Entrepreneur.
  • Expert organizational skills.

Other work experience:

10/2009 - 01/2010
Universidad Nova, Lisbon, Portugal
Internship- Lean Research Associate

11/2010 - 04/2011
Ingenieria y Consultoria Insular, S.L.

Spain Junior IT Project Manager 

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.