Data Team Lead - Cloud, Snowflake & Python

The Hartford India; Hyderabad; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

The Hartford India in Hyderabad, India, is looking for a Staff Software Engineer to join an agile data and cloud-focused team. You will design scalable data assets, implement BI reporting, and prototype innovative solutions leveraging Snowflake, AWS, and Python in a fast-paced environment.

You will collaborate with product owners and IT stakeholders to estimate work, ensure data quality, and support critical business systems while enhancing analytics capabilities and data-driven decisions.

Qualifications

• 6–9 years of data engineering / software development experience.
• Experience with AWS and cloud data platforms.
• Strong BI data assets design for Tableau/PowerBI.
• Snowflake expert with SnowSQL and data pipelines.
• Proficiency in Python and Java in data processing.
• Knowledge of data warehousing in finance/insurance.
• Experience with XML/JSON and CDC in streaming.
• Agile Scrum/Kanban experienced with cross-functional teams.

Responsibilities

• Design and develop scalable data assets for BI and analytics.
• Design and implement BI reporting solutions.
• Prototype innovations using AWS cloud.
• Collaborate with product owners for feature estimation.
• Coordinate with cross-functional IT stakeholders.
• Review and implement disaster recovery plans.
• Lead with strong technical consulting.

Skills

ETL/Data integration

AWS cloud

DotNet/C++

Tableau

PowerBI

Snowflake

Python

Java

Scala

Hive

R

Spark

XML/JSON

CDC/Streams

Agile/Scrum

Kanban

Communication skills

Problem solving

Agile teams

Tools

SnowSQL

SnowPipe

MS SQL

Oracle

Unix/Linux Shell scripting

Autosys

Version control

Job description

IND Staff Software Engineer - GCC011

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.

Job Description: Tech Lead (Staff Associate / Engineer) – Cloud, Snowflake & Python

Location: Hyderabad, India

Employment Type: Full-Time

Experience Level: 6- 9 Years

About The Company

Our client is a leader in property and casualty insurance, employee benefits and mutual funds. One of the largest insurers in the United States with many decades of expertise, this company is widely recognized for its service excellence, sustainability practices, trust and integrity.

Position Overview

We are seeking a motivated and skilled Software Engineer to join an exciting team of motivated Engineers focused on delivering meaningful value through highly tailored data and software solutions. You will work in an agile environment with technology and investment professionals to solve real world problems that directly impact the business. This is an opportunity for an individual with a passion for understanding business challenges to help develop creative solutions on business-critical systems. You will work with a high performing and collaborative team while utilizing agile principles to pivot quickly and deliver outcomes.

Key Responsibilities

• Design and develop high quality, scalable data assets that support contemporary BI tools and advanced analytics.
• Help to design and implement best in class data-visualization and reporting solutions leveraging a number of modern BI solutions.
• Prototype high impact innovations, catering to changing business needs, by leveraging modern technologies (AWS – Cloud)
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity.
• Consults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needs.
• Provides highly technical consulting and leadership in identifying and implementing new uses of information technologies that assist the functional business units in meeting their strategic objectives.
• Review and implement the disaster recovery plan to ensure that new systems promote uninterrupted systems operation.
• Coordinate activities with cross-functional IT unit stakeholders (e.g., database, operations, telecommunications, technical support, etc.)
• Work closely with product owners to evaluate stakeholder requested features and provide input on estimating effort and feasibility for release level and sprint planning.
• Formulates logical statements of business problems and devices, tests and implements efficient, cost-effective application program solutions.

Required Skills & Experience

• ETL / Data Integration / Cloud (AWS) Technologies experience
• Relevant development experience with .NET, C#, or C++ is desired.
• Experience designing and integrating quality data assets for optimal use in BI tools like Tableau and PowerBI.
• Expert level experience with Snowflake cloud data platform including hands-on experience with snowflake utilities like SnowSQL, Snow pipe. Experience developing code in one or more programming languages (e.g. Java, Python, Scala, Hive, R, Spark etc.) Experience in Python Programming
• Expert level knowledge of Snowflake, MS SQL, Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, version control Tools
• Strong data warehouse applications knowledge in financial/insurance domain
• Experience working with semi-structured data (XML, JSON)
• Experience working on change data capture (CDC) with Streams & Tasks
• Experienced in Agile Scrum and Kanban Methodologies
• Requires excellent business communication skills, analytical ability, strong judgment and management skills, and the ability to work effectively with Business and IT management and staff.
• Strong analytical and problem-solving skills.
• Experience working in Agile teams.
• As a condition of your employment for HIMCO, you will be required to affirm to HIMCO’s Code of Ethics and understand that you will be required to comply with the disclosure of accounts, holdings and pre-clearance of trades for the accounts of you and your household family members as more fully described in the Code of Ethics Key Points. If you will be deemed to be a “Covered Associate” under HIMCO’s Pay to Play Policy, you will also need to disclose all political contributions that you have given within the past 2 calendar years.

Preferred Skills & Experience

• AWS Technologies certification preferred
• Knowledge of any Data Modeling tool, data vault 2.0, Big Data distributed processing preferred.

What We Offer

• Opportunity to work on advanced cloud development.
• Collaborative and innovative work environment.
• Competitive compensation and comprehensive benefits.
• Continuous learning and professional development opportunities.
• Work on visible and business-critical systems.
• Ability to brainstorm and develop creative and unique solutions.