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

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.
  

Don’t meet every single requirement? We encourage you to apply anyway. You might just be the right candidate for this, or other roles.

#LI-NS4

Who are we?

At Gartner, Inc. (NYSE:IT), we guide the leaders who shape the world.

Our mission relies on expert analysis and bold ideas to deliver actionable, objective insight, helping enterprise leaders and their teams succeed with their mission-critical priorities.

Since our founding in 1979, we’ve grown to more than 21,000 associates globally who support ~14,000 client enterprises in ~90 countries and territories. We do important, interesting and substantive work that matters. That’s why we hire associates with the intellectual curiosity, energy and drive to want to make a difference. The bar is unapologetically high. So is the impact you can have here.

What makes Gartner a great place to work?

Our sustained success creates limitless opportunities for you to grow professionally and flourish personally. We have a vast, virtually untapped market potential ahead of us, providing you with an exciting trajectory long into the future. How far you go is driven by your passion and performance.

We hire remarkable people who collaborate and win as a team. Together, our singular, unifying goal is to deliver results for our clients.

Our teams are inclusive and composed of individuals from different geographies, cultures, religions, ethnicities, races, genders, sexual orientations, abilities and generations.

We invest in great leaders who bring out the best in you and the company, enabling us to multiply our impact and results. This is why, year after year, we are recognized worldwide as a great place to work .

What do we offer?

Gartner offers world-class benefits, highly competitive compensation and disproportionate rewards for top performers.

In our hybrid work environment, we provide the flexibility and support for you to thrive — working virtually when it's productive to do so and getting together with colleagues in a vibrant community that is purposeful, engaging and inspiring.

Ready to grow your career with Gartner? Join us.

The policy of Gartner is to provide equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, ancestry, disability, veteran status, or any other legally protected status and to seek to advance the principles of equal employment opportunity.

Gartner is committed to being an Equal Opportunity Employer and offers opportunities to all job seekers, including job seekers with disabilities. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access the Company’s career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at +1 (203) 964-0096 or by sending an email to ApplicantAccommodations@gartner.com .

By submitting your information and application, you confirm that you have read and agree to the country or regional recruitment notice linked below applicable to your place of residence.

Gartner Applicant Privacy Link: https://jobs.gartner.com/applicant-privacy-policy

For efficient navigation through the application, please only use the back button within the application, not the back arrow within your browser.