Senior Data Engineer - Remote

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 Customer Data portfolio. Responsibilities include but are not limited to:Responsibilities:Design and develop high quality, scalable software modules for next generation analytics solution suitePrototype 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 complexityConsults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needsWorks 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 toolsProvides 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 designFormulates 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 necessaryPrimary 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 activitiesReview, evaluate and prepare periodic activity and progress reports for the teamQualifications: Bachelor's degree with at least 7 years of applicable work experience.7+ years ETL / Data Integration / Big Data / Cloud (AWS) Technologies experienceAWS / Big Data Technologies certification preferredKnowledge of Oracle, Talend, Unix/Linux Shell scripting, Autosys scheduling tool, Sub Version, version control ToolsStrong data warehouse applications knowledge in financial/insurance domain is preferredKnowledge of Erwin modeling, Big Data Distributed Processing (HDFS, Spark, Pypspark), AWS, Data Analytical languages R, Python preferredExperience with one or more SQL-on-Hadoop technology (Spark SQL, Presto, Hive)Experience developing software code in on or more programming languages (Java, Python, Scala etc.)Experience with Snowflake cloud data platform including hands-on experience with snowflake utilities like SnowSQL, Snow pipe.Experience working with semi-structured data (XML, JSON)Experience in building and automation of data ingestion in near-real time from cloud blob storageExperience working on change data capture (CDC) with Streams & TasksEfficient scripting skills in languages like JavaScript, Python, PHPExperienced in Agile and Kanban MethodologiesEqual Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/AgeSr Data Engineer - GE07BE