NEW JOB OPENING
SENIOR DATA ENGINEER
IN Hartford, CT, USA!

 

Date Posted: 01/06/2025
Hiring Organization: Rose International
Position Number: 476204
Job Title: Senior Data Engineer
Job Location: Hartford, CT, USA, 06155
Work Model: Hybrid
Shift: Will be in the office 3 days per week (T/W/Th)
Employment Type: Temp to Hire
Estimated Duration (In months): 3
Min Hourly Rate($): 68.00
Max Hourly Rate($): 75.00
Must Have Skills/Attributes: Data Engineer, ETL, Snowflake, SQL Server

 

Job Description
Open to the below locations:

- Hartford, CT

- Charlotte, NC

- Dublin, OH

- Danbury, CT



Education Requirements:

- Bachelor’s degree



Required Skills for the Senior Data Engineer:

- 5+ years in Snowflake in AWS and Talend Data Integrator or other BI/ETL tools.

- 7+ years of hands-on experience in Data warehouse and Data Integration (ELT/ETL)

- 7+ years of Proficiency in ETL with Microsoft Business Intelligence (SSIS, SSRS) and other tools.

- 2+ years of hands-on experience with Data Visualization (preferably Tableau).

- Strong background and problem-solving skills with Enterprise Data warehouse, ETL/ELT development, Database Replication, metadata management and data quality.

- Hands-on experience in all phases of SDLC developing ETL solutions using T-SQL code, Stored Procedures, SSIS.

- Strong data warehouse applications knowledge in preferably in financial/insurance domain is required.

- Knowledge of version control tools, CI/CD pipeline and DevOps tools like GitHub, Jenkins nexus and uDeploy.

- Knowledge of Data Profiling, Data Modeling and Database design is key to this role.



Senior Data Engineer Overview:

The Enterprise Data Services department’s IT team supporting Global specialty is seeking a hands-on Senior Staff Data Engineer to enhance and support its Data assets on snowflake and SQL server platforms. We are looking for a talented professional with a proven track record of engineering the ELT development and integration using Snowflake. Our ideal candidate will leverage deep technical expertise and problem-solving skills to deliver invest, maintenance and enhancement projects within the Data & Analytics Value stream. This will be a contract to hire role.



The Senior Staff Data Engineer will be proficient with data platform architecture, design, data curation, multi-dimensional models, strong understanding of data architecture, principles of ETL and Data Warehousing. Responsibilities will also include technical delivery review, resolution of architecture issues in AWS Snowflake platform.



Responsibilities:

- Demonstrate expertise in Snowflake’s cloud native architecture and Microsoft SQL server technology.

- Ability to create, troubleshoot, enhance complex code in Snowflake and SQL server.

- Experience in building data pipelines (ELT) with Snowflake cloud data platform using AWS compute (EC2) and storage layers (S3).

- Experience in building the Snowflake SQL Data warehouse using the Virtual warehouses based on best practices.

- Hands on experience working with Talend or SSIS as an ELT tool with Snowflake and SQL server Data Integration.

- Implement and leverage Materialized views, Data Sharing, Clone Feature and Performed Dynamic data Masking.

- Have a solid understanding of delivery methodology (SDLC) and lead teams in the implementation of the solution according to the design/architecture.

- Hands on experience with Snow SQL, Stored Procedures, UDF’s using JavaScript, SnowPipe and other snowflake utilities.

- Experience in Data migration from RDMS to snowflake cloud Data warehouse.

- Experience in data security and data access controls and design.

- Solution the data loading and unloading activities to/from Snowflake.

- Experience working with Data Lakes loading disparate data sources- Structured, semi-structured data (Flat files, XML, JSON, Parquet) and unstructured data.

- Experience in building data pipelines using Talend and automation of data ingestion including change data capture (CDC).

- Integration of data pipelines with source control repository and build CI/CD pipeline and DevOps.

- Experience in Performance Tuning of Talend / SQL Agent Jobs to reduce the CPU time/load timing.

- Deeper Knowledge on Snowflake License model and their continuous data protection life cycle.

- Architect reusable Talend components such as Audit and reconciliation of jobs.

- Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design.

- Support and quickly respond to Production issues and requirements clarifications.

- Coordinate as needed between multiple disciplines such as, Architects, Business Analysts, Scrum Masters, and Developers to get technical clarity leading to design, develop and implementation of business solution.

- Oversight of quality and completeness of detailed technical specifications, solution designs, and code reviews as well as adherence to the non-functional requirements.

- Experience in delivering technical solutions in an iterative, agile environment (Scrum/Kanban)

- Participate as active agile team member to help drive feature refinement, user story completion, code review, etc.

- Identify, document, and communicate technical risks, issues and alternative technical solutions discovered during project.

- Collaboration with a high-performing, forward-focused team, Release train engineer, Product Owner(s) and Business stakeholders.

- Ability to work on innovative and new projects with a "fail-fast" approach to provide optimal solutions that bring the most value to the business.

- Passion for learning new skills and the ability to adjust priorities on multiple projects based on changing demands/needs.



  • **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.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

 

Apply Now

Send me a reminder to complete this application

 

About Rose

  • Founded in 1993
  • Office Locations Across the U.S.
  • 150+ Clients: Corporations and Government Agencies
  • Employee Oriented Company
  • Challenging Assignments Across the U.S.
  • Continuous Professional Development

Rose International was not only attentive and responsive, but they were very professional and helpful whenever I called or needed any assistance.

Diane, Consultant

Rose is an assembly of people grounded in honesty, truth and dignity for all of its employees and contractors.

Samba, Consultant

Each time I contacted Rose, I was completely satisfied with the great attention and customer service I received. Each person was extremely knowledgeable and patient with my concerns or questions.

Diana, Consultant

You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!

Tonya, Consultant

Rose International maintained good communication during assignments and are very informative through email and phone calls.

Sade, Consultant

EMPLOYEE COMMENTS

  • We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.