• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Nov 2020

• Strong experience in Data Analysis using Excel, SQL in support of Insurance Financial, Actuarial, Underwriting, Reinsurance related data reconciliation and reporting.
• Commercial insurance industry experience, both admitted and non-admitted business types.
• Expertise with insurance related data including Policy, Claims, and Financial data.
• Strong MS Excel experience (filtering; VLookup and Subtotalm SumIf functions; Pivot Tables; comparative analysis).
• Experience with querying tools such as Toad Data Point, SSMS, MS Query, or equivalent.
• Ability to determine mapping of front-end apps to back-end databases and creation of Source to Target mapping documentation.
• Ability to reverse engineer data content of source system databases with no/minimal documentation.
• Master Data Management: Ability to compose a Data Dictionary. Understand & Perform Data Profiling. Reference Data Management
• Conduct Data Quality reporting including completeness, validity, timeliness, uniqueness, accuracy, and consistency.
• Control check reporting including counts, totals, and ITD, YTD, Period to Date vs previous period with various groupings such as company, division, business unit, product, etc.
• Ability to write data analysis queries in SQL, for reporting, reconciliations while applying required data Transformations top match across disparate data sets.
• Experienced in mapping data from source systems to a common data model.
• Experience working with various database schemas including 3NF, Star, and HUB.
• Experienced with Agile Development methodology.
• Ability to work with minimal or no supervision and directly liaise with Financial, Actuarial, Underwriting, Reinsurance & Operations staff.

Nice to Have skills:

• Actuarial &/or Insurance Finance experience.

• Data Visualization including Excel Charts; Graphing; Power BI, QlikView and/or Tableau.
• Snowflake Cloud Warehouse.
• Informatica.