BI Engineer, N-iX (Power BI and Data Platform Development)
Duration: Feb. 2024 - Present
Summary: Development of interactive Power BI reports with complex DAX measures and dynamic row-level and object-level security, integrating data from Databricks and SAP sources. Architecting and managing CI/CD pipelines for automated Power BI deployment using Azure DevOps and Microsoft Fabric. Authoring ETL pipelines in Azure Data Factory and automating dataset refreshes with PowerShell.
Responsibilities:
- Build interactive Power BI reports with complex DAX and dynamic security.
- Architect and manage CI/CD pipelines for Power BI deployment with Git integration.
- Creation of ETL pipelines using Azure Data Factory (ADF) for seamless data integration.
- Automate dataset refreshes and govern Power BI workspaces within Microsoft Fabric.
- Data modeling and optimization to enhance performance and scalability.
- Writing complex database scripts, stored procedures, triggers, and functions.
- Optimization of queries to ensure efficient data retrieval and performance improvement.
- Automation of dataset refreshes using PowerShell scripts.
- Management of Power BI workspaces and collaboration with cross-functional teams for data accuracy.
- Git integration setup for Power BI.
Technologies: Power BI, DAX, Azure Data Factory, Azure DevOps, Microsoft Fabric, Databricks, SAP ACDOCA/ACDOCP, PowerShell.
BI Engineer, Silverstein Properties (Real-Estate BI Reporting and Automation)
Duration: Feb. 2023 - Feb. 2024
Summary: Delivered Power BI reports and dashboards aligned with real-estate KPIs. Built CI/CD pipelines for automated report deployment and optimized SQL queries and data models to improve reporting performance.
Responsibilities:
- Develop Power BI reports and dashboards for real-estate KPIs.
- Build CI/CD pipelines for automated report deployment.
- Optimize SQL queries and refine data models for performance.
- Creation database scripts.
- Enhancion database performance.
- Support issues/problem solving.
Technologies: Power BI, SQL, Azure.
BI Engineer, SPD-Ukraine (Analytics Dashboard and Pipeline Orchestration)
Duration: Feb. 2022 - Feb. 2023
Summary: Built analytics dashboards in Looker on a Snowflake data warehouse. Authored database scripts and optimized queries. Designed and deployed DAGs in Apache Airflow for automated pipeline orchestration.
Responsibilities:
- Develop analytics dashboards in Looker using Snowflake data warehouse.
- Author database scripts and optimize queries.
- Design and deploy DAGs in Apache Airflow for pipeline automation.
Technologies: Looker, Snowflake, Apache Airflow.
BI Engineer, Yael Acceptic (Power BI Reporting and ETL Development)
Duration: Mar. 2021 - Feb. 2022
Summary: Developed Power BI reports and CI/CD deployment pipelines. Built ETL pipelines using Azure Data Factory and performed data modeling and query optimization in MS SQL Server.
Responsibilities:
- Develop Power BI reports and CI/CD deployment pipelines.
- Write stored procedures, triggers, and functions in MS SQL.
- Build ETL pipelines using Azure Data Factory.
- Perform data modeling and query optimization.
- Creation of database scripts, procedures, triggers, functions.
Technologies: Power BI, Azure Data Factory, MS SQL Server.
Data Engineer, Extenda Retail (Data Warehouse Infrastructure and ETL Pipelines)
Duration: Mar. 2020 - Mar. 2021
Summary: Designed data warehouse infrastructure and ETL pipelines using Apache Airflow, SSIS, and Azure Data Factory across multi-cloud environments including Azure, Snowflake, and Google Cloud Platform. Developed reporting stored procedures across multiple database platforms.
Responsibilities:
- Design DWH infrastructure and ETL pipelines using Airflow, SSIS, and ADF.
- Develop reporting stored procedures across MS SQL, Azure, Snowflake, and GCP.
- Creation business reports using Jaspersoft software.
- Creation database scripts.
- Enhancion database performance.
Technologies: MS SQL Server, Azure, Apache Airflow, SSIS, Snowflake, Google Cloud Platform.
BI Engineer, IDS Borjomi International (Data Warehouse and Reporting Development)
Duration: Sep. 2019 - Mar. 2020
Summary: Built data warehouse components and ETL pipelines using SSIS and Azure Data Factory. Developed reports in Power BI and Tableau, working with MS SQL Server, Azure, SSAS, and PostgreSQL databases.
Responsibilities:
- Build DWH components including triggers, procedures, and indexes.
- Develop ETL pipelines with SSIS and ADF.
- Create reports in Power BI and Tableau.
- Work across MS SQL, Azure, SSAS, and PostgreSQL.
- OLAP measure analysis and improvement of calculations.
- Business processes analysis.
- Weekly/monthly sales reports.
Technologies: Power BI, Tableau, MS SQL Server, SSIS, SSAS, Azure, PostgreSQL.
Salesforce Admin/BI Engineer, British American Tobacco (BI Solutions and Salesforce Administration)
Duration: Sep. 2018 - Sep. 2019
Summary: Delivered BI solutions integrating CRM, e-commerce, and third-party data sources using Power BI and Google Data Studio. Managed full Salesforce administration including user and security management, workflow automation, data imports, and system documentation.
Responsibilities:
- Deliver BI solutions from CRM, e-commerce, and third-party data sources.
- Manage Salesforce administration: user/security management, workflow automation, data imports, and documentation.
Technologies: Power BI, Salesforce, Azure Data Factory, Google Data Studio.
Data Analyst, Performance Control (Data Analysis and Reporting)
Duration: Feb. 2018 - Sep. 2018
Summary: Performed data analysis using Excel and VBA to produce operational reports supporting multiple business projects.
Responsibilities:
- Perform data analysis using Excel and VBA.
- Produce operational reports for various business projects.
Technologies: Excel, VBA.