Senior Data Engineer

Date Posted: 05/07/2025

Hiring Organization: Rose International

Position Number: 482310

Job Title: Senior Data Engineer

Job Location: Hartford, CT, USA, 06155

Work Model: Hybrid

Employment Type: Temporary

Estimated Duration (In months): 7

Min Hourly Rate ($): 60.00

Max Hourly Rate ($): 71.00

Must Have Skills/Attributes: Agile, AWS, Data Engineer, ETL, Oracle, PL/SQL, Snowflake

Job Description

Required Education:

Bachelor's degree with at least 5 or more years of applicable work experience with respect to Data Analysis, manipulation, and technical development

Preferred Education:

Desired educational experience includes, but are not limited to: Computer Science, Engineering, IT, Management Information Systems, Data Analytics, Applied Mathematics, and Business.

Required Skills for the Senior Data Engineer:

Desire candidates with prior Data Engineer/ETL competencies and prior experience with successful enablement of Data Delivery initiatives.

Knowledge of ETL tools like Informatica & Talend; relational databases like Oracle & Snowflake; Oracle PL/SQL etc.

Understanding of current and emerging IT products, services, processes and methodologies.

Analytical approach with a strong ability to uncover and resolve problems by delivering innovative approaches and solutions.

Technical leadership with respect to design, implementation and overseeing complex technical processes

Strong ability to estimate project tasks and to deliver upon committed dates. Ability to develop and maintain systems according to a defined set of standards.

Experience with AWS Services (i.e. S3, EMR, etc) a plus

Experience with Cloud data warehouses, automation, and data pipelines (i.e. Snowflake, Redshift) a plus

Experience using Gen AI solutions to automate data engineering pipelines preferred.

Ability to work as part of and with high performing teams.

Senior Data Engineer Overview:

Join a fast-paced and talented Agile/Kanban team to unlock Data Capabilities for the Company's Business Insurance Production Support and Maintenance organization. You will have an opportunity to maintain Legacy data assets using Oracle. Position will design, develop, and maintain large scale data assets across data warehouses, data marts, and data processes, leveraging next generation data and analytic technology stack across AWS Cloud, Informatica IDMC, Snowflake, and Big Data; focus on addressing challenges across legacy tech stack, data freshness issues, speed of delivery and quality; drive a technology step change by enabling business while simplifying the data and Informatica, while growing your knowledge with emerging technologies as we move aggressively with cloud-based assets. We use both Legacy and latest DATA technologies, software engineering practices, Agile delivery framework, and are passionate about technology and building well architected and innovative solutions that drive optimal business value generation. Data environment and improving speed of delivery; provide technical leadership, mentoring, and coaching to technical team; implement design patterns across the portfolio delivery teams; deliver high quality work of high technical complexity; research and evaluate alternative solutions and recommend the most efficient and cost-effective solution for the systems design.

Responsibilities:

Design and develop high quality, scalable software modules for next generation analytics solution suite

Prototype high impact innovations, catering to changing business needs, by learning and leveraging new technologies (AWS Cloud, Big Data, Snowflake, Informatica Cloud).

Integrate with Data Quality Services to ensure Quality data is Published to consumers.

Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of varying technical complexity

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

Works 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 tools

Exposure to CI/CD processes and experience working with GIT, Jenkins, Urban Code Deploy, Nexus repositories

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 design

Work within a self-organized scrum development team regarding all design and implementation

Only those lawfully authorized to work in the designated country associated with the position will be considered.

Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.