Job Details:

Job Title - Data Engineer

Job Location - Remote position (India)

Key Objectives/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 project(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

- Identifies 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

- Identify, manage, and document processes; review and coordinate testing, verify counts, and ensure accuracy

- Mentor and support team members on best practices





- Identify and incorporate automation into our existing and new processes

- Perform design review to ensure the solution will meet future growth and business requirements

- Work closely with BA, Architects, and QA Teams to execute unit testing, support integration testing, and regression testing for all business processes

- Create, configure, test, deploy, and maintain jobs for inbound and outbound processing

- Develop recent or improve the existing ETL solutions as the company & data grows

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-resolution process

- Self-motivated, team player with the ability to work and mentor junior resources in different regions

- Ability to work with the 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

📌 Data Engineer (Pune)
🏢 Fulcrum Digital
📍 Pune