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.

Do you enjoy problem solving?

Do you enjoy cross-team collaboration?

Are you ready to make a difference?

Join an exciting team of motivated Data Engineers focused on delivering meaningful value through highly tailored data and software solutions. You will work in an agile environment with technology and investment professionals to solve real world problems that directly impact the business. This is an opportunity for an individual with a passion for understanding business challenges to help develop creative solutions on business-critical systems. You will work with a high performing and collaborative team while utilizing agile principals to pivot quickly and deliver outcomes.

• Work on visible and business-critical systems.
• Ability to brainstorm and develop creative and unique solutions.
• An environment for learning and personal development through cross team collaboration.

• The successful candidate must be able to work with several different tools and technologies.
• Much of the systems development will require an understanding of object-oriented design as well as having some background in database technologies.
• A creative individual with strong software development and communications skills.
• This role will have a Hybrid work arrangement, with the expectation of working in an office (Hartford, CT) 3 days a week (Tuesday through Thursday).

• Design and develop high quality, scalable data assets that support contemporary BI tools and advanced analytics.
• Help to design and implement best in class data-visualization and reporting solutions leveraging a number of modern BI solutions.
• Prototype high impact innovations, catering to changing business needs, by leveraging new technologies (AWS - Cloud)
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity.
• Migrate on-prem databases/data warehouses/applications to Cloud (AWS)
• Consults with functional management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needs.
• 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.
• Review and implement 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.)
• Work closely with the product owner to evaluate stakeholder requested features and provide input on estimating effort and feasibility for release level and sprint planning.
• 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 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 necessary.

• Candidate must be authorized to work in the US without company sponsorship.
• Bachelors in computer science or a related discipline and at least 4 years or an equivalent combination of education and work experience
• 3+ years ETL / Data Integration / Cloud (AWS) Technologies experience
• Relevant development experience with .NET, C#, or C++ is desired.
• Experience designing and integrating quality data assets for optimal use in BI tools like Tableau, ThoughtSpot, and PowerBI.
• Experience with Snowflake cloud data platform including hands-on experience with snowflake utilities like SnowSQL, Snow pipe.
• Experience developing code in one or more programming languages (e.g. Java, Python, Scala, Hive, R, Spark etc.)
• Knowledge of Erwin modeling, data vault 2.0, Big Data distributed processing preferred.
• Knowledge of MS SQL, Oracle, Talend, Unix/Linux Shell scripting, Autosys scheduling tool, version control Tools
• Strong data warehouse applications knowledge in financial/insurance domain
• Experience working with semi-structured data (XML, JSON)
• Experience in building and automation of data ingestion in near-real time from cloud blob storage
• Experience working on change data capture (CDC) with Streams & Tasks
• Experienced in Agile Scrum and Kanban Methodologies
• Requires excellent business communication skills, analytical ability, strong judgment and management skills, and the ability to work effectively with Business and IT management and staff.
• Knowledge of general operational data & processes and related business and employee performance metrics.
• AWS Technologies certification preferred.