Insurance ETL Functional Business Analyst Hybrid

Cognizant
US - North Carolina - Charlotte
July 2, 2024

We are Cognizant Artificial Intelligence

Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them.

With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate and scale the most desirable products and delivery models to enterprise scale within weeks.

You must be legally authorized to work in United States.

This is an onsite position open to any qualified applicant in the United States.

This role will remain posted until 06/20/2024.

Job Title: Technical Lead: Snowflake Insurance Business Analyst

Experience: 8-12 years

Must Have Skills: Functionsl Business Analyst, Insurance Domain, Snowflake, JSON, ANSI SQL

Mandatory skill set required: Thorough knowledge of Commercial Insurance domain across a variety of lines of business. Additional industry knowledge of delegated underwriting and third-party claims data is a bonus.

Job Summary:
• We are seeking a seasoned Sr. Business Analyst with a strong background in Property & Casualty Insurance.
• The ideal candidate will have a deep understanding of business analysis, data analytics, and technical skills in ANSI SQL, Snowflake, and JSON.
• With a minimum of 10 years and a maximum of 14 years of experience, this role is pivotal in driving our strategic initiatives and enhancing our market position.
• Required Skills: Technical Skills: Domain Skills: Property & Casualty Insurance
• Nice to have skills: Technical Skills: ANSI SQL, Snowflake, JSON Domain Skills:
• Technology: Cloud DW development

Roles & Responsibilities: -

Ø Support in developing requirements related to Source-to-Target Mappings, Data Templates, Data Transformations, and Business Validations, as well as support in explaining these requirements to the Data Ingestion Framework development teams (including Adeptia,, Application delivery and Data Engineering)
• Work with business and other stakeholders to identify additional data needs for the prioritized lines of business.
• Enhance the functional data template with key metadata for the additional data elements e.g. field name, description, data type, Optionality, etc.
• Work with data architecture team on the modelling of data elements in the target JSON structure.
• Work with Adeptia on the ingestion of the revised target JSON template.
• Educate and work with business to perform source to target mapping for the new attributes.
• Define data validation rules and data exception messages.
• Provide data transformation logic to curation services - document specifications as well as overview sessions etc.
• Define sample data to support with the build and testing.
• Provide support during testing - triage of errors, root cause analysis and remediation action (where necessary)
• Define and execute test scenarios during UAT.
• Assist the product owner with the creation and review of business requirements, process documentation, preparation of material for status updates, tracking the progress of the project against the plan etc.
• Prepare operating manual/run book for the productional rollout.

Ø Other Third-Party Data Ingestion Requirements (as capacity allows): Support in requirements development of up to one additional use case (e.g. TPA Claims) as capacity allows above-and-beyond North America Policy Bordereau requirements.

Salary and Other Compensation:

The annual salary for this position is $110,000-$135,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

Medical/Dental/Vision/Life Insurance

Paid holidays plus Paid Time Off

401(k) plan and contributions

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Read the full job description and apply online on the recuiter's web-site

Related Job Postings

Sr. HVAC Technician

Trane Technologies

United States - NC - NC - Charlotte
June 28, 2024

At Trane Technologies™ and through our businesses including Trane® and Thermo King®, we create innovative climate solutions for buildings, homes, and transportation that challenge what's possible for a sustainable world. We're a team that dares to look at the world's challenges and see impactful...

Find Jobs Hiring Now Near You!

Get Jobilize Job Search Mobile App Now