Position: Senior SQL engineer
Company: GlobalLogic
Experience required: 3y
Category: SQL
English level: upper
Published: 2023-07-01T00:00:00+03:00

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 the US (Ohio)
2. One in Ukraine (Lviv)

Product support both the USA and Canadian markets. One hardware set includes several points on sale, a set of different sensors, readers and cameras, payment terminals, servers, and automatic gates. Also, Client manager and reporting 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.

**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.

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 the client side. Full support from GL teams is a standard pack.

**Requirements:**
– 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.

**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 to report 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.