Business Data Analyst

Hi, This is shipra and I’m a professional Recruiter with VLink. I saw your resume on one of the leading jobs portals and would like to discuss the below job details.VLink, founded in 2006, is a leading global provider of software engineering services with next-gen technologies and best-in-class talent. Our Headquarters are in the U.S, and we have offices in 7+ countries from North America-Europe to APAC, with expansion plans in the Middle East. With over 1,000 employees working globally, VLink has helped SMBs, and large enterprises achieve their business goals, and gained the trust of Fortune-250 companies. VLink is ‘Great Place to Work® Certified™' and has been a consistent winner as- Best Places to Work in CT. Trust, collaboration, and accountability are the three elements that are at the core of VLink’s work culture. We value our professionals, providing comprehensive benefits and the opportunity for growth. Job Title: Senior Systems Analyst/Data Analyst Location: NYC, NY/Hartford, CT/Hybrid role Employment Type: Contract Your future duties and responsibilities Discovery & Requirements . Partner with SMEs, ETL/engineering, QA, and operations, and use SQL daily to profile, reconcile, and prove outcomes. . Elicit conversion rules, edge cases, and data quality tolerances; define acceptance criteria. . Produce source-to-target mapping (S2T), code crosswalks, and transformation rules with examples. . Analysis & Specifications Write pseudo code for complex transformations; maintain data dictionaries and lineage. Define balancing logic (control totals, record counts, financial sums—premium, reserves, payments). . Validation & Reconciliation Must be proficient in authoring simple to complex SQL queries to profile data, locate anomalies, and validate field-level conversions. Build reconciliation queries (counts/sums by key), difference checks (source vs. target), and exception lists. . Testing & Readiness Define test scenarios/cases; support mock runs, triage defects, and track remediation. Prepare sign-off packs with evidence (SQL outputs, balancing sheets, variances with rationale). . Cutover Support Contribute to runbooks, rollback criteria, checkpoints, and post-cutover validation. Required qualifications to be successful in this role . 3–7+ years in insurance data conversions (policy admin and/or claims), with strong understanding of policy lifecycle, coverages, endorsements, losses/reserves, payments, and financial controls and Insurance claim system. . Advanced SQL (SQL Server preferred; Oracle welcome): complex joins, window functions, aggregations, set-based comparisons, performance-minded query design. . Proven experience delivering S2T mappings, pseudo code, and reconciliation/balancing artifacts for multiple mock conversions and go-live. . Hands-on data validation and UAT support; clear documentation and stakeholder communication. Warm Regards, Shipra Gupta Sr. Technical Recruiter