Assoc Data Engineer - GE08BE 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. A new role can expand your knowledge and your network, and help you learn more about our business. If you think this opportunity is a fit for your career you should apply. If you are not sure you can have a conversation with your manager. The Hartford's Personal Lines Data Analytics Organization is seeking an Associate Data Engineer. We are seeking a talented professional with a proven track record of data engineering using Cloud (AWS) and Big Data Technologies. Our ideal candidate will leverage deep technical expertise and strong communication skills to advanced Data Engineering practices in Personal Lines space. This Data Engineer will work directly with Data Science team to transform the current class plans which in turn improves customer experience and retention. Candidates must be authorized to work in the US without company sponsorship . The company will not support the STEM OPT I-983 Training Plan endorsement for this position. This role will have a Hybrid work arrangement, with the expectation of working in an office location 3 days a week (Tuesday through Thursday). Responsibilities: + Collaborates and works closely with stakeholders, product owner, and development team to apply advanced analytics techniques to analyze data, validate assumptions, and deliver data assets. + Extracts and manipulates data from various databases in Oracle, Snowflake and Hadoop into information fit for further analysis leveraging Python. + Implement the transformation roadmap using a new data reference architecture leveraging AWS, Snowflake and Big Data (HDFS, Hive, Spark, Pyspark) + Performs analytical data discovery and to reveal value-added insight through better understanding of data by working on ad-hoc and reoccurring analyses. + Design and develop high quality and scalable data transformation modules. + Analyze existing architectures and programming logic to provide more efficient automated solutions. + Prototype high impact innovations, catering to changing business needs, by leveraging new technologies (AWS – Cloud and Big Data) + Collaborates within the agile team to support data needs and team members. + Natural curiosity with a strong desire to learn, maintain, and apply knowledge of emerging data technologies, tools, methodology, and general best practices + Strong analytical, critical thinking and problem solving skills + Excellent written, verbal communication and presentation skills with ability to effectively tell story through data. Qualifications: + 1+ years ETL / Data Integration / Big Data / Cloud (AWS) Technologies experience + Bachelor’s degree in Finance, Statistics, Computer Science, or other related field + AWS / Big Data Technologies certification preferred. + Experience required in at least three of the following platforms: Oracle, PL/SQL, Hadoop, Snowflake or AWS. + Experience with one or more SQL-on-Hadoop technology (Spark SQL, Presto, Hive) + Experience required in Python or Pyspark. + Knowledge on Data warehousing concepts + Experience required in basic github operations. + Self-motivated, strong sense of ownership/accountability, and results oriented with the ability to manage time and schedules effectively 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: $72,400 - $108,600 Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age About Us (https://www.thehartford.com/about-us) | Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) | Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) | Benefits (https://www.thehartford.com/careers/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 (https://www.thehartford.com/about-us) Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) Benefits (https://www.thehartford.com/careers/benefits) Legal Notice (https://www.thehartford.com/legal-notice) Accessibility StatementProducer Compensation (https://www.thehartford.com/producer-compensation) EEO Privacy Policy (https://www.thehartford.com/online-privacy-policy) California Privacy Policy Your California Privacy Choices (https://www.thehartford.com/data-privacy-opt-out-form) International Privacy Policy Canadian Privacy Policy (https://www.thehartford.com/canadian-privacy-policy) Unincorporated Areas of LA County, CA (Applicant Information)