BI Analyst & Business Analyst

Kandidát je seniorní analytik/inženýr s desetiletou praxí v oblasti Data/DWH a BI v bankovnictví, platebních kartách a výrobním průmyslu. Má vysokoškolské vzdělání v oborech Evropský obchod a finance a Systémové inženýrství a informatika. Kandidát má plnou odbornou znalost angličtiny a rodilou znalost češtiny/slovenštiny. Pracoval s technologiemi jako MS Power BI, Teradata Vantage a MicroStrategy. Ve volném čase kandidát rád cestuje, věnuje se turistice, hraje tenis a jezdí na kole.

• 11/2022 - Present
• Working in the manufacturing sector, focusing on commercial and financial data analysis
• Developing reports in MS Power BI using SSAS tabular data models and SQL Server/AWS datasets
• Enhancing SSAS Data models with new objects using DAX and SQL
• Developing datasets in T-SQL on Microsoft SQL Server using Data Vault architecture
• Administering Power BI Service environment and on-prem Reporting Services servers
• Working in an Agile environment with sprints and Jira Kanban
• 05/2019 - 09/2022
• Consulting customer requirements for BI reports and data sources in the payment processing industry
• Designing data models and technical specifications for DWH and BI reports
• Developing ETL processes for all layers in the Data Warehouse
• Analyzing data, designing, testing, and fixing data models
• Implementing Agile methodology, automatization, and DevOps principles
• Training business users in new processes and functionalities of DWH
• 02/2017 - 04/2019
• Creating technical specifications for DWH development in the banking sector
• Designing ETL transformations and business rules for the DWH's Output layer
• Providing data support for business users and consumers of DWH data
• Implementing data corrections and solving operational problems
• Executing technical and functional test scenarios for ETLs and data structures
• Following waterfall methodology for development
• 9/2013 - 12/2016
• Supporting IFS ERP system in a manufacturing company
• Providing solutions, workarounds, and fixes based on data analyses
• Administering IFS system permissions
• Training business users and testing new patches/releases
• Assisting with the implementation of the new IFS system
• Creating SQL reports and maintaining ServiceDesk support tool