Bruno is available for hire
Hire BrunoBruno Jagic
Verified Expert in Engineering
Software Developer
Location
Nuremberg, Bavaria, Germany
Toptal Member Since
June 18, 2020
Bruno is a data engineer with over eight years of experience in data engineering and analysis, modeling, data quality, and writing complex SQL queries. He has spoken at conferences and trained internal employees in SQL, Exasol, and Alteryx as part of his work with Adidas. He has top ratings in his freelance work with a focus on data and SQL, and he is looking for new remote opportunities to add value and put his experience to good use.
Portfolio
Piggy, LLC
SQL, Amazon QuickSight, AWS Glue, Excel 2016, ETL, Complex Data Analysis...
Adidas
Alteryx, Confluence, Jira, T-SQL (Transact-SQL), Microsoft SQL Server, Lua...
CROZ
Talend, SQL Server Integration Services (SSIS), IBM Db2, Microsoft SQL Server...
Experience
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, a product for Adidas that became a core element of their email marketing and data science models.
Work Experience
SQL Developer
2019 - 2022
Piggy, LLC
- Developed a full dashboarding solution with dashboards that provide insights to all relevant stakeholders in the team: worked closely with CIO, built dashboards for the marketing team, and provided insights for the partnerships team.
- Automated the solution so that the whole team has the data ready for them when they wake up in the morning. Started from AWS Glue to the end of the data flow and dashboard.
- Improved data quality and standardized reporting.
Technologies: SQL, Amazon QuickSight, AWS Glue, Excel 2016, ETL, Complex Data Analysis, 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.
- Architected a data quality framework for main integration topics like sales and clickstream data in an automated fashion.
- Built and maintained consumer DNA, a set of attributes from digital touchpoints: clicks from the website, sales, registration, paid media, NPS, and bazaar voice. It is a core product used in email marketing and personalization for better targeting.
- Spoke at conferences, including Alteryx Inspire 2018 in London, where I presented how we use Alteryx in Adidas. In March 2019, I attended as an invited guest to speak on a similar topic.
- Built Alteryx applications and workflows, such as a workflow that connects to different APIs to get data relevant to our apps, including the number of downloads, active users, and installations.
- Created applications that helped our database administrators to automate their work. For example, Alteryx creates users, grants them privileges, and automatically emails the users with relevant information.
- Developed multiple workflows and applications for ad-hoc analysis, 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
- Developed a data warehouse for Croatian tax authorities where the goal was to centralize all the relevant data that our government has to be able to provide them the ability to detect tax fraudsters.
- Built a warehouse for the Croatian Bureau of Statistics for data integration and analysis of all the relevant data about high school education in Croatia.
Technologies: Talend, SQL Server Integration Services (SSIS), IBM Db2, Microsoft SQL Server, ETL, Complex Data Analysis, Databases, Database Development
Database Developer
2013 - 2015
Self-employed
- Used MySQL to store all data about properties in the US with a goal of estimating a value of specific property. My tasks included responsibilities for data quality in each step, such as integration, insertion to dimensional model, and preparation of reports for senior management.
- Built databases for students and small companies including everything from the collection of requirements to the design of solutions up to building a solution in a specific database (MySQL, MS SQL, Postgre).
- Created an integration process for loan reporting; the client had a collection of companies that have provided loan services, and all of them came to the system from which I had to build integration steps to provide insights.
- Used Alteryx to analyze the data, preparing insights and doing data cleanup.
- 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
Built and optimized Consumer DNA, a solution that is core for digital business in Adidas. The goal of the solution was to create consumer attributes for each consumer so that it is easily accessible and usable by the end systems for website personalization and email marketing. A large percentage of emails sent by Adidas is now triggered by this solution.
DWH for Croatian Tax Authorities
A data warehouse for Croatian tax authorities to detect tax fraud. 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
A warehouse for the Croatian Bureau of Statistics for data integration and analysis of all the relevant data about high school education in Croatia.
Payments Data Integration
Integration of payments data for fraud analysis where the first step was to migrate existing data from SQL Server into Exasol and the second was to connect to the payment service provider and integrate the data on an hourly basis into the same database.
I was brought to Adidas for this. It was a one-man project for eight months, in which I was able to deliver a hyper-automated solution that works even now after two years of operation and optimization without an issue.
I was brought to Adidas for this. It was a one-man project for eight months, in which I was able to deliver a hyper-automated solution that works even now after two years of operation and optimization without an issue.
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
Database Design, Agile, Database Development, Business Intelligence (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
Microsoft Certified: Power BI Data Analyst Associate
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
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring