Principal Analytics Engineer- Azure data warehouse, ADF/Synapse, T-SQL, data pipeline design

About the role

The Principal Analytics Engineer will provide technical expertise in designing and building a modern data warehouse in Azure. You will join the Data Analytics and Platform & Architecture team to ingest data from multiple sources and collaborate with dashboard, analytics, and business teams to build end-to-end, scalable data pipelines

Responsibilities

• Responsible for reviewing and analysis of business requirements and design technical mapping document
• Build new ETL pipelines using Azure Data Factory and Synapse
• Design, build, and automate data pipelines and applications to support data scientists and business users with their reporting and analytics needs
• Collaborate with dashboard, analytics, and business teams to build end-to-end, scalable data pipelines.
• Perform and participate in code reviews, peer inspections and technical design and specifications, as well as document and review detailed designs.
• Provide status reports to the senior management.
• Help define best practices and processes
• Maintain Service Levels and department goals for problem resolution.
• Design and build tabular data models in Azure Analysis Services for seamless integration with Power BI
• Write efficient T-SQL queries and DAX (Data Analysis Expressions) to support robust data models, reports, and dashboards
• Tune and optimize data models and queries for maximum performance and efficient data retrieval.
• Collaborate with cross-functional teams (CDAO scrums, analytics, product, IT) to understand business requirements and deliver high-quality data solutions.
• Foster a culture of continuous learning, innovation, and collaboration within the team.

Requirements

• 6-9 years' experience in data warehouse design and development.
• Experience building ETL pipelines using Azure Data Factory (ADF)
• Experience writing complex T-SQL stored procedures in Azure Synapse / Azure SQL Data Warehouse.
• Experience in analyzing complex code and performance tune pipelines.
• Good knowledge of Azure cloud technology and exposure in Azure cloud components
• Good understanding of business process and analyzing underlying data
• Understanding of dimensional and relational modeling
• Effective time management skills and ability to meet deadlines
• Excellent communications skills interacting with technical and business audience's
• Excellent organization, multitasking, and prioritization skills
• Must possess a willingness and aptitude to embrace new technologies/ideas and master concepts rapidly.
• Intellectual curiosity, passion for technology and keeping up with new trends
• Delivering project work on-time within budget with high quality
• Owns success - Takes responsibility for successful delivery of the solutions.
• 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-JJ3
• 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 business and technology insights, helping enterprise leaders and their teams succeed with their mission-critical priorities.
• What makes Gartner a great place to work?
• Our vast, virtually untapped market potential offers limitless opportunities - opportunities that may not even exist right now - for you to grow professionally and flourish personally. 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.
• Gartner is the world authority on AI
• At Gartner, you'll join a company at the very center of the AI revolution. Gartner has proactive, objective guidance throughout clients' AI journeys. We set the standard

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at gartner? Share your experience