Talent.com
Business Systems Analyst (SQL) (Hybrid)

Business Systems Analyst (SQL) (Hybrid)

Serigor IncPhiladelphia, PA, United States
1 day ago
Job type
  • Full-time
Job description

Job Title : Business Systems Analyst (SQL) (Hybrid)

Location : Philadelphia, PA

Duration : 12 Months

Overview :

This is a BSA position - onsite 3x / week required. Candidate must be in the tri-state area (PA, NJ, DE) prior to assignment start.

The Business System Analyst role on the EIM - Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents and further discussion with data modelers for the necessary table designs.

Job Summary :

This position is ideal for a SQL Business Systems Analyst with strong SQL skills and a deep understanding of data warehousing concepts. The SQL Business Systems Analyst role on the Enterprise Integration Management (EIM) - Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of mapping documents, and further discussion with data modelers for the necessary table designs.

The ideal candidate should have all of the above skills at an expert level, along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements, and translate the same to the technical team.

Other preferred experience includes Source-to-Target mapping, health insurance knowledge, and general data warehousing. The candidate will also be comfortable supporting testing, production readiness verification, and ensuring accuracy after deployments. This might include weekend and off-hours support. Candidates should be local to the office or willing to relocate to Philadelphia or the surrounding area prior to starting.

Responsibilities :

  • Work with external vendors and internal business stakeholders in a variety of interactions including but not limited to issue resolution, requirements gathering, and ensuring efficient communication workflows.
  • Regularly create Business Requirement Documents (BRD), Functional Requirement Documents, User Test Documents, and training / reference documentation.
  • Confidently work with users and stakeholders to conduct interviews and gather thorough requirements.
  • Recurrently execute the following SQL functions at an expert level including SQL joins, writing complex SQL queries, and SQL clauses including WHERE and GROUP BY.
  • Create SQL rankings and partitions.
  • Perform SQL data filtering and data aggregation.
  • Use SQL to retrieve, manipulate, or analyze data from databases.
  • Frequently perform data profiling activities including column analysis, data quality assessments, relationship discovery, and data distribution analysis to gain insights into the data in order to make informed decisions about how to manage, clean, transform, and use the data effectively.
  • Execute data gap analysis to identify disparities or discrepancies in data quality, completeness, consistency, or relevance between the current state of data and the desired state.
  • Collaborate on activities associated with User Acceptance Testing (UAT) and Data Validation.
  • Perform data management functions including Change Data Capture (CDC) to capture and track changes made to data in a database or data warehouse.
  • Execute standard Data Quality activities including data deduplication and Data Referential Integrity.

Skill / Experience / Education

Mandatory :

  • Strong Data Profiling and Analysis skills
  • Strong SQL knowledge
  • Strong Data Mapping and Functional Requirements Documentation skills
  • Strong verbal, writing, and active listening skills
  • Desired :

  • Data warehousing knowledge
  • Healthcare experience
  • Highly Preferred :

  • Knowledge of Healthcare Claims, Client Setup, and Premium Billing
  • Deep understanding of Business Analysis concepts and successful application of standard methodologies.
  • Expert SQL analysis and SQL development skills.
  • Preferred Additional Experience :

  • Source-to-Target mapping
  • Comfortable supporting testing, production readiness verification, and ensuring accuracy after deployments (including weekend and off-hours support)
  • Create a job alert for this search

    System Analyst • Philadelphia, PA, United States

    Related jobs
    • Promoted
    Business Systems Analyst

    Business Systems Analyst

    Highmark HealthTrenton, NJ, United States
    Full-time
    This job supports one or more analytical aspects of the application product life cycle, within a sub-product scope (one or more application components). Uses regular judgement and discretion to coll...Show moreLast updated: 1 day ago
    • Promoted
    Business Systems Analyst

    Business Systems Analyst

    New Jersey StaffingTrenton, NJ, United States
    Full-time
    This job supports one or more analytical aspects of the application product life cycle, within a sub-product scope (one or more application components). Uses regular judgement and discretion to coll...Show moreLast updated: 1 day ago
    Hybrid Hiring : Business Systems Analyst || Princeton Pike or Summit, NJ

    Hybrid Hiring : Business Systems Analyst || Princeton Pike or Summit, NJ

    Sunrise SystemsPrinceton, New Jersey, United States
    Temporary
    Quick Apply
    Job Title : Business Systems Analyst.Duration : 12 Month Contract (Possible extension based on work performance).Location : Princeton Pike or Summit, NJ. SAP analyst with some IT Background.Experience ...Show moreLast updated: 30+ days ago
    • Promoted
    IT Senior Business Systems Analyst - Oracle

    IT Senior Business Systems Analyst - Oracle

    ULPrinceton, NJ, United States
    Full-time
    The IT Senior Business Systems Analyst is responsible for maintaining and optimizing UL Solution's Salesforce and Oracle platforms by managing user accounts, configuring features, performing releas...Show moreLast updated: 1 day ago
    • Promoted
    Business Systems Analyst (Finance & IT)

    Business Systems Analyst (Finance & IT)

    JobotSouth Brunswick Twp, NJ, United States
    Full-time
    We're hiring a Business Systems Analyst - Finance to join a stable and growing organization with significant opportunities for career advancement. As the bridge between IT and Finance, you'll lead t...Show moreLast updated: 30+ days ago
    • Promoted
    Business system Analyst

    Business system Analyst

    Staffing the UniversePennington, NJ, United States
    Full-time
    Job Authorization : US Citizen / GC / EAD (H4 / L2 / TN) preferred.Business Analyst experience needed.Lead the for Reporting Requirements, documentation / assist PM. Provides Technical guidance to j.Show moreLast updated: 1 day ago
    • Promoted
    Maximo Business Systems Analyst

    Maximo Business Systems Analyst

    Macpower Digital Assets EdgeFolsom, NJ, United States
    Temporary
    The client is in need of a Business System Analyst for the IBM Maximo Application.They are looking for a technical resource to support the Enterprise work asset management system where uses the Max...Show moreLast updated: 1 day ago
    • Promoted
    Business System Analyst

    Business System Analyst

    TWO95 InternationalEwing Twp, NJ, United States
    Temporary
    Explain the system architecture, experienced with APIs design, documentation and data analysis.Explaining the system architecture at least at high level is a differentiator between BA and BSA.Someo...Show moreLast updated: 1 day ago
    • Promoted
    Business system Analyst - Pennington NJ

    Business system Analyst - Pennington NJ

    Staffing the UniversePennington, NJ, United States
    Full-time
    US Citizen and Green Card only No Third Party Requirements Lead the for Reporting Requirements, documentation / assist PM Provides Technical guidance to java FullStack developers Responsible for Tes...Show moreLast updated: 1 day ago
    • Promoted
    Business Systems Analyst III- AWS Data Analyst

    Business Systems Analyst III- AWS Data Analyst

    EquiliemPrinceton, NJ, United States
    Full-time
    This client is located in central NJ.The candidate must be local and willing to go into the office 2 - 3 days a week.Client is seeking an AWS Data Analyst to collecting, cleaning, and interpreting ...Show moreLast updated: 1 day ago
    • Promoted
    Sr Business Systems Analyst

    Sr Business Systems Analyst

    Insight GlobalNewtown, PA, United States
    Full-time
    A health insurance client is hiring for a Business Systems Analyst to join their Enterprise Automation & workflow team.This team is responsible for the design and delivery of automation technology ...Show moreLast updated: 1 day ago
    • Promoted
    Senior Business Systems Analyst, Finance Systems

    Senior Business Systems Analyst, Finance Systems

    New Jersey StaffingTrenton, NJ, United States
    Full-time
    Business Systems Analyst (BSA).What does that mean? It means we are a serious company that doesn't take itself too seriously. and we're looking for people who love to get stuff done, and laugh a bi...Show moreLast updated: 1 day ago
    • Promoted
    Senior Business Systems Analyst

    Senior Business Systems Analyst

    Highmark HealthTrenton, NJ, United States
    Full-time
    This job is for someone who has a background in the Health Insurance industry, specifically regarding Provider Network data and pricing methodologies (including procedure codes and fee schedules).T...Show moreLast updated: 1 day ago
    • Promoted
    Business System Analyst

    Business System Analyst

    Diverse LynxPrinceton, NJ, United States
    Full-time
    Business System Analyst with AML & Data Engineering - Banking Domain experience.Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration ...Show moreLast updated: 1 day ago
    • Promoted
    Business Systems Analyst

    Business Systems Analyst

    Old Republic Specialty Insurance GroupYardley, PA, US
    Full-time
    VP, Business Solutions Manager.Old Republic Specialty Insurance Underwriters (ORSIU).Yardley, PA / Hybrid, 3 days in-office or Remote. Old Republic is a leading specialty insurer that operates diverse...Show moreLast updated: 30+ days ago
    • Promoted
    Business Systems Analyst (Kyriba)

    Business Systems Analyst (Kyriba)

    Eliassen GroupTrenton, NJ, United States
    Full-time
    Business Systems Analyst (Kyriba).We are seeking a detail-oriented and technically proficient.Business Systems Analyst (BSA). Kyriba treasury management platform.This role will collaborate with inte...Show moreLast updated: 1 day ago
    • Promoted
    Senior Business Systems Analyst - HNAS

    Senior Business Systems Analyst - HNAS

    Highmark HealthTrenton, NJ, United States
    Full-time
    HNAS (Health Now Administrative Services) offers flexible, cost-effective solutions for employee health benefits.HNAS is part of Highmark Health, a national blended health organization with a missi...Show moreLast updated: 1 day ago
    • Promoted
    Data Business Systems Analyst

    Data Business Systems Analyst

    Insight GlobalNewtown, PA, United States
    Full-time
    A healthcare insurance company's Enterprise Data Office is hiring for a Data / Business Systems Analyst with strong techno functional experience to lead data initiatives. The ideal candidate will hav...Show moreLast updated: 1 day ago