Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home

Jobs

Home
>
Jobs in Gurugram
>
Gartner for HR
>
Lead Software Engineer (MS SQL Server, Azure SQL Managed )

Lead Software Engineer (MS SQL Server, Azure SQL Managed )

Gartner for HR

7 - 10 years

9 - 12 Lacs

Gurugram

Posted:23 hours ago| Platform:

Apply

Skills Required

MS SQL Change management GIT Coding Database design SSRS Stored procedures SQL Python Recruitment

Work Mode

Work from Office

Job Type

Full Time

Job Description

About Gartner IT:

Join a world-class team of skilled engineers who build creative digital solutions to support our colleagues and clients. We make a broad organizational impact by delivering cutting-edge technology solutions that power Gartner. Gartner IT values its culture of nonstop innovation, an outcome-driven approach to success, and the notion that great ideas can come from anyone on the team.

About the role:

Gartner is looking for a well-rounded and driven leader to become a part of its Conferences Technology & Insight Analytics team, which is tasked with creating the reporting and analytics to support its Conference reporting operations.

What you will do:

Provide technical leadership and guidance to software development teams, guaranteeing alignment with project objectives and adherence to industry best practices.
Leading and mentoring a team of software engineers, delegating responsibilities, offering support, and promoting a collaborative environment.
Collaborate with business stakeholders, design, build advanced analytic solutions for Gartner Conference Technology Business.
Execution of our data strategy through design and development of Data platforms to deliver Reporting, BI and Advanced Analytics solutions.
Design and development of key analytics capabilities using MS SQL Server, Azure SQL Managed Instance, T-SQL & ADF on Azure Platform.
Consistently improving and optimizing T-SQL performance across the entire analytics platform.
Create, build, and implement comprehensive data integration solutions utilizing Azure Data Factory.
Analysing and solving complex business problems, breaking down the work into actionable tasks.
Develop, maintain, and document data dictionary and data flow diagrams
Responsible for building and enhancing the regression test suite to monitor nightly ETL jobs and identify data issues.
Work alongside project managers, cross teams to support fast paced Agile/Scrum environment.
Build Optimized solutions and designs to handle Big Data.
Follow coding standards, build appropriate unit tests, integration tests, deployment scripts and review project artifacts created by peers.
Contribute to overall growth by suggesting improvements to the existing software architecture or introducing new technologies.

What you will need

Strong IT professional with high-end knowledge on Designing and Development of E2E BI & Analytics projects in a global enterprise environment. The candidate should have strong qualitative and quantitative problem-solving abilities and is expected to yield ownership and accountability.

Must have:

Strong experience with SQL, including diagnosing and resolving load failures, constructing hierarchical queries, and efficiently analysing existing SQL code to identify and resolve issues, using Microsoft Azure SQL Database, SQL Server, and Azure SQL Managed Instance.
Ability to create and modifying various database objects such as stored procedures, views, tables, triggers, indexes using Microsoft Azure SQL Database, SQL Server, Azure SQL Managed Instance.
Deep understanding in writing Advance SQL code (Analytic functions).
Strong technical experience with Database performance and tuning, troubleshooting and query optimization.
Strong technical experience with Azure Data Factory on Azure Platform.
Create and manage complex ETL pipelines to extract, transform, and load data from various sources using Azure Data Factory.
Monitor and troubleshoot data pipeline issues to ensure data integrity and availability.
Enhance data workflows to improve performance, scalability, and cost-effectiveness.
Establish best practices for data governance and security within data pipelines.
Experience in Cloud Platforms, Azure technologies like Azure Analysis Services, Azure Blob Storage, Azure Data Lake, Azure Delta Lake etc
Experience with data modelling, database design, and data warehousing concepts and Data Lake.
Ensure thorough documentation of data processes, configurations, and operational procedures.

Good to Have:

Experience working with dataset ingestion, data model creation, reports, dashboards using Power BI.
Experience with Python and Azure Function for data processing.
Experience in other reporting tools like SSRS, Tableau, Power BI etc.
Demonstrated Ability to use GIT, Jenkins and other change management tools.
Good knowledge of database performance and tuning, troubleshooting and query optimization.

Who you are :

Graduate/Post-graduate in BE/Btech, ME/MTech or MCA is preferred.
IT Professional with 7-10 yrs of experience in Data analytics, Cloud technologies and ETL development.
Excellent communication and prioritization skills.
Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment.
Strong desire to improve upon their skills in software development, frameworks, and technologies.

More Jobs at Gartner for HR

Business Development Executive, MSE, GTS

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Marketing Specialist - Global Technology Sales

Gurgaon, Haryana, India

5 - 8 yrs

Salary: Not disclosed

Account Executive, MSE, GTS

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Assistant Manager, Travel & Expense

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Manager, Team Manager - BR COE (Technology research)

Gurgaon, Haryana, India

2 - 3 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Technical Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Gartner for HR

124 Jobs

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Lead Software Engineer (MS SQL Server, Azure SQL Managed )