
Bruno Jagic
Verified Expert in Engineering
Data Engineer and Alteryx Expert Developer
Nuremberg, Bavaria, Germany
Toptal member since March 29, 2019
Bruno is a senior data engineer with over 10 years of experience in designing data warehouses, building ingestion and transformation pipelines, and modeling data for analytics. He has deep expertise in SQL across platforms like SQL Server, PostgreSQL, Exasol, and AWS. Bruno is also a conference speaker and internal trainer, known for his top ratings in freelance work focused on data and SQL. He is seeking new remote opportunities to add value and effectively utilize his extensive experience.
Portfolio
Experience
- Database Design - 12 years
- SQL - 12 years
- ETL - 11 years
- APIs - 9 years
- Pipelines - 7 years
- Amazon Athena - 7 years
- Microsoft Power BI - 4 years
- Alteryx - 4 years
Preferred Environment
Microsoft SQL Server, Redshift, Amazon Athena, Amazon QuickSight, Sisense, Alteryx, Database Design, Amazon Redshift, AWS Glue, Data Pipelines
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
Software Developer
Self Employed
- Designed and built eponude.hr, an end-to-end SaaS platform for Croatian electrical contractors covering offer generation from expense sheet, invoice intake, job-site cost tracking, worker hour logging, and analytics. Python, JavaScript, PostgreSQL, R2.
- Designed and built a multi-tenant SaaS platform for Croatian electrical contractors, end-to-end: FastAPI back end, React front end, PostgreSQL (multi-schema), Cloudflare R2 object storage, JWT auth, and role-based access (user/manager/admin).
- Engineered the Gradilišta (job-site) cost module, unifying material spend and labor cost into per-location KPIs with cost-split visualizations, supplier breakdowns, and category-level analytics.
- Designed the Dnevnik rada (worklog) subsystem: workers decoupled from app users, optional crew groups, weekly hour entry with cross-location visibility, and a per-worker/per-location heatmap calendar.
- Built an analytics layer with monthly spend timelines, supplier breakdowns, category donuts, and PDF export for client-facing reporting.
- Built 14 supplier-specific PDF invoice parsers (Schrack, Würth, Rexel, Ellabo, e-racuni, and others) with auto-detection, structured extraction, and a 19-category material taxonomy with auto-categorization.
- Built web scraping jobs that scrape prices from the most common Croatian webshops to get a list of material costs.
- Integrated installation norms so that we know how long it takes for each product to be installed, which is important when generating an offer from the expense sheet.
Data Engineer
Enghouse Interactive
- Architected and built a centralized SQL Server data warehouse consolidating data from 10+ acquired call center subsidiaries, replacing fragmented per-company reporting with a single source of truth.
- Designed a library of standardized Sisense dashboards that became plug-and-play once a subsidiary's data landed in the DWH, eliminating bespoke reporting work per acquisition.
- Delivered internal and external training on data warehouse concepts, the in-house DWH platform, and the company's wrapped Sisense dashboarding tool.
- Operated in an Agile environment using Jira and Confluence, coordinating delivery across engineering, BI, and subsidiary stakeholders.
- Served as the technical point of contact for new subsidiary implementations, scoping integrations with stakeholders, and driving them through to production.
- Led a team of students, owning technical direction, code review, and mentorship across the DWH and BI stack.
SQL Developer | Data Engineer
Piggy, LLC
- Developed a full dashboarding solution with dashboards that provide insights to all relevant stakeholders in the team: worked closely with the 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. Used Alteryx to gather the data, put it all together, and perform data analysis and manipulation.
- Automated data flows from multiple data sources to a centralized location where all the relevant touchpoints can be joined together to get a full picture of our customers.
- Performed ad hoc analysis and data manipulation in Alteryx to see if a specific set of data would give us the required insights, and if so, to start with proper automation.
Alteryx Developer | Data Engineer
Adidas
- Integrated payment data for fraud analysis, designed databases, built automated solutions, and presented them to the business. The main tool I used was Alteryx.
- 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 Bazaarvoice. 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 automate their work. For example, an Alteryx workflow will create users, grant them privileges, and automatically email them with relevant information.
- Developed multiple workflows and applications for ad-hoc analysis, data quality, integration, and database administration using Alteryx.
Database Developer
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.
Database Developer
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.
Experience
Consumer DNA
DWH for Croatian Tax Authorities
DWH for Croatian Bureau of Statistics
Payments Data Integration
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.
Education
Master's Degree in Computer Science
University of Zagreb - Zagreb
Certifications
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Alteryx Advanced Certified
Alteryx
Exasol Certified Database Developer
Exasol AG
Exasol Certified Scripting Expert
Exasol AG
Exasol Certified Performance Expert
Exasol AG
Skills
Libraries/APIs
Salesforce API, Playwright
Tools
Jira, Amazon Athena, Amazon QuickSight, Sisense, Confluence, Microsoft Excel, Tableau, AWS Glue, Microsoft Power BI, Apache Airflow, Adyen Payments, Git, GitHub
Languages
SQL, Transact-SQL (T-SQL), Python, JavaScript, Python 3
Paradigms
Database Design, Agile, Database Development, Business Intelligence (BI), Scrum, ETL
Platforms
Alteryx, Jupyter Notebook, Talend
Storage
Exasol, SQL Server 2016, MySQL, SQL Server Management Studio (SSMS), Databases, PostgreSQL, SQL Server Integration Services (SSIS), Datastage, Redshift, Microsoft SQL Server, IBM Db2, Data Pipelines
Other
Entity-relationships Model (ERM), Complex Data Analysis, Data Analysis, Dashboards, Data Visualization, Data Engineering, APIs, Pipelines, HTML Parsing, Amazon Redshift, Medallion Architecture, ETL Pipelines, Data Warehousing, Training, Finance, Customer Support, School, Deployment, CI/CD Pipelines, Domain Research, Web Scraping, Document Parsing
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring