Data Engineer - Production Support

Gartner•Stamford, CT

12h•Hybrid

About The Position

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: 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.

Requirements

Strong IT professional with 2-3 years of experience in Data Engineering.
The candidate should have strong analytical and problem-solving skills.
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.
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

Nice To Haves

Experience crafting, building, and deploying applications in a DevOps environment utilizing CI/CD tools
Understanding of dimensional and relational modeling
Relevant certifications
Basic knowledge of Power BI.

Responsibilities

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.

Benefits

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.