The Hartford
Senior Data Engineer - Hybrid
The Hartford, Hartford, Connecticut, us, 06112
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 Organization 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 Oracle PL/SQL, 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 Enterprise portfolio.This role will have a Hybrid work arrangement, with the expectation of working in an office location (Hartford, CT) 3 days a week (Tuesday through Thursday).Responsibilities
Ability to create, troubleshoot, enhance complex ETL like Oracle PL/SQL and SSIS code packagesAbility to lead and operate in cloud environment involving AWS, Snowflake and migrate data assets to cloudData integration and experience in distributed data systems – expert to effectively linking, transforming and transferring of data between multiple applications on Prem or Cloud-basedProvides highly technical consulting and leadership in identifying and implementing new uses of information technologies that assist the functional business units in meeting their strategic objectivesAct as a Technical Leader that provides technical guidance and best practices adherence as neededConsults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needsFormulates 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 necessaryPossesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexityResearches and evaluates alternative solutions and recommends the most efficient and cost effective solution for the systems designSupport and quickly respond to Production issues and requirements clarificationsCoordinate 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’ experience in IT systems analysis and application program development, or an equivalent combination of education and work experience5+ years strong Database Developer experience using Oracle PL/SQL – stored procedures, packages, functions, querying, testing, and deploying1-3 years experience of migrating assets to cloud - AWS and Snowflake environment5+ years of data analysis, manipulation and development1+ years of experience in the insurance or investment industryStrong SQL skillsKnowledge of Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, Sub Version, and Github /Jenkins (CI/CD) version control ToolsStrong data warehouse applications knowledge in financial/insurance domainKnowledge of Data Modeling and Database design is key to this roleAbility to design, implement, and oversee ETL processesFamiliarity with emerging data centric technologies such as data virtualizationAbility to choose and effectively utilize data wrangling technologiesExposure to cloud, Python/ Pyspark, Shell Scripting (e.g. AWS, S3, UNIX, Python, Snowflake, etc.) and learning/adapting to future technologies is preferred but not required.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: $113,360 - $170,040Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/AgeAbout Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits
#J-18808-Ljbffr
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 Organization 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 Oracle PL/SQL, 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 Enterprise portfolio.This role will have a Hybrid work arrangement, with the expectation of working in an office location (Hartford, CT) 3 days a week (Tuesday through Thursday).Responsibilities
Ability to create, troubleshoot, enhance complex ETL like Oracle PL/SQL and SSIS code packagesAbility to lead and operate in cloud environment involving AWS, Snowflake and migrate data assets to cloudData integration and experience in distributed data systems – expert to effectively linking, transforming and transferring of data between multiple applications on Prem or Cloud-basedProvides highly technical consulting and leadership in identifying and implementing new uses of information technologies that assist the functional business units in meeting their strategic objectivesAct as a Technical Leader that provides technical guidance and best practices adherence as neededConsults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needsFormulates 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 necessaryPossesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexityResearches and evaluates alternative solutions and recommends the most efficient and cost effective solution for the systems designSupport and quickly respond to Production issues and requirements clarificationsCoordinate 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’ experience in IT systems analysis and application program development, or an equivalent combination of education and work experience5+ years strong Database Developer experience using Oracle PL/SQL – stored procedures, packages, functions, querying, testing, and deploying1-3 years experience of migrating assets to cloud - AWS and Snowflake environment5+ years of data analysis, manipulation and development1+ years of experience in the insurance or investment industryStrong SQL skillsKnowledge of Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, Sub Version, and Github /Jenkins (CI/CD) version control ToolsStrong data warehouse applications knowledge in financial/insurance domainKnowledge of Data Modeling and Database design is key to this roleAbility to design, implement, and oversee ETL processesFamiliarity with emerging data centric technologies such as data virtualizationAbility to choose and effectively utilize data wrangling technologiesExposure to cloud, Python/ Pyspark, Shell Scripting (e.g. AWS, S3, UNIX, Python, Snowflake, etc.) and learning/adapting to future technologies is preferred but not required.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: $113,360 - $170,040Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/AgeAbout Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits
#J-18808-Ljbffr