Job Description

You are a driven and motivated problem solver ready to pursue meaningful work. You strive to make an impact every day & not only at work, but in your personal life and community too. If that sounds like you, then you've landed in the right place.

The Hartford's Enterprise Data Organization is seeking a Sr. Data Engineer/Tech Lead in our Hartford, CT office. We are seeking a talented professional with a proven track record of engineering and operationalizing a next generation analytics solution suite using Cloud (AWS) and Big Data Technologies. Our ideal candidate will leverage deep technical expertise and strong communication skills to deliver both invest and maintenance projects within the Personal Lines portfolio. Responsibilities include but are not limited to:

Responsibilities:

* Design and develop high quality, scalable software modules for next generation analytics solution suite
* Prototype high impact innovations, catering to changing business needs, by leveraging new technologies (AWS Cloud and Big Data)
* 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
* Works closely with client management to identify and specify the complex business requirements and processes for diverse development platforms, computing environments (e.g., Cloud, host based, distributed systems, client server), software, hardware, technologies and tools
* 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
* Reviews 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.)
* Researches and evaluates alternative solutions and recommends the most efficient and cost effective solution for the systems design
* 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
* Primary technical point of contact for interaction with other cross-functional units and teams.
* Assign personnel to the various projects or application components, and direct their activities
* Review, evaluate and prepare periodic activity and progress reports for the team

Qualifications:

* 7+ years ETL / Data Integration / Big Data / Cloud (AWS) Technologies experience
* AWS / Big Data Technologies certification preferred
* Experience developing software code in on or more programming languages (Java, Python, Scala, Hive, Spark etc.)
* Experience with Snowflake cloud data platform including hands-on experience with snowflake utilities like SnowSQL, Snow pipe.
* Experience in building data models using data vault 2.0 in snowflake platform
* Knowledge of Erwin modeling, Big Data Distributed Processing (HDFS, Spark, Pypspark), AWS, Data Analytical languages R, Python preferred
* Knowledge of Oracle, Talend, Unix/Linux Shell scripting, Autosys scheduling tool, Sub Version, 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 and Kanban Methodologies
* Bachelors degree in Computer Science or a related discipline and at least seven years experience in IT systems analysis and application program development, or an equivalent combination of education and work experience
* Requires an extensive knowledge of the system development life cycle, the client areas functions and systems, and application program development alternatives
* 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 Contact Center Processes and Applications

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

Sr Data Engineer - GE07BE