Position: Senior SQL/BI Developer
Category: SQL
English level: fluent
Years of experience: 11

I have more than 10 years’ experience of writing complex SQL queries and creating all types of databases' objects (views, stored procedures, functions, triggers, indexes) using T-SQL. I have a strong knowledge and extensive experience of designing, building, modification and maintaining databases and data warehouses with MS SQL Server. I have hands-on experience of building ETL processes with SSIS, development and maintenance of OLAP cubes with SSAS and creating Power BI Reports. I have excellent analytical skills and ability to work with data from multiple data sources. I have good communication skills and can work both independently and as part of a team. I have the ability to quickly learn and adapt to changes in a dynamically developing environment. I am always open to long-term cooperation.  I have experience working with various departments. As a Senior SQL Database Developer in my previous role, I worked closely with teams of software developers, business analysts, project managers, sales and finance.
• 10+ years of MS SQL Server 2016/2012/2008 experience: designing and building of databases and their modification (creating, upgrading, bug fixes, optimization, adding of new capabilities, writing of complex SQL queries, stored procedures, functions, triggers);
• 6+ years of SSAS experience: designing and building of OLAP-cubes and their modification (designing, creating of cubes, adding of new dimensions and measures, development of calculated elements using MDX);
• hands-on experience of building, support and troubleshooting of ETL processes with SSIS;
• hands-on experience of design and development data warehouse;
• experience of creating and maintaining Power BI Reports, writing formulas using DAX;
• strong knowledge of T-SQL; 
• understanding of the relational model of the database, dimensional Model (Kimball / Star Schema) and OLAP technologies; 
• database optimization and refactoring skills;
• experience with large and complex databases;
• experience with dynamic SQL;
• experience with MS products: Excel (pivot tables, macros), Access (DB, macros)
• programming experience in VBA;