Data engineer SQL and DBT 2 to 4yrs exp
Gurgaon - Cyber Park, India
⚠️ We'll shut down after Aug 1st - try foo🦍 for all jobs in tech ⚠️
Gartner
Gartner provides actionable insights, guidance, and tools that enable faster, smarter decisions and stronger performance on an organization’s mission-critical priorities.About Gartner Digital Markets:
Gartner Digital Markets is a business unit within Gartner. Our mission is to help small businesses make the right technology choices and find the tools they need to grow, optimize, and become more effective at what they do. The business is comprised of three top brands—Capterra, Software Advice, and GetApp. For candidates interested in taking their next career step in the technology space, Gartner Digital Markets offers the fast pace and excitement of working for a startup, the stability and resources of a large, established organization, and the opportunity to be on the front lines of innovation in an industry that is always growing and transforming.
About the role:
Gartner Digital Markets is looking for a passionate Analytics Engineer for the Data team. Analytics Engineers sit at the intersection of business teams, Data Analytics and Data Engineering and are responsible for bringing robust, efficient, and integrated data models and products to life. Analytics Engineers speak the language of business teams and technical teams, able to translate data insights and analysis needs into models powered by the Enterprise Data Platform. The successful Analytics Engineer can blend business acumen with technical expertise and transition between business strategy and data development.
What You Will do:
Collaborate with business and engineers to collect project requirements, define successful analytics outcomes, and design data models.
Understand business processes and objectives and translate them into operational data management processes and models.
Design, develop, and maintain DBT code and Snowflake tasks to build an Enterprise Dimensional Model
Design efficient solutions to consolidate data from RDBMS systems, Enterprise Applications and 3rd party APIs through ELT processes into an Enterprise Data Model.
Organize, optimize and debug data-driven reporting, BI and analytics applications
Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale data warehouse and data lake environment. Maintain and advocate for these standards through code review.
Utilize the Data Platform to build data products and provide feedback to the Data platform team to build new features.
Design and maintain conceptual and logical data models (e.g., Kimball, Inmon, Data Vault) and supporting ERDs.
Develop, optimize, and document data transformation processes using SQL and leading tools (e.g., Snowflake, DBT).
Apply best practices in code versioning, CI/CD, and workflow automation within data engineering processes.
What You Will Need:
2 – 4 years’ experience in data engineering, analytics, or a related field.
Advanced SQL proficiency and practical experience in data modelling and transformation.
Familiarity with modern data transformation tools (DBT preferred) and relational databases (e.g., Snowflake, MS SQL Server, PostgreSQL).
Demonstrated ability to troubleshoot, optimize, and resolve data quality and performance issues.
Strong verbal and written communication skills in English.
What you will get:
Competitive salary, generous paid time off policy and more!
India: Group Medical Insurance, Parental Leave, Employee Assistance Program (EAP)
Collaborative, team-oriented culture that embraces diversity
Professional development and unlimited growth opportunities
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-VG1
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.
Job Requisition ID:100623By 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Arrow CI/CD Data Analytics Data management Data quality Data warehouse dbt ELT Engineering Model design MS SQL PostgreSQL Privacy RDBMS Snowflake SQL
Perks/benefits: Career development Competitive pay Insurance Medical leave Parental leave Startup environment Unlimited paid time off
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.