Fulcrum Digital - Data Engineer

Data Scientist is needed in Pune City, India.

Client: Fulcrum Digital

Location: Pune City, MH, in

Contract: Freelance

Job Description

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 new or improve the existing ETL solutions as the company & data grows.

Requirements

• 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 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.

Additional Information

This position is fully remote and is aimed at candidates located in India.