Skip navigation

Ira van den Broek

is looking for freelance projects. 🔎

Freiberuflich, Data Modeller, Hogeschool Utrecht
Berlin, Germany

Skills

Datavault
Snowflake
Data Warehouse
Data Engineering
dbt
Data Modeling
Dimensional Modeling
Informatica PowerCenter
AWS
Datenanalyse
PL/SQL
Oracle
PowerBuilder
Oracle SQL Developer
Agile
SQL
ETL
Python
Requirements Analysis
Commitment
Analytical skills
Communication skills

Timeline

Professional experience for Ira van den Broek

  • Current 7 months, since Oct 2024

    Data Modeller

    Hogeschool Utrecht

  • Current 11 years and 6 months, since Nov 2013

    Freelance Data Nerd

    I Am On It

    Designing and developing Data Warehouse solutions: data analysis and data modeling, development

  • 2 years and 1 month, Jun 2022 - Jun 2024

    Data Analyst Data Modeller

    De Volksbank

    Extension of data warehouse, specifically reference data sets for risk models. Analysing functional requirements; writing technical designs; data modelling in PowerDesigner. Tools and technologies: PowerDesigner, Teradata, Git, Jenkins

  • 2 years and 1 month, Feb 2020 - Feb 2022

    Data Analyst

    EDSN

    Designing and developing datawarehouse applications: analysing data sources, data modeling, writing ETL flows, implementing data architecture in Snowflake. Advice for reporting dashboards, designing dimensional datamarts and developing dataflows to load them. Tools and technologies: Snowflake, SQL / Javascript, AWS, Git, data vault modeling, dimensional modeling.

  • 3 months, Jul 2019 - Sep 2019

    Data Engineer

    SIEMENS

    Migrate ETL to Snowflake; data analysis, conversion Talend jobs. Tools and technologies: Talend, Snowflake, GitLab

  • 2 years, Jul 2017 - Jun 2019

    BI Consultant

    Bayer AG, Pharmaceuticals Division

    Developing ETL mappings in Master Data Management system

  • 9 months, May 2016 - Jan 2017

    BI Consultant

    Eneco Energie

    Data analysis for and development of a predictive model. Improving reporting scripts (PlSQL). Implementing SubVersion. Tools and technologies: Oracle 11g and Exadata, Pl/SQL, Tortoise SVN, Agile

  • 11 months, Apr 2015 - Feb 2016

    Application Consultant Senior

    Nuon

    Designing and developing ETL for adding new sources to the Data Warehouse. Data analysis (SAP and Siebel source systems) for improvements to datamarts. Tools and technologies: Oracle 11g, Pl/SQL, Data Vault

  • 9 months, Jul 2014 - Mar 2015

    BI Architect / senior BI Developer

    Cengage Learning

    Designing and developing a metadata driven ETL framework in Pl/SQL and Python. Investigating and implementing data solutions in Cloud computing, Big Data. Tools and technologies: Oracle 11g, Redshift, Amazon Cloud applicaties (Oracle RDS, EC2, S3), Pl/SQL, Python, dimensional modeling, agile work methods.

  • 3 months, Nov 2013 - Jan 2014

    Senior OWB Developer

    ABN Amro Verzekeringen

    Adding data from a new source to an existing data warehouse. Designing dimensional model, developing ETL code. Tools and technologies: Oracle 11g, OWB, Toad, dimensional modeling.

  • 9 months, Jul 2012 - Mar 2013

    Database Developer

    AMC Clinical Research Unit

    Development of web based database applications in Java. Migrating database applications (Tomcat upgrade) and planning and co-ordinating database migration (SQLServer upgrade). Tools and technologies: Java, JavaScript, jQuery, MS SQLServer, MS Report Builder.

  • 3 years, May 2009 - Apr 2012

    Data Manager International Polar Year (IPY)

    NIOZ Royal Netherlands Institute for Sea Research

    Archiving and publishing data from polar scientific research. Investigating and solving issues regarding the data management and metadata. Collaborating in national an international organisations exchanging knowledge about preserving and publishing data. Tools and technologies: Sybase AS, Sybase PowerDesigner, Oracle DB, MySQL, PostgreSQL, PHP, JavaScript / jQuery, GIS applications (PostGIS, OpenLayers), Eclipse, SubVersion in Tortoise.

  • 4 years and 8 months, Sep 2004 - Apr 2009

    Datawarehouse Information Manager, Senior Information Manager

    ING

    Co-development of dimensional model. Design and development of ETL code (Oracle Warehouse Builder and Unix shell scripts). Design and creation of reports in Oracle BI Enterprise Edition and of tailor-made query and reporting applications in PlSQL Tools and technologies: Oracle DB, Oracle Warehouse Builder, Oracle BI Enterprise Edition, Kimball DM, Oracle SQL Developer, Pl/SQL Developer, Toad, Unix AIX, Pl/SQL, HMTL, CSS.

  • 2 years and 9 months, Dec 2001 - Aug 2004

    Application Support Employee

    Postbank N.V.

    Development of and support for intranet applications. Support for Chordiant MD. General Service Desk tasks. Redesign of the intranet of the department, and the design and development of an incident registration tool linked to a "face book" of the department for the helpdesk. Used tools and technologies: Oracle DB, Oracle Portal, Chordiant MD, PL/SQL, ASP, JavaScript, HTML and CSS, ITIL.

  • 1 year and 2 months, Oct 2000 - Nov 2001

    Internet Programmer

    PTS Software B.V.

    Development of websites in HTML, CSS, ASP, JavaScript, VBScript.

  • 1 year and 11 months, Nov 1998 - Sep 2000

    Internet Programmer

    Foundation PZ

    Technical design, development and support for websites and CMS applications in HTML, CSS, ASP and Access, VBScript, JavaScript. Project planning and coordination.

Educational background for Ira van den Broek

  • 3 years and 10 months, Sep 1999 - Jun 2003

    Information technology

    College of Advanced Education Amsterdam

    UML, Database Design, ITIL, DSDM, SQL, Perl, Java, C++

Languages

  • English

    Fluent

  • German

    Intermediate

  • French

    Intermediate

  • Dutch

    First language

XING – The jobs network

  • Over 1 million jobs

    Find just the right job for you on XING.

  • Job offers just for you

    Get found by employers and over 20,000 recruiters.

  • 22 million members

    Connect with new people and gather inspiration to boost your working life.

  • Free membership

    Basic membership is free, but the opportunities are priceless.

Browse over 21 million XING members