З 1993 року EPAM допомагає світовим лідерам проєктувати, розробляти і впроваджувати програмне забезпечення, яке змінює світ.
19 октября 2021

MS SQL Software Engineer with DWBI & ETL expertise

Киев, удаленно

Необходимые навыки

• 4+ years overall experience with DWBI/ETL
• Data understanding, analytical skills, understanding how and on what reports are built
• In-depth expertise in data modeling, BI/DWH solution
• Experience with SQL Server and creation of Stored Procedures / Functions (T-SQL)
• SSAS Tabular/Multidimensional Models experience, Measures creation (DAX), RLS configuration
• Experience with SSIS ETL packages creation and release building
• SQL Server Administration is a big plus
• Ability to collaboratively work in a team with active and initiative position and with a desire to dive into the business area
• Intermediate or higher English level, both spoken and written (B1+)

Предлагаем

• Competitive compensation depending on experience and skills
• Individual career path
• Unlimited access to LinkedIn learning solutions
• Social package — medical insurance, sports
• Compensation for sick lists and regular vacations
• English classes with native speakers (certified English teachers)
• Flexible work hours

Обязанности

• Evaluate, discuss and implement technical topics
• Data sources investigation, data modeling
• ETL planning and packages development
• T-SQL stored code creation on DB layer
• Issues handling performance
• Security issues and controls handling
• Verification of SSAS Models and Measures in Power BI
• SSAS level development (model, DAX measures, RLS)

О проекте

This project is focused on: building of DWH as a part of big Enterprise Data landscape (bi-directional integration with Datalake), creation of Financial, People, Office Facilities reports with complicated security controls and publishing on Power BI Service (cloud).
ETL(SSIS)/MS SQL/OLAP(SSAS) Software Engineer with the desire to discover the business area, to dive into the complicated logic of the solution, to plan and perform data transformation (SSIS, DB SPs) and perhaps measures/formulas creation (SSAS, DAX) is needed for Engineer position (MS SQL stack)

LinkedIn