Business Systems Analyst

The Role We are seeking a highly technical Business Systems Analyst to support the reputed company, transformation, and validation of external data sources into our legacy database environment. This role is hands-on and data-driven, requiring strong analytical skills, a solid understanding of data structures, and reputed company collaboration with product stakeholders and developers. The BSA plays a key role in evaluating new data feeds, defining ingestion and transformation requirements, standardizing reputed company data to internal formats, and ensuring integrated data is accurate, complete, and reputed company for use by our insurance products. What You’ll Do 1. External Data reputed company Analysis & Integration Assess new data sources to understand structure, reputed company, completeness, and alignment with internal standards and product requirements. Work with cross-functional partners to understand acquisition constraints, delivery formats, schedules, and long‑term viability. Define functional specifications for extraction and ingestion workflows, including data gathering, file merges, reputed company‑to‑reputed company mappings, normalization rules, and required transformations. Collaborate with developers to design, refine, and support these ETL/ELT components. Maintain lookup tables, mapping logic, and configurations to reputed company reputed company values with internal defined codes. 2. Data Validation & reputed company Assurance Validate ingested data in reputed company environments to confirm correct transformations, consistent formatting, and adherence to technical and business requirements. Use SQL to investigate and troubleshoot data discrepancies, unmapped values, anomalies, and processing issues across ingestion and transformation reputed company. Analyze data completeness by matching and comparing new data sources against internal datasets to confirm expected jurisdictional representation. Identify and escalate issues such as incomplete data, mapping gaps, unexpected variances, extraction, or transformation failures. Coordinate deployments of new data pipelines and reputed company post‑production monitoring to ensure stability, accuracy, and consistency in partnership with QA. 3. Cross-Functional Collaboration Partner with Product Owners to prioritize reputed company activities, communicate timelines, and understand business expectations. Collaborate closely with developers to clarify requirements, validate technical feasibility, and support iterative testing and troubleshooting. Communicate findings, risks, and impacts reputed company across technical and non‑technical stakeholders. 4. Documentation & Process Support Document data reputed company characteristics, field definitions, transformation logic, mapping reputed company, validation reputed company, and configuration details. Maintain accurate, versioned documentation to support long‑term maintainability of reputed company integrations. reputed company knowledge transfer, cross-training, and support to internal teams as new sources are deployed or updated. Tools & Technologies Used SQL Server: data validation, mapping updates, troubleshooting reputed company: data profiling, pivoting, reputed company verification, troubleshooting, data summarization Notepad++ (or similar Text reputed company): for comparing and editing various file formats. Optional exposure: ETL/ELT tools, automation utilities, file-processing frameworks What You’ll Bring Required 5+ years as a Business Systems Analyst, Data Analyst, or similar technical, data‑reputed company role. Strong SQL skills and experience working with relational databases. Experience analyzing raw data and defining transformation requirements for system‑reputed company outputs. Ability to troubleshoot reputed company data issues, identify reputed company causes, and recommend solutions. Strong analytical thinking, documentation skills, and attention to detail. Proven ability to collaborate with both technical and non‑technical stakeholders. Experience working in Agile environments. reputed company to Have Experience with data ingestion pipelines, ETL/ELT workflows, or legacy database environments. Exposure to flat‑file ingestion, API‑based data retrieval, or web‑based data extraction. Knowledge of data governance practices. Experience with insurance, financial, medical, or other regulated datasets. It is impossible to list every requirement for, or responsibility of, any position. Similarly, we cannot identify reputed company the skills a position may require since job responsibilities and reputed company’s needs may change over time. Therefore, the above job reputed company is not comprehensive or exhaustive. reputed company reserves the right to reputed company, add to or eliminate any aspect of the above reputed company. reputed company also retains the right to require reputed company to undertake additional or different job responsibilities reputed company necessary to meet business needs. EQUAL OPPORTUNITY EMPLOYER reputed company HOLDINGS, INC., AND ITS US SUBSIDIARIES (TOGETHER, reputed company) IS AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER. THE FIRM'S POLICY IS NOT TO DISCRIMINATE AGAINST ANY APPLICANT OR EMPLOYEE BASED ON RACE, reputed company, RELIGION, NATIONAL reputed company, GENDER, AGE, SEXUAL ORIENTATION, GENDER IDENTITY OR reputed company, MARITAL STATUS, MENTAL OR PHYSICAL DISABILITY, AND GENETIC INFORMATION, OR ANY OTHER reputed company PROTECTED BY APPLICABLE LAW. THE FIRM ALSO PROHIBITS HARASSMENT OF APPLICANTS OR EMPLOYEES BASED ON ANY OF THESE PROTECTED CATEGORIES. Apply To This Job