Business System Analyst

3 weeks ago


Philadelphia, United States Serigor Inc. Full time
Job DescriptionJob Description

Job Title: Business System Analyst

Location: Hybrid Philadelphia, PA

Duration: 6 months

Overview:

Our client a national health care insurance company is looking for a Business Systems Analyst with strong SQL skills and deep understanding of data warehousing concepts. The Business Systems Analyst (SQL) role on the Enterprise Integration Management 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. The ideal candidate is a skilled communicator and problem-solver with a solid technical foundation in SQL and data analysis, coupled with a deep understanding of business requirements and data warehousing

This position is an ONSITE HYBRID role located in Center City Philadelphia and is Contract-to-hire with an anticipated conversion after 6 months.


There are SEVERAL openings for this role

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 (BDR), User Test Documents, and Training and 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, 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 to 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

  • Highly prefer candidates with knowledge of Healthcare Claims, Client Setup and Premium Billing
  • Deep understanding of Business Analysis concepts and successful application of standard methodologies
  • Strong Data Profiling and Data Analysis skills
  • Expert SQL analysis and SQL development skills
  • Strong Data Mapping and Functional requirements documentation skills
  • Data warehousing knowledge and understanding of standards and concepts
  • Strong verbal, writing and active listening skills.

Preferred Additional Experience:

  • Source-to-Target mapping,
  • comfortable supporting testing, production readiness verification and ensuring accuracy after the deployments.
  • This position may include weekend and off hours support.



  • Philadelphia, United States IntePros Full time

    IntePros is seeking a Business Systems Analyst for one of our client's, a leader in the health insurance industry here in the Greater Philadelphia market place. This role does have onsite requirements in Philadelphia, PA.Looking for a Business Systems Analyst that is very confident and can communicate with an executive level audience. The best candidate will...


  • Philadelphia, Pennsylvania, United States CyberTec Full time

    # Business Systems Analyst - Citizen Only - 3 OpeningsCyberTec Location: Hybrid Work Environment Duration: 12+ months VISA:Citizen Only NO: OPT, H4, GC, H1 Essential Qualifications: Experience in Group Life Insurance Proficiency in SQL/Data Analysis Familiarity with MS Office Suite - including diagramming tools Preference for candidates with a strong...


  • Philadelphia, Pennsylvania, United States IntePros Full time

    **Candidates must be local to Philadelphia, PA for a hybrid work arrangement**Business Systems Analyst Overview:IntePros is in search of a meticulous and proficient Business Systems Analyst to become a vital member of our innovative team. The selected individual will collaborate closely with business units, project leaders, and external consultants to...


  • Philadelphia, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Business Systems AnalystLocation: Hybrid - Philadelphia, PADuration: 6 months CTHOverview:Our health insurance client is looking for a Business System Analyst as part of the Application Development Team for a 6 month long contract with conversion to full time possible.This position is hybrid position onsite in...


  • Philadelphia, United States IntePros Full time

    Job Description:We are seeking a highly motivated and detail-oriented Business Analyst specializing in Billing Systems Support to join our team. In this role, you will collaborate with multiple stakeholders and teams to ensure the smooth operation of our billing systems. The ideal candidate will have experience with ETL processes and analytic tools to...


  • Philadelphia, Pennsylvania, United States Twenty Bridge Staffing Full time

    Job Description**Job Title:** Business System Analyst**Job Summary:** We are seeking a highly skilled Business System Analyst to join our team at Twenty Bridge Staffing. The ideal candidate will have extensive experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL...


  • Philadelphia, Pennsylvania, United States Twenty Bridge Staffing Full time

    Business Systems AnalystLocation RequirementCandidate must be located in proximity to Philadelphia, PA.Position OverviewTwenty Bridge Staffing is in search of a Business Systems Analyst to assist our client in Philadelphia, PA.This role offers a hybrid work arrangement.Key ResponsibilitiesEngage with various stakeholders, including billing, finance, and...


  • Philadelphia, Pennsylvania, United States Twenty Bridge Staffing Full time

    Business Systems AnalystLocation RequirementCandidate must be located in the vicinity of Philadelphia, PA.Position OverviewTwenty Bridge Staffing is in search of a Business Systems Analyst to provide support for our client operations.This role offers a hybrid work environment.Key ResponsibilitiesEngage with various stakeholders, including finance, billing,...


  • Philadelphia, United States Innovative Systems Group Full time

    We are NOT able to consider c2c for this position.This position is a 5 month contract position with our direct client (Possible extensions). This position is hybrid and requires being in the office Tuesday, Wednesday, and Thursday. Gathering and documenting business requirements for new systems or system enhancements.Analyzing existing business processes and...


  • Philadelphia, United States Insight Global Full time

    Title: Business System AnalystLocation: Hybrid in Center City, PhiladelphiaDuration: Contract to hireCompensation: Up to $48/hrExact compensation may vary based on several factors, including skills, experience, and education. Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as...


  • Philadelphia, United States InSource, Inc Full time

    Business Systems Analyst Philadelphia, PA 19103Candidates must work onsite every Tuesday, Wednesday & Thursday, NO EXCEPTIONS. Local candidates from Metro Philadelphia, Southern Jersey or Southern Delaware only. DO NOT APPLY if you currently live outside these areas. Relocation is NOT an option for this role either, you must CURRENTLY live in the above...


  • Philadelphia, United States InSource, Inc Full time

    Business Systems Analyst Philadelphia, PA 19103Candidates must work onsite every Tuesday, Wednesday & Thursday, NO EXCEPTIONS. Local candidates from Metro Philadelphia, Southern Jersey or Southern Delaware only. DO NOT APPLY if you currently live outside these areas. Relocation is NOT an option for this role either, you must CURRENTLY live in the above...


  • Philadelphia, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Business Systems Analyst (SQL)Location: Philadelphia, PADuration: 6 Months Overview:Our Client a national health care insurance company is looking for a SQL Business System Analyst. The Business System Analyst role on the EIM Data Warehouse team requires experience in creating Business Requirement Documents,...


  • Philadelphia, Pennsylvania, United States GTT, LLC Full time

    Job DescriptionGTT, LLC is seeking a highly skilled Senior Business Systems Analyst to join our IT team. As a key member of our team, you will play a critical role in supporting industry-leading medical device management and critical patient client support services.This is a hands-on position that requires subject matter expertise in business functions...


  • Philadelphia, United States CitiusTech Full time

    Business System AnalystWho we are: -At CitiusTech, we constantly strive to solve the industry's greatest challenges with technology, creativity, and agility. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence for over 140 organizations through...


  • Philadelphia, United States Lorven Technologies Full time

    Job Title: Business System Analyst with ETL Job Location: Philadelphia, PA Job Type: Contract 12+ Months (C2C/W2) Primary Skill Requirements gathering and analysis, Data analysis and interpretation. Business process modeling, data modeling and database design, Documentation and report writing Microsoft Office Suite, SQL, Visio, Power BI,...


  • Philadelphia, United States Bi3 Careers Full time

    The Sr. Business System Analyst will serve as a liaison between business and technical teams to ensure the successful delivery of the business technology solutions.Duties and Responsibilities:Collaborating with stakeholders including billing, finance, and client implementation to understand both short term and long-term goals.Document functionality including...


  • Philadelphia, United States Twenty Bridge Staffing Full time $63 - $66

    Job DescriptionJob DescriptionTwenty Bridge is seeking several Business Systems Analysts to assist the Data Warehouse team for our client in Philadelphia PA. The position is onsite, with 2 days WFH. Candidate must be within a 40-mile radius to Philadelphia, PA.Job Description/QualificationsThis position requires 6-8 years’ experience in creating Business...


  • Philadelphia, Pennsylvania, United States Innova Solutions Full time

    About the RoleWe are seeking a highly skilled Business Systems Analyst to join our team at Innova Solutions. As a Business Systems Analyst, you will play a critical role in formulating and defining scope and objectives based on user needs and thorough understanding of business processes.Key ResponsibilitiesFormulate and define scope and objectives based on...


  • Philadelphia, United States e&e Technical Consultants, LLC Full time

    e&e is seeking a Business System Analyst for a hybrid opportunity in Philadelphia. Overview:Our organization is looking for dynamic individuals who love to learn, thrive on innovation, and are open to exploring new ways to achieve our goals. If this describes you, we want to speak with you. You can help us achieve our vision to lead nationally in innovating...