Sr. Staff Data Engineer (Tech Lead) - Hybrid

Sr Staff Data Engineer - GE07DE

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.   

         

Enterprise Data Services  - Sales & Distribution IT  is undergoing a transformation to the Cloud, and we are looking for an enthusiastic Sr. Staff Data Engineer to join our team. In this role, you will be leading the efforts to develop, enhance, and support new and existing ETL data pipelines, ingestions, and storage across various medium and large sized projects concurrently. This is an individual contributor position responsible for expanding and optimizing data pipeline and product architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up.

You will work on implementing complex data projects, focusing on collecting, parsing, managing, analyzing, and visualizing large sets of data to turn information into insights using multiple platforms. You will support our software developers, data architects, analysts and data scientists on vital initiatives and ensure optimal data delivery architecture. You will lead the design of vital components and suggest/implement new frameworks and tools based on industry and technological trends and advances. You will also consult with process owners in reviewing, interpreting & developing systems in accordance with user requirements and ensuring code quality through proper documentation, best practices, and code reviews. Working in our collaborative environment, you will further develop your skills while also acting as a mentor and technical guide to other data engineers.

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

Job responsibilities:

• Demonstrate self-initiation and ability to learn new technology stacks as per the defined architecture
• Design, develop, and maintain data pipelines for extraction, transformation, and loading processes using ETL tools and R/Python in Cloud and Oracle/SQL Server environments to support data analytics and reporting efforts.
• Utilize modern cloud ETL tools and Big Data Platforms like Hadoop, etc to develop complex data assets that support organizational decision making via prototyping, data discovery, profiling, etc…
• Prototype high impact innovations, catering to changing business needs, by leveraging new technologies (AWS – Cloud and Big Data)
• Act as a Subject Matter expert on existing data assets through root cause analysis and resolution of any business/technical questions
• You will develop and implement Proof of Concepts (PoCs), generic frameworks, and real-time pipelines using SQL, Amazon Web Services (AWS), ETL tools, Snowflake, and Python.
• You will introduce automation of software application development using Continuous Integration/Continuous Delivery (CI/CD) methodologies.
• Support documentation, metadata, and data visualization of the assets
• Participate in the development of the implementation plan as a subject matter expert
• Develop and support the migration activities of reporting assets from SQL Server / .Net stack to Snowflake / Tableau / ThoughtSpot.
• Collaborate with the Enterprise Data teams to provide user acceptance testing, maintain data quality, and advance the technical toolset.
• Coordinate activities with cross-functional IT unit stakeholders (e.g., database, operations, telecommunications, technical support, business etc.)
• Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design
• Review sprint plan, disaster recovery plans, evaluate system readiness and prepare periodic activity and progress reports for the team
• Develop and maintain data analytics tools and frameworks to support Artificial Intelligence & Machine Learning use cases.
• Stay up to date with emerging data technologies and industry best practices.
• Demonstrate a strong willingness to explore and leverage new tools and technologies as per project needs.
• Confident, self-starter capable of independently driving multiple concurrent projects to completion.
   

Knowledge, Skills, and Abilities 

• Strong Technical Knowledge (Cloud data pipelines and data consumption products)
• Leader and a team player with transformation mindset.
• A