Mykola Matiashov

BI & Data Engineering | Analytics & Data Visualization Specialist
10+ years of experience in designing and delivering end-to-end analytical solutions, data integration, and interactive reporting.

🔑 Core Skills & Expertise

Analytical Systems & Data Modeling

• Design and maintenance of OLAP cubes (MS SSAS) and Power BI semantic models.

• Strong dimensional modeling and data architecture expertise.

SQL & Database Engineering

• Advanced T-SQL skills: writing optimized queries, stored procedures, and views in SQL Server.

• Experience with Azure SQL Database and Azure Synapse Analytics.

ETL & Data Integration

• Building scalable ETL pipelines using SSIS and Azure Data Factory.

• Data flow optimization, transformation logic, and data warehouse design.

Reporting & Dashboards

• Creating intuitive, interactive reports with Power BI, SSRS, and DevExpress.

• Integration of KPIs, forecasting models, and advanced analytics.

Power BI Development & Embedded Analytics

• Development of self-service BI solutions and embedded analytics using Power BI REST & JavaScript Client APIs.

• Hands-on experience with Power BI Premium & Embedded capacities.

Programming & Scripting

• Proficiency in C#, PowerShell, DAX, Power Query M, and Python.

• Integration with CosmosDB, Azure Synapse, and the broader Azure ecosystem.

Performance Optimization

• Monitoring and tuning of BI environments for performance and scalability.

• Resource governance, dataset optimization, and best practices in Power BI.

Security & Governance

• Implementation of Row-Level Security (RLS) and security modeling in Power BI.

• Data access management across on-premises and cloud platforms.

Cloud & Big Data Platforms

• Working with Azure Databricks, Azure Data Factory, and other Azure services.

• Designing data platforms for high-volume, real-time data pipelines.

BI Project Leadership

• Leading full-cycle BI implementations from requirements to delivery.

• Cross-functional collaboration with business stakeholders, analysts, and engineers.