Data Engineer

Key Responsibilities: A strong understanding of common data integration challenges within the insurance industry, as well as the best-practice technical approaches & solutions available through data integration, data warehouse, and data lake technologies Ability to lead by example, having worked as a technical build resource Experience in how technology solutions can enable business transformation Incorporate and implement ETL/ELT best practices within the group Identify and recommend new ETL/ELT features/tools and design and develop the optimal solution to address business requirements Responsible for the development and maintenance of CAESAR (i.e. EDW) ETL/ELT Processes Translate functional requirements into technical specifications and solutions Perform ad hoc analysis using SQL to extract data sets Research innovative technologies and provide ideas for technological or workflow/process improvements Identify opportunities to re-engineer existing solutions to utilize technology better, optimize performance, and simplify support Analyze current processes to determine or update Key Performance Metrics Requirements Qualifications/Skills: Experience with Snowflake, DBT - 1 to 2 years - Required Experience with SSIS, SQL Server, SQL, relational database, etc. - 1 to 3 years - Required Knowledge of the Property and casualty Insurance industry is a plus Ability to recognize past issue patterns and apply them to the existing problem-resolutionprocess Self-motivated team player with the ability to work with and mentor junior resources across different regions. Ability to work with other groups and lead the ETL solution Excellent analytical, problem-solving, written, and oral communication skills Experience with Azure - 0-2 years - good to have Comfortable working with complex ETL solutions and large data sets Organized with strong written and Verbal communication skills Familiar with Jira, Confluence, and Agile Processes