Data Engineer

Job Description 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 new 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 Requirements Who are we Fulcrum Digital is an agile and next-generation digital accelerating company providing digital transformation and technology services right from ideation to implementation. We specialise in delivering complex digital commerce ecosystems to large and small customers through a team-oriented and collaborative work environment. These services have applicability across a variety of industries, including banking & financial services, insurance, retail, higher education, food, health care, and manufacturing. Job Summary Reports on a day-to-day basis to the Solution architect. The individual in this role will act as an integration developer and will have a broad understanding of .NET technology with a focus on technology stacks including those involving CRM solutions, online content servers, and online & mobile web applications. The developer will be involved in integrating and implementing solutions, including legacy platform modernization, through the project life cycle and ongoing support. This position will focus on translating applications from legacy solutions to web-based solutions using web framework and technology. Requirements • Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.

Master’s Degree preferred. • At least 4 years’ experience in developing and consuming RESTful APIs. • At least 5 years’ experience in Service Oriented Architecture/Service integration with Web Services, REST and security integration. Skills / Experience / Responsibilities • Design, develop and implement complex solutions based on Microsoft .NET Framework 4.5+ using C#, ASP.NET and ADO.Net. • Will work with internal stakeholders to learn the business processes, operating systems, and application architectures in order to ensure that solutions fit the current or proposed architectural environment. • Translate applications requirements into web-based solutions using the recommended frameworks and technology. • Design and develop reusable components, accelerators and frameworks. • Assist in the system integration of components. • Implement Test Driven Development frameworks (NUnit, xUnit, etc.). • Implement Design Pattern (Singleton, Factory and ASP.NET MVC). • Implement Data Structures. • Assist in translating customer service, marketing & financial business function needs into digitization and automation of technical solutions aligned with organizational goals and strategies. • Be a strong team player and effectively participate in projects and daily operational activities