Business Systems Analyst

• We are seeking a Business System Analyst with strong expertise in data analysis, ETL processes, and system transformation initiatives.
• The ideal candidate will analyze existing data pipelines, document business logic, and support migration to modern data platforms while ensuring accuracy, traceability, and alignment with business requirements.

Responsibilities:

• Reverse engineer data workflows including control flows, data flows, stored procedures, views, configurations, and dependencies.
• Create source-to-target mapping documents with detailed field-level transformation logic and business rules.
• Translate existing data logic into modern data platform implementation guidance, including orchestration, incremental loads, error handling, and audit patterns.
• Document data lineage across multiple data environments.
• Collaborate with stakeholders to validate business rules and define acceptance criteria.
• Define reconciliation checks and develop test plans to ensure data accuracy and parity across systems.
• Support documentation of processes, lineage diagrams, and validation frameworks.

Requirement/Must Have:

• Advanced SQL skills including complex joins, CTEs, window functions, and performance optimization.
• Hands-on experience analyzing and documenting ETL packages and workflows.
• Proven ability to create detailed mapping and specification documents for development teams.
• Strong understanding of ETL concepts including incremental and full loads, data quality rules, deduplication, and error handling.

Should Have:

• Familiarity with modern data platforms and pipeline orchestration tools.
• Experience with cloud-based data warehousing solutions.
• Exposure to data governance and cataloging practices.
• Experience in insurance domain data processes.

Skills:

• Data analysis and system documentation.
• ETL design and transformation logic.
• SQL development and optimization.
• Data lineage and process mapping.
• Stakeholder communication and requirement gathering.

Qualification And Education:

• Bachelor s degree in Computer Science, Information Systems, or a related field.