TL;DR

Software Engineer (MS SQL, TSQL & ADF): Designing, building, and optimizing advanced analytic and data integration solutions for %hirify_global%'s Conference Technology Business with an accent on MS SQL Server, Azure SQL Managed Instance, T-SQL, and Azure Data Factory. Focus on improving T-SQL performance, creating complex ETL pipelines, and developing comprehensive data platforms.

Location: Hybrid work environment, requiring virtual work and in-office collaboration.

Company

%hirify_global% is a global IT advisory and research firm that provides actionable, objective business and technology insights to enterprise leaders.

What you will do

Collaborate with business stakeholders to design and build advanced analytic solutions.
Execute data strategy through the design and development of data platforms for Reporting, BI, and Advanced Analytics.
Design and develop key analytics capabilities using MS SQL Server, Azure SQL Managed Instance, T-SQL & ADF on Azure.
Consistently improve and optimize T-SQL performance across the analytics platform.
Create, build, and implement comprehensive data integration solutions utilizing Azure Data Factory.
Develop, maintain, and document data dictionary and data flow diagrams.

Requirements

Strong experience with SQL, including diagnosing load failures, constructing hierarchical queries, and efficiently analyzing existing SQL code.
Ability to create and modify various database objects such as stored procedures, views, tables, triggers, and indexes using Microsoft Azure SQL Database, SQL Server, and Azure SQL Managed Instance.
Deep understanding in writing Advanced SQL code (Analytic functions).
Strong technical experience with Azure Data Factory on Azure Platform, including creating and managing complex ETL pipelines.
Experience in Cloud Platforms and Azure technologies like Azure Analysis Services, Azure Blob Storage, Azure Data Lake, Azure Delta Lake.
Experience with data modelling, database design, data warehousing concepts, and Data Lake.
2-4 years of experience in Data analytics, Cloud technologies, and ETL development.
Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment.

Culture & Benefits

Hybrid work environment offering flexibility and support.
World-class benefits, highly competitive compensation, and disproportionate rewards for top performers.
Limitless opportunities for professional growth and personal flourishing.
Inclusive teams composed of individuals from diverse backgrounds.
Investment in great leaders who bring out the best in you and the company.