Position: Senior SQL engineer
Company: GlobalLogic
Experience required: 5y
English level: upper

Job Description
- Experience with Sisense or similar business intelligence reporting tools (Power BI, Tableau as an example)
- Solid knowledge of Data Warehouse models and approaches
- Experience in DB schema creation, Data Models creation
- Hands-on experience in architecting, implementing, and supporting data warehouse solutions
- Hands-on experience in ETL, analytics, and reporting (Microsoft SQL Server Integration Services / Analysis Services / Reporting Services)
- Fluency in Transact-SQL
- Experience working in Scrum/Agile environment
- Experience working with code repository (Azure DevOps, or git hub like)
- As a plus- experience with Snowflake solution
- Upper-Intermediate English level or Advanced English level is a must

Skills
- MS SQL Server, Data Warehouse Solution Architecture, Transact-SQL, Data Analysis Scripting Languages, ETL, BI Reporting Tools, Sisense, PowerBI, Snowflake

Job Responsibilities
- Participate in a full-cycle development and support of a business intelligence reporting system Develop analytical solutions from designing the table structure to implementing and optimizing data population mechanisms in Snowflake (Tables, views, streams, pipes, tasks)

- Create OLAP Cubes in Sisense with MS SQL data source as well as Snowflake.

- Prepare reporting base for MS SQL source DBs Follow high standards of development processes to guarantee delivery quality.

- Work closely with product management to turn data into critical knowledge required for making business decisions Evaluate and make recommendations on innovative business intelligence products and services


Department/Project Description
People. 
1. USA: owner, top management, PM, PO, Arch, 2 full SCRUM teams, OPS team, and cross-team QAs, BAs, etc.
2. Ukraine: PM, PPOs (1 per each SCRUM team), Arch, 4 SCRUM teams, DevOps, RM, QA Leads (MQA & AQA). The GL team counts 70 people in total and growing.
 
Product.
We develop a POS, reporting systems, and other peripherals integration solution that allows providing attended (employee) and unattended (customer) tunnel car washing service. There are two labs: 
1. One in US (Ohio) 
2. One in Ukraine (Lviv) 
 
Product support both USA and Canadian markets. One hardware set includes several points on sale, a set of different sensors, readers and cameras, payment terminals, servers, automatic gates. Also Client manager andreporting systems are under development.
Ukrainian team develops a PWA application and a hybrid web application (.Net & Angular) that operates on hardware & cloud and supports full customer flow: from customer recognition or account creation to sale & directing their car to a tunnel. All embedded development is on the client's side. Some teams have hardware dependencies based on the areas of the application they work with, meaning office presence is necessary. 
 
Flow. 
SCRUM, 2-week sprints, releases every 3 weeks. Sprints include mandatory daily stand-ups, grooming, planning, demo, and retro sessions. 
 
This position concludes to work directly with the team on client side. Full support from GL teams is a standard pack.