Bruno is available for hire

Bruno Jagic

Verified Expert in Engineering

Software Developer

Location

Nuremberg, Bavaria, Germany

Toptal Member Since

June 18, 2020

Bruno是一名数据工程师，在数据工程和分析方面拥有超过8年的经验, modeling, data quality, and writing complex SQL queries. 他曾在会议上发表演讲，并对内部员工进行SQL培训, Exasol, and Alteryx as part of his work with Adidas. 他在专注于数据和SQL的自由职业者工作中获得了最高评级, 他正在寻找新的远程机会来增加价值，并将他的经验发挥到极致.

Data Visualization Data Analysis Databases Database Development Business Intelligence (BI)SQL Database Design SQL Server Management Studio (SSMS)Amazon Athena Lua Jira Agile Alteryx SQL Server 2016 MySQL Adobe Analytics T-SQL

Portfolio

Piggy, LLC

SQL, Amazon QuickSight, AWS Glue, Excel 2016, ETL，复杂数据分析...

Adidas

Alteryx, Confluence, Jira, T-SQL (Transact-SQL)， Microsoft SQL Server, Lua...

CROZ

Talend, SQL Server集成服务(SSIS)， IBM Db2, Microsoft SQL Server...

Experience

ETL - 7 years Database Design - 6 years SQL - 6 years Amazon Athena - 5 years Microsoft Power BI - 4 years Exasol - 3 years Alteryx - 3 years Lua - 3 years

Availability

Full-time

Preferred Environment

MySQL, Exasol, Microsoft SQL Server, Redshift, Amazon Athena, Amazon QuickSight, Sisense, Alteryx, Database Design, Tableau

The most amazing...

...thing I've done is build Consumer DNA, 这款产品成为阿迪达斯电子邮件营销和数据科学模型的核心元素.

Work Experience

SQL Developer

2019 - 2022

Piggy, LLC

开发一个完整的仪表板解决方案，为团队中所有相关利益相关者提供见解:与CIO密切合作, built dashboards for the marketing team, and provided insights for the partnerships team.
自动化解决方案，以便整个团队在早上醒来时为他们准备好数据. 从AWS Glue开始到数据流和仪表板的末端.
Improved data quality and standardized reporting.

Technologies: SQL, Amazon QuickSight, AWS Glue, Excel 2016, ETL，复杂数据分析, Apache Airflow, Databases, Database Development, Business Intelligence (BI), Dashboards, Data Visualization, Data Engineering, Microsoft Excel

Data Engineer

2016 - 2019

Adidas

Integrated payment data for fraud analysis, designed databases, built automated solutions, and presented them to the business.
以自动化的方式为销售和点击流数据等主要集成主题构建了一个数据质量框架.
Built and maintained consumer DNA, 一组来自数字接触点的属性:来自网站的点击, sales, registration, paid media, NPS, and bazaar voice. 它是电子邮件营销和个性化中使用的核心产品，可以更好地定位.
Spoke at conferences, including Alteryx Inspire 2018 in London, where I presented how we use Alteryx in Adidas. 2019年3月，我作为受邀嘉宾参加了类似主题的演讲.
Built Alteryx applications and workflows, 比如一个工作流，它连接到不同的api来获取与我们的应用相关的数据, including the number of downloads, active users, and installations.
创建了帮助数据库管理员自动化工作的应用程序. For example, Alteryx creates users, grants them privileges, 并自动向用户发送相关信息的电子邮件.
为特别分析开发了多个工作流和应用程序, data quality, integration, and database administration.

Technologies: Alteryx, Confluence, Jira, T-SQL (Transact-SQL)， Microsoft SQL Server, Lua, Exasol, Agile, SQL Server 2016, ETL, Complex Data Analysis, Databases, Database Development, Dashboards, Data Visualization, Data Engineering, Microsoft Excel

Database Developer

2014 - 2016

CROZ

为克罗地亚税务机关开发了一个数据仓库，其目标是集中所有相关数据，以便我们的政府能够为他们提供检测税务欺诈者的能力.
为克罗地亚统计局建立了一个仓库，用于数据整合和分析克罗地亚高中教育的所有相关数据.

Technologies: Talend, SQL Server集成服务(SSIS)， IBM Db2, Microsoft SQL Server, ETL, Complex Data Analysis, Databases, Database Development

Database Developer

2013 - 2015

Self-employed

使用MySQL存储有关美国属性的所有数据，目的是估计特定属性的值. 我的任务包括每个步骤中的数据质量责任, such as integration, insertion to dimensional model, and preparation of reports for senior management.
为学生和小公司构建数据库，包括从需求收集到解决方案设计到在特定数据库(MySQL)中构建解决方案的所有内容, MS SQL, Postgre).
Created an integration process for loan reporting; the client had a collection of companies that have provided loan services, 他们都来到了这个系统，我必须从这个系统中构建集成步骤来提供见解.
使用Alteryx分析数据，准备见解并进行数据清理.
Provided data analysis for a client that wanted to predict the stock market; my part was to build SQL queries for a specific business use case and stock market items.

Technologies: T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Microsoft SQL Server, Talend, Complex Data Analysis, Databases, Database Development, Business Intelligence (BI), Dashboards, Microsoft Excel

Experience

Consumer DNA

构建和优化消费者DNA，这是阿迪达斯数字业务的核心解决方案. 该解决方案的目标是为每个消费者创建消费者属性，以便最终系统可以轻松访问和使用网站个性化和电子邮件营销. 现在，阿迪达斯发送的大部分电子邮件都是由该解决方案触发的.

DWH for Croatian Tax Authorities

克罗地亚税务机关用来检测税务欺诈的数据仓库. it was a massive collection of data that is owned by the Croatian government and is very sensitive; I was part of the team that was able to deliver this project within one year.

DWH for Croatian Bureau of Statistics

克罗地亚统计局的一个仓库，用于数据整合和分析克罗地亚高中教育的所有相关数据.

Payments Data Integration

集成用于欺诈分析的支付数据，第一步是将现有数据从SQL Server迁移到Exasol，第二步是连接到支付服务提供商，并以小时为基础将数据集成到同一个数据库中.

I was brought to Adidas for this. It was a one-man project for eight months, 在这个过程中，我能够提供一个高度自动化的解决方案，即使在经过两年的操作和优化后，它仍然可以正常工作，没有任何问题.

Skills

Languages

SQL, Lua, T-SQL (Transact-SQL), Python

Tools

DbVisualizer, Jira, Amazon Athena, Amazon QuickSight, Sisense, Excel 2016, Confluence, Adobe Analytics, Microsoft Excel, Tableau, AWS Glue, Microsoft Power BI, Apache Airflow

Paradigms

数据库设计，敏捷，数据库开发，商业智能(BI)， Scrum, ETL

Platforms

Alteryx, Talend, Jupyter Notebook

Storage

Exasol, SQL Server 2016, MySQL, SQL Server Management Studio (SSMS), Databases, PostgreSQL, SQL Server Integration Services (SSIS), Datastage, Microsoft SQL Server, IBM Db2, Redshift

Other

Entity-relationships Model (ERM), Complex Data Analysis, Data Analysis, Dashboards, Data Visualization, Office 365, Data Engineering

Education

2010 - 2016

Master's Degree in Computer Science

University of Zagreb - Zagreb

Certifications

DECEMBER 2022 - DECEMBER 2024

微软认证:Power BI数据分析师助理

Microsoft

FEBRUARY 2019 - FEBRUARY 2021

Alteryx Advanced Certified

Alteryx

NOVEMBER 2018 - PRESENT

Exasol Certified Database Developer

Exasol AG

NOVEMBER 2017 - PRESENT

Exasol Certified Scripting Expert

Exasol AG

NOVEMBER 2017 - PRESENT

Exasol Certified Performance Expert

Exasol AG

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring