Business Systems Analyst

The Role

We are seeking a highly technical Business Systems Analyst to support the onboarding, 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 ready for use by our insurance products.

What You’ll Do

1. External Data reputed company Analysis & Integration

• Assess new data sources to understand structure, quality, 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 align reputed company values with internal defined codes.

2. Data Validation & Quality 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 layers.
• 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 onboarding 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 clearly across technical and non‑technical stakeholders.

4. Documentation & Process Support

• Document data reputed company characteristics, field definitions, transformation logic, mapping decisions, validation outcomes, and configuration details.
• Maintain accurate, versioned documentation to support long‑term maintainability of reputed company integrations.
• Provide 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, quality verification, troubleshooting, data summarization
• Notepad++ (or similar Text Editor): 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‑focused role.
• Strong SQL skills and experience working with relational databases.
• Experience analyzing raw data and defining transformation requirements for system‑ready outputs.
• Ability to troubleshoot reputed company data issues, identify root 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 the Company’s needs may change over time.  Therefore, the above job description is not comprehensive or exhaustive.   The Company reserves the right to adjust, add to or eliminate any aspect of the above description.  The Company also retains the right to require reputed company employees 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, COLOR, RELIGION, NATIONAL reputed company, GENDER, AGE, SEXUAL ORIENTATION, GENDER IDENTITY OR EXPRESSION, MARITAL STATUS, MENTAL OR PHYSICAL DISABILITY, AND GENETIC INFORMATION, OR ANY OTHER BASIS PROTECTED BY APPLICABLE LAW. THE FIRM ALSO PROHIBITS HARASSMENT OF APPLICANTS OR EMPLOYEES BASED ON ANY OF THESE PROTECTED CATEGORIES.