About the role:
Sr. Software 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:
-
4-6year 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 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
Don t meet every single requirementWe encourage you to apply anyway. You might just be the right candidate for this, or other roles.
#LI-VG1
Who are we
What makes Gartner a great place to work
What do we offer
Ready to grow your career with GartnerJoin us.
Job Requisition ID:102836
Gartner Applicant Privacy Link: https: / / jobs.gartner.com / applicant-privacy-policy