Job Description
Company: Rose International
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 ($): 52.00
Max Hourly Rate ($): 60.00
Must Have Skills/Attributes: Data Engineer, ETL, Snowflake, SQL Server
Job Description
Open to the below locations:
– Hartford, CT
– Charlotte, NC
– Chicago, IL
– Frisco, TX
– Columbus, OH
– Danbury, CT
– Alpharetta, GA
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.