Data Engineer - Production Support

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.

The Data Engineer will provide technical expertise in managing production data quality tasks and will provide end‑to‑end support for daily data loads for an Azure Cloud‑based modern data warehouse environment. You will join the CDAO Production Support Group, where you will be responsible for daily activities focused on maintaining the highest standards of data quality.

• Provide support to business users accessing Power BI dashboards and Data Warehouse tables. Manage incidents and service requests, ensuring resolution within defined SLAs.

• Work with the team on managing Azure resources including but not limited to Databricks, Azure Data Factory pipelines, ADLS, etc.

• Build new ETL/ELT pipelines using Azure Data Products such as Azure Data Factory, Databricks, etc.

• Contribute to the development of best practices and processes.

• Monitor & support various data loads for our Enterprise Data Warehouse.

• Coordinate with upstream/downstream teams to resolve data issues.

• Collaborate with the QA and Development teams to ensure appropriate automated regression tests are implemented to detect similar issues in the future.

• Partner with the Development team to enhance automated error handling, aiming to minimize the need for manual interventions.

• Analyze processes and patterns to proactively identify and resolve other similar, unreported Production data issues collectively.

• 2‑3 years of experience in Data warehouse design & development and ETL using Azure Data Factory (ADF).

• Experience in writing complex TSQL procedures on MPP platforms – Synapse, Snowflake, etc.

• Experience in analyzing complex code to troubleshoot failure and where applicable recommend best practices around error handling, performance tuning, etc.

• Ability to work independently, as well as part of a team and experience working with fast‑paced operations/development teams.

• Good understanding of business processes and analyzing underlying data. Understanding of dimensional and relational modeling.

• Knowledge of Azure cloud technologies.

• Exceptional problem‑solving skills.

• Experience crafting, building, and deploying applications in a Dev Ops environment utilizing CI/CD tools.

• Understanding of dimensional and relational modeling.

• Relevant certifications.

• Basic knowledge of Power BI.

• Bachelor's degree or foreign equivalent degree in Computer Science or a related field required.

• Excellent communication skills.

• Able to work independently or within a team proactively in a fast‑paced AGILE‑SCRUM environment.

• Owns success – takes responsibility for the successful delivery of the solutions.

• Strong desire to improve upon their skills in tools and technologies.

• Competitive compensation.

• Limitless growth and learning opportunities.

• Ongoing mentorship and apprenticeship;
  Leadership courses, development programs, technical courses, certification opportunities and more!

• A collaborative and positive culture – join a diverse team of professionals that are as smart and driven as you.

• A chance to make an impact – your work will contribute directly to our strategy.

• Hybrid Work Environment – enjoy the flexibility of working from home and the energy of collaborating with peers in our dynamic offices.

• 20+ PTO days plus holidays and floating holidays in your first year.

• Extensive medical, dental insurance and vision plan.

• 401K with corporate match, immediate vesting.

• Health‑and‑wellness‑related allowance programs.

• Parental leave.

• Tuition reimbursement.

• Employee Stock Purchase Plan.

• Employee Assistance Program.

• Gartner Gives Charity Match.

Gartner provides 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.