Lead Data Engineer (Azure Data Factory, Azure Synapse)
Lead Data Engineer (Azure Data Factory, Azure Synapse)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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:
Lead Analytics Engineer will provide technical expertise in designing and building Modern Data warehouse in Azure Cloud to meet the data needs for various BU in Gartner. You will be part of the Ingestion Team to bring data from multiple sources into the Data warehouse. Collaborate with Dashboard Analytic & Business Team to build end to end scalable data pipelines.
What you will do:
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 on Data warehouse architecture and technical design discussions
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 higher management.
Help build defining best practices & 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 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.
What you will need:
6-8 years experience in Data warehouse design & development
Experience in ETL using Azure Data Factory (ADF)
Experience in writing complex TSQL procedures in Synapse / 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
Nice to Have:
Experience with version control systems (e.g. Git Subversion)
Power BI and AAS Experience for Tabular model design.
Experience with Data Intelligence platforms like Databricks
Who you are:
Effective time management skills and ability to meet deadlines
Excellent communications skills interacting with technical and business audiences
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
Dont meet every single requirement We encourage you to apply anyway. You might just be the right candidate for this or other roles.
#LI-PM3
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 weve grown to more than 21000 associates globally who support 14000 client enterprises in 90 countries and territories. We do important interesting and substantive work that matters. Thats 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 its 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 Companys career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at 1 or by sending an email to.
Job Requisition ID:101783By 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: efficient navigation through the application please only use the back button within the application not the back arrow within your browser.
Employment Type
Full-Time
