Data Engineer - Hartford, United States - The Hartford

Description

Data Engineer - GE08AE

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.

Join an exciting team of motivated Data 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 principals to pivot quickly and deliver outcomes.

What's in it for you?

• Work on visible and business-critical systems.
• Ability to brainstorm and develop creative and unique solutions.
• An environment for learning and personal development through cross team collaboration.

What are we looking for?

• The successful candidate must be able to work with several different tools and technologies.
• Much of the systems development will require an understanding of object-oriented design as well as having some background in database technologies.
• A creative individual with strong software development and communications skills.
• This role will have a Hybrid work arrangement, with the expectation of working in an office ( Hartford, CT ) 3 days a week (Tuesday through Thursday).

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 new technologies (AWS – Cloud)
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity.
• Migrate on-prem databases/data warehouses/applications to Cloud (AWS)
• 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 the product owner 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 devises, tests and implements efficient, cost-effective application program solutions (e.g., codes and/or reuses existing code through the use of program development software alternatives and/or integrates purchased solutions)
• Prepares charts, tables, and diagrams to assist in analyzing problems, utilizing various business, scientific, engineering, and mathematical techniques. Analyzes existing system and programming logic to provide more efficient machine operations or to identify difficulties, and revises the logic and procedures involved as necessary.

Qualifications:

• Candidate must be authorized to work in the US without company sponsorship.
• The Hartford will not support the STEM OPT I-983 Training Plan endorsement for this position
• Bachelors in computer science or a related discipline and at least 4 years or an equivalent combination of education and work experience
• 3+ years 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, ThoughtSpot, and PowerBI.
• 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.)
• Knowledge of Erwin modeling, data vault 2.0, Big Data distributed processing preferred.
• Knowledge of MS SQL, Oracle, Talend, 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 in building and automation of data ingestion in near-real time from cloud blob storage
• 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.
• Knowledge of general operational data & processes and related business and employee performance metrics.
• AWS Technologies certification preferred.

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.

Compensation

The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford's total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:

$97,600 - $146,400

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us ) | Culture & Employee Insights ) | Diversity, Equity and Inclusion ) | Benefits )

Human achievement is at the heart of what we do.

We believe that with the right encouragement and support, people are capable of achieving amazing things.

We put our belief into action by ensuring individuals and businesses are well protected, and by going even further – making an impact in ways that go beyond an insurance policy.

Nearly 19,000 employees use their unique talents in careers that span a variety of disciplines – from developing the latest technology to creating and promoting our products to evaluating future financial risks.

We're also committed to programs that drive education and support volunteerism, which put human beings first. We do it because it's the right thing to do, and because when our customers, communities and employees succeed, we all do.

About Us )

Culture & Employee Insights

Diversity, Equity and Inclusion )

Benefits

Legal Notice )

Accessibility StatementProducer Compensation ) EEO

Privacy Policy )

California Privacy Policy

Your California Privacy Choices )

International Privacy Policy

Canadian Privacy Policy )