Data Analyst (SQL expert)

About this role:

Consulting, Strategy & Operations is a division within Gartner which encompasses Consulting Technology and other core functions to support Gartner’s Consulting teams. This role will partner with key business stakeholders across the company to support a Consulting organization of more than 1,000 associates. Consulting Technology is on the forefront of innovation helping Consulting Associates to sell and deliver high quality engagements.

We are seeking a highly skilled Data Analyst to join a group of professionals who are participating in the exciting phase of revolutionizing Analytics for Consulting Business Unit. This role is pivotal in ensuring data accuracy, consistency, and accessibility across the organization. The ideal candidate will have a strong foundation in SQL, data warehousing, and dimensional modeling, and the ability to translate complex business requirements into effective data solutions

• Conduct in-depth data analysis primarily to extract meaningful insights from various data sources using SQL.

• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications.

• Ensure data quality and integrity through rigorous data cleansing, transformation, and validation processes.

• Understand business stakeholders’ objectives, metrics that are most important to them, and how they measure performance

• Develop and maintain data documentation and metadata.

• Ensure data quality and integrity through rigorous data cleansing, transformation, and validation processes.

• Communicate complex findings effectively to both technical and non-technical audiences.

• Identify patterns and trends in user data to uncover opportunities

• Share knowledge and skills with your teammates to grow analytics impact on Gartner Consulting

• Responsible for version control and creating technical documentation

What you will do:

Expected Results:

• Deliver actionable insights: Provide data-driven recommendations that directly impact business decisions and outcomes.

• Improve business performance: Develop and implement data-driven solutions to optimize key business metrics and processes.

• Enhance data infrastructure: Collaborate with cross functional data teams to improve data quality, accessibility, and efficiency.

• Build strong partnerships: Foster collaborative relationships with business stakeholders to understand their needs and deliver value.

• Elevate data culture: Promote a data-driven culture within the organization through knowledge sharing and training.

What you will need:

• 3+ years of analytical experience in Data and Analytics: Building complex queries in SQL and conducting Data Analysis.

• Graduate or equivalent level qualification, preferably in a related discipline; Master’s degree preferred

• Proven experience in data modeling, with a minimum of 3 years working with dimensional data models.

• Strong business acumen and the ability to translate complex business requirements into efficient and scalable technical solutions.

• Strong analytical and problem-solving skills with a keen eye for detail and a passion for uncovering insights.

• Strong problem solving, quantitative and analytical abilities

• Experience with cloud-based data platforms such as Databricks or Snowflake is a plus.

• Experience in Python is a plus.

• Experience working with Power BI is preferred but not required

• Solid written and verbal communication skills and knowledge to build strong relationships and influence across Consulting

• Proven ability to solve complex problems and thrive in dynamic, fast-paced environments

• Proficient in navigating fast-paced, technically demanding, and goal-oriented work environments.

Key Competencies:

• Curiosity: A strong desire to explore data and uncover insights. 

• Coachability: Openness to feedback and a growth mindset, with a willingness to learn and develop new skills.

• Problem-solving: Strong analytical and problem-solving skills to identify data-driven solutions to business challenges.

• Data-Driven Decision Making: Proven ability to leverage data insights to inform business strategy.

• Communication: Effective communication skills, both written and verbal, to articulate complex technical concepts to technical and non-technical audiences

• Collaboration: Ability to work collaboratively with cross-functional teams to achieve shared goal

• Attention to Detail: Meticulous attention to data accuracy and consistency.

#LI-SS10

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 20,000 associates globally who support ~15,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 affirmatively 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.