Senior Staff Data Engineer - Hybrid

Senior Staff Data Engineer - Hybrid The Hartford 4.5 ( ) Columbus, OH Why you should apply for a job to

The Hartford :

Ranked as one of the 4.5/5 in overall job satisfaction 4.5/5 in supportive management 76% say women are treated fairly and equally to men 87% would recommend this company to other women 90% say the CEO supports gender diversity Ratings are based on anonymous reviews by Fairygodboss members. See all reviews The Professional Women's Network (PWN) provides professional support, growth, advancement and networking to enable greater gender balance. The Hartford offers diversity awareness training known as Appreciating Differences and Managing Inclusion. Employees will be provided with leave of up to four weeks and paid at a rate of 100 percent of their base pay. # 4305 Position summary e 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 Technical leadership and expertise in Snowflake's cloud native architecture. 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. Integration of data pipelines with source control repository and build CI/CD pipeline and DevOps. Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design. 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.

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 data warehousing, data pipelines and automation. 5+ years of hands-on experience in Datawarehouse and Data Integration(ELT/ETL) 3 + years in Cloud Data modernization (Ingestion, Curation, Data Domains, Data Products). Experience working with Data Lakes loading disparate data sources- Structured, semi-structured data (Flat files, XML, JSON, Parquet) and unstructured data. Ability to create, troubleshoot, enhance complex code in Snowflake Data Lakes/Data hubs/data warehouses. Experience in building data pipelines using cloud native ELT tools and automation of data ingestion including change data capture (CDC). Hands on experience with Snow SQL, Stored Procedures, UDF's using JavaScript, SnowPipe and other snowflake utilities. Experience with Data Governance (Catalog, Quality, Lineage). Strong data warehouse applications knowledge in preferably in financial/insurance domain is required. Experience with 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.

Preferred Qualification and Skills:

SnowPro Core certified. AI Certifications Implementing AI data pipelines that bring together structured, semi-structured and unstructured data to support AI and Agentic solutions. This Includes pre-processing with extraction, chunking, embedding and grounding strategies to get the data ready. Hands-on experience with Data Visualization (preferably Tableau). Experience in the Insurance industry. Experience with Artificial Intelligence. Experience with Informatica Data management cloud. 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: $135,040 - $202,560 Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age Why you should apply for a job to

The Hartford :

Ranked as one of the 4.5/5 in overall job satisfaction 4.5/5 in supportive management 76% say women are treated fairly and equally to men 87% would recommend this company to other women 90% say the CEO supports gender diversity Ratings are based on anonymous reviews by Fairygodboss members. See all reviews The Professional Women's Network (PWN) provides professional support, growth, advancement and networking to enable greater gender balance. The Hartford offers diversity awareness training known as Appreciating Differences and Managing Inclusion. Employees will be provided with leave of up to four weeks and paid at a rate of 100 percent of their base pay.