Sr Data Engineer (W2)

Job Title: Sr Data Engineer

Location: Hartford , CT (Hybrid)

Contract: 6+ months Contract to Hire

Job Description

• Mix of lead and developer role - Kanban teams, scrum teams this candidate is expected to go into scrum teams and guide teams on delivery as primary objective. Also expecting to do hands on coding 50% of the time
• 5-8 years of lead experience
• This person makes sure delivery goes as smoothly as possible
• DevOps knowledge
• Maintenance team- Business Insurance
• Senior Data Engineer working with Data Engineer, QAs
• New products, maintenance on existing
• Moved from talend to IDMC
• Industry experience is nice to have (insurance)
• Informatica
• Right now, it is legacy tech stack but they are building datahub on the cloud and hope to migrate to cloud fully in the future

Job Description:

Join a fast-paced and talented Agile/Kanban team to unlock Data Capabilities for Insurance's Business Insurance Production Support and Maintenance organization. You will have an opportunity to maintain Legacy data assets using OraclePosition 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 d 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.
ata 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.
Role Expectations:
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
Qualifications:
Bachelor's degree with at least 5 or more years of applicable work experience with respect to Data Analysis, manipulation, and technical development
Desired educational experience includes, but are not limited to: Computer Science, Engineering, IT, Management Information Systems, Data Analytics, Applied Mathematics, and Business.
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.