Senior Data Engineer Hybrid

Sr Data Engineer - GE07BE

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.   

         

The Hartford’s Enterprise Data Services (EDS) goal is to achieve greater business value through the use of data by simplifying the architecture, standardizing process, and tools, and building a data culture across the enterprise.

The Hartford's Enterprise Data Services department is seeking a Sr. Data Engineer/Tech Lead. We are seeking a talented professional with a proven track record of engineering and operationalizing a next generation analytics solution suite using Cloud Technologies such as Snowflake, 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 Enterprise portfolio.

This role will have a Hybrid work arrangement, with the expectation of working in an office (Hartford, CT, Charlotte, NC, ) 3 days a week (Tuesday through Thursday).

Responsibilities include but are not limited to:

• Ability to create, troubleshoot, enhance complex code in Snowflake, Cloud (AWS), Python\PySpark to support data analytics and reporting efforts.
• Experience in performing ETL utilizing MSBI, SQL Server and ORACLE PL/SQL is highly preferred.
• Data integration and experience in distributed data systems – expert in effectively linking, transforming and transferring of data between multiple On-Prem or Cloud based applications.
• 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.
• Act as a Technical Leader that provides technical guidance and best practices and drives the team towards successful delivery.
• Consults with functional management in the analysis of short- and long-term business requirements and recommends innovations which anticipate the future impact of changing business needs.
• 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 using 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.
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity.
• Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design.
• Support and quickly respond to Production issues and requirements clarifications.
• Coordinate as needed between multiple disciplines such as, Architects, Business Analysts, Scrum Masters, and Developers to get technical clarity leading to design, develop and implementation of business solution.
• Oversight of quality and completeness of detailed technical specifications, solution designs, and code reviews as well as adherence to the non-functional requirements.
• Participate as active agile team member to help drive feature refinement, user story completion, code review, etc.
• Identify, document, and communicate technical risks, issues and alternative technical solutions discovered during project.
• Collaboration with a high-performing, forward-focused team, Product Owner(s) and Business stakeholders.

Qualifications:

• Bachelor’s degree in computer science or a related discipline and 7 or more years of experience in IT systems analysis and application program development, or an equivalent combination of education and work experience.
• Strong data warehouse applications knowledge in preferably in financial/insurance domain is required
• 5+ years of experience in AWS cloud and Python/ PySpark.
• Snowflake database experience is preferred.
• 5+ years of data analysis, manipulation, and development.
• 1+ years of experience in the insurance or investment industry is preferred.
• Strong SQL skills
• Experience in performing ETL through SSIS/SSRS and MS SQL Server Database is highly preferred.
• Knowledge of Oracle, Unix/Linux Shell scripting, Autosys/Airflow scheduling tool is preferred
• Knowledge of GitH