Data Engineer

Data Engineer - GE08AE

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.   

         

Join a 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.

What’s in it for you?

• 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.
• Ability to grow as a technical leader developing industry leading technical solutions.

What are we looking for?

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

Responsibilities:

• 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 modern technologies (AWS – Cloud)
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity.
• Provide technical leadership and guidance to more junior members of team/department.
• 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 product owners 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. 

Candidate 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.

 Required Qualifications:

• ETL / Data Integration / Cloud Technologies: 2+ years of experience, particularly with AWS.
• Domain Expertise: Strong understanding of data warehousing fundamentals
• Data Integration: Proven experience in designing and integrating quality data assets for optimal use in BI tools like Tableau and PowerBI.
• Programming Languages: Skilled in developing code in one or more languages (e.g., Java, Python, Scala, Hive, R, Spark).
• Snowflake Platform: Hands-on experience with Snowflake cloud data platform and utilities such as SnowSQL and Snowpipe.
• Database and Scripting: MS SQL, Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, and version control tools.

Preferred Qualifications: