Data Team Lead - Cloud, Snowflake & Python

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.

About Us | Our Culture | What It’s Like to Work Here