Snowflake Data Engineer (Insurance Property & Casualty)

Saama (A Carlyle Portfolio Company) focuses on the specific needs of pharmaceutical & biotech companies, delivering transformative business outcomes. The combination of Saama’s AI research, advanced technical & analytics capabilities, domain expertise across the drug development & commercialization life cycle, and successful product co-development approach has made Saama a trusted partner and thought leader in the life sciences industry. If you possess a solutions mindset, strong management skills, and commitment to be part of a tremendous journey, join our growing, global team. See what Saama can do for your career and your journey.

Responsibilities:

Bachelors or Masters in IT, Computer, Software or related field.

7 years of Data Warehousing experience with 3 years of Snowflake concepts with implementation/hands-on experience

Experience in following best practices to maintain code versioning through GitHub, understanding of CI/CD

Strong SQL, PL\SQL skills

Experience/Understanding of Unix and python scripting

Good to have - Streamsets knowledge & Data Vault knowledge

Able to communicate well with client and understand requirements.

Strong P&C Insurance knowledge especially in Commercial Property, General Liability, Inland Marine, Product Liability, Auto and Umbrella BU's

Proficient and Prior experience in ELT\ETL tools is must

Participate in Design discussion with the Data modeler and architect team

Participate in Data Modelling sessions and develop Data Mapping specifications for the relevant processes

Prepare high level and detailed design documents for necessary processes

Design and develop the system components for the extract/transform or conversion of data from source systems to the target application(s)

Analyze the system capabilities and requirements through Storing and manipulating data inputs

Develop processes to handle Audit, Balancing, Reconciliation, and Error handling programs through the use of extract development tools or custom developed procedures

Identify components that require performance optimization and provide inputs for optimization of relevant jobs for optimal performance Analyze user needs and system requirements to determine feasibility of design within available constraints

Design and document jobs for the required scheduling tools

Perform internal design review and code review

Design and document data flow and explain to internal and external teams based on the need

Interact with client regularly, meet them to present work.

Having hands on experience or basic knowledge on Agile Scrum methodology

Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers.

Physical Demands

This position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EEO

Saama Technologies, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, and transfer, leaves of absence, compensation, and training.