Senior Staff Data Engineer

6 days ago


Danbury, United States The Hartford Full time

Sr Staff Data Engineer - GE07DE 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. 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 platform. 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 role will have a Hybrid work arrangement, with the expectation of working in an office location (Hartford, CT; Danbury, CT; Charlotte, NC; Chicago, IL; Frisco, TX; Columbus, OH, Danbury, CT, Alpharetta, GA) 3 days a week (Tuesday through Thursday). Candidates must be authorized to work in the US without company sponsorship. This role will have a Hybrid work arrangement, with the expectation of working in an office location (Hartford, CT; Chicago, IL; Columbus, OH; and Charlotte, NC) 3 days a week (Tuesday through Thursday). Role Description: 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 Datawarehouse 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 Datawarehouse. 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. I dentify, 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. Qualifications & Key Skills: Candidates 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. 5+ years in Snowflake in AWS and Talend Data Integrator. 7+ years of hands-on experience in Datawarehouse 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. Compensation The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is: $132,400 - $198,600 Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age About Us (https://www.thehartford.com/about-us) | Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) | Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) | Benefits (https://www.thehartford.com/careers/benefits) Human achievement is at the heart of what we do. We believe that with the right encouragement and support, people are capable of achieving amazing things. We put our belief into action by ensuring individuals and businesses are well protected, and by going even further – making an impact in ways that go beyond an insurance policy. Nearly 19,000 employees use their unique talents in careers that span a variety of disciplines – from developing the latest technology to creating and promoting our products to evaluating future financial risks. We’re also committed to programs that drive education and support volunteerism, which put human beings first. We do it because it’s the right thing to do, and because when our customers, communities and employees succeed, we all do. About Us (https://www.thehartford.com/about-us) Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) Benefits (https://www.thehartford.com/careers/benefits) Legal Notice (https://www.thehartford.com/legal-notice) Accessibility StatementProducer Compensation (https://www.thehartford.com/producer-compensation) EEO Privacy Policy (https://www.thehartford.com/online-privacy-policy) California Privacy Policy Your California Privacy Choices (https://www.thehartford.com/data-privacy-opt-out-form) International Privacy Policy Canadian Privacy Policy (https://www.thehartford.com/canadian-privacy-policy) Unincorporated Areas of LA County, CA (Applicant Information)



  • DANBURY, CT, United States The Hartford Financial Services Group Full time

    Sr Staff Data Engineer - GE07DEWe’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.   The Enterprise Data Services...


  • Danbury, Connecticut, United States Genpact Full time

    Job OverviewWe are seeking a highly skilled CPM Business Analyst Lead to join our team at Genpact. As a key member of our organization, you will play a crucial role in establishing and maintaining patient data assets and principles across the enterprise.In this position, you will serve as a subject matter expert on patient data operations, quality, and...


  • Danbury, United States Owl Cyber Defense Full time

    Job Title:Senior Embedded Software EngineerDepartment:Advanced DevelopmentReports to:Senior Manager, Advanced DevelopmentOwl Cyber Defense is a leader and trusted partner in cyber security. We deliver solutions that protect and connect the world’s most critical networks. Owl’s product lines of cross domain, data diode, and portable media solutions...


  • Danbury, United States SES Government Solutions Full time

    Job ID:111226 The Leonardo DRS Naval Power Systems business is a trusted provider of innovative naval gas and hybrid power systems, control technology and support solutions for the U.S. Navy and navies around the world. Naval Power Systems' commitment to and investment in our people, products, and customers is the foundation of who we are. We offer a...


  • Danbury, Connecticut, United States SES Government Solutions Full time

    We are seeking a highly skilled Senior Power BI Data Analyst to join our team at SES Government Solutions.About the CompanySes Government Solutions is a trusted provider of innovative naval gas and hybrid power systems, control technology, and support solutions for the U.S. Navy and navies around the world.Job SummaryThis is an excellent opportunity for an...


  • Danbury, Connecticut, United States Nuvance Health Full time

    Nuvance Health Data Engineer II RoleThe Technical Data Analyst Lead will work closely with cross-functional teams to set and establish data reporting standards, tools, and content aligned with the strategic needs of Nuvance Health. This role requires collaboration with end-users throughout the organization to determine information and data...

  • Data Engineer II

    6 days ago


    Danbury, United States Nuvance Health Full time

    Description REMOTE OPPORTUNITY Summary: The Data Engineer II role is responsible for the technical implementation of the reporting and analytic tools across Nuvance Health. The work of this team will be to set & establish data reporting standards, tools, and content aligned with the strategic needs of the company. This position will be responsible for the...


  • Danbury, Connecticut, United States City of Danbury, CT Full time

    Senior Engineering Role**Job Description:**We are seeking an experienced Senior Engineer to join our Public Works Department at the City of Danbury, CT. As a Senior Engineer, you will be responsible for leading the design, development, and implementation of public works projects, including streets, sidewalks, bridges, and water mains.**Key...


  • Danbury, United States Arka Service Full time

    We are immediately hiring for the exciting position of a Senior Component Engineer! The Senior Component Engineer provides expertise in High Reliability, Military and Space Level EEE Component Engineering. Specific Responsibilities: Plan, define and implement component engineering requirements to ensure design integrity and hardware robustness. Execute...


  • Danbury, United States SES Government Solutions Full time

    Job ID:109972 The Leonardo DRS Naval Power Systems business is a trusted provider of innovative naval gas and hybrid power systems, control technology and support solutions for the U.S. Navy and navies around the world. Naval Power Systems' commitment to and investment in our people, products, and customers is the foundation of who we are. We offer a...


  • Danbury, Connecticut, United States Genpact Full time

    Job SummaryGenpact is seeking a seasoned Senior Manager, Patient Data Steward to lead our patient data governance efforts. This is a critical role that requires expertise in patient data operations, quality, and implementation of data governance.The successful candidate will have experience in pharmaceutical or healthcare industries, specifically in patient...


  • Danbury, Connecticut, United States FuelCell Energy Full time

    FuelCell Energy, a leader in decarbonizing power and producing hydrogen through proprietary fuel cell technology, seeks a Senior Mechanical Engineer to join its innovative team. Located in Danbury, Connecticut, this role offers a competitive salary range of $123,448 - $135,000.Job Description:The successful candidate will lead technical discussions and...


  • Danbury, United States Leonardo DRS, Inc. Full time

    Leonardo DRS, Inc. Senior Test Engineer Danbury , Connecticut Apply Now The Leonardo DRS Naval Power Systems business is a trusted provider of innovative naval gas and hybrid power systems, control technology and support solutions for the U.S. Navy and navies around the world.Job SummaryJoin our team as a Senior Test Engineer in Danbury, CT! The...


  • Danbury, Connecticut, United States Genpact Full time

    As a Senior Manager, Master Data Management, you will play a critical role in shaping the future of professional services and solutions at Genpact. Our employees across 30+ countries are driven by their innate curiosity, entrepreneurial agility, and desire to create lasting value for clients.In this position, you will be responsible for all activities...


  • Danbury, Connecticut, United States Arka Service Full time

    About the CompanyArka Service is a leading provider of innovative solutions in the field of electrical engineering. Our team is committed to delivering high-quality products and services that meet the needs of our clients. We are proud to offer a dynamic and supportive work environment, where talented individuals can grow and develop their skills.In this...


  • Danbury, United States Arka Service Full time

    Position Overview: As a Senior Systems Engineer you will work in a team-based environment to develop Electro-Optical (EO) systems that operate in space environments. Depending on the complexity of the program a Senior Systems Engineer will be expected to work Chief Systems Engineers to manage requirements, provide technical oversight for internal and...


  • Danbury, Connecticut, United States Arka Service Full time

    About the RoleWe are seeking a highly skilled Senior Systems Engineer to join our team at Arka Service. As a key member of our engineering team, you will be responsible for developing and integrating electro-optical systems for space environments.The successful candidate will have a strong background in systems engineering, with experience in requirements...


  • Danbury, United States Hire Talent Full time

    Description: PAY RATE: $55-80 per hour SHIFT: 7am 4pm WORKSITE: Danbury (onsite only) INTERVIEW PROCESS: First round - Teams meeting / Second round - Onsite DURATION: One year with possible extension or conversion to FTE (based on business need, budget approval and performance) Summary of Duties and Responsibilities: - Create and execute validation plans,...


  • Danbury, Connecticut, United States Arka Service Full time

    About the RoleWe are seeking a highly skilled Senior Optical Engineer to join our team at Arka Service. As a key member of our optical engineering department, you will play a critical role in supporting the design, analysis, fabrication, metrology, and testing of airborne and space-based optical systems.With your expertise in optics and aerospace...


  • Danbury, Connecticut, United States Amphenol RF Full time

    Amphenol RF is a world leader in the manufacture of coaxial interconnect products, and we're seeking a Senior Mechanical Design Engineer to join our team.As a key member of our design team, you will be responsible for designing connector components and assemblies using 3D CAD software, performing tolerance studies, and applying RF design concepts.Our ideal...