Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Business Systems Analyst Hybrid

  • Business Systems Analyst Hybrid job type Posted on: Oct 21, 2026
  • Business Systems Analyst Hybrid experience level Serigor Inc
  • Business Systems Analyst Hybrid employment type Philadelphia, Pennsylvania
  • Business Systems Analyst Hybrid employment type Onsite
  • Business Systems Analyst Hybrid salary Full-time

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Business Systems Analyst Hybrid roles in Pennsylvania.

View Salary Guide →

Job Title :

Business Systems Analyst Hybrid

Job Type :

Full-Time

Job Location :

Philadelphia Pennsylvania United States

Remote :

No

Jobcon Logo Job Description :

Job Title: Business Systems Analyst

Location: Philadelphia, PA (Hybrid onsite Mon/Wed/Fri)

Duration: 6 months, Contract-to-Hire

Job Description:

The Business Systems Analyst serves as the connection between business stakeholders, IT development teams and data teams translating business needs into technical solutions, and using SQL Server, Power Query and Python to extract, validate, automate and report on operational data. The role includes reconciliation work across enrollment and ID card activities, defect and incident investigation, and acting as project lead for business initiatives with broad process and system impact.

Key Responsibilities:

  • Have a deep understanding of business needs, application functionality, underlying data processes, and data integration workflows.
  • Build strong relationships to serve as the point of contact for IT developers, data teams, and business stakeholders.
  • Initiate preliminary business requirements, assess needs, and implement appropriate solutions.
  • Evaluate business processes by tracking, trending, and analyzing work processes. Troubleshoot issues, identify root causes, and recommend solutions to management.
  • Reconcile client accounts related to enrollment and ID card activities by comparing client files to internal data sets. Analyze and summarize results for leadership, internal business partners, and external customers.
  • Utilize SQL Server, Power Query, and Python to extract, transform, analyze, validate, and automate data processes and reporting activities.
  • Develop and maintain queries, reports, dashboards, and data models to support operational analysis, decision-making, and performance monitoring.
  • Research incident tickets and email inquiries, answer program and application functionality questions, and identify application defects and data issues. Track timely resolution by IT development teams.
  • Participate in meetings and sprint planning sessions to ensure technical partners are progressing toward sprint goals and development milestones are on track.
  • Assist in training staff or collaborate with trainers to implement new procedures with minimal business disruption.
  • Respond to complex special requests that may include data analysis, research, investigation, evaluation, and documentation of findings.
  • Develop and maintain work procedure manuals, process documentation, and technical reference materials.
  • Serve as project lead for business initiatives that have a broad impact on processes, procedures, workflows, and system functionality.
  • Perform other duties as assigned.

Minimum Education and Experience (client's "Revised Qualifications"):

  • Bachelor's degree in business administration, Information Systems, Computer Science, Data Analytics, or a related field preferred; or equivalent experience.
  • Minimum of 3-4 years of relevant business analysis, data analysis, or operational experience required.
  • Demonstrated experience working with Microsoft SQL Server, including writing, and troubleshooting SQL queries to analyze and validate data.
  • Experience using Power Query for data extraction, transformation, automation, and reporting.
  • Experience with Python for data analysis, data validation, process automation, and reporting is required/preferred.
  • Proficient in Microsoft Office Suite, including advanced Excel functions, and SQL-based data analysis tools.
  • Self-motivated, highly organized, and detail-oriented with strong analytical, critical thinking, and problem-solving skills.
  • Ability to work in a fast-paced, multi-task environment with effective time management and project management skills.
  • Excellent written and verbal communication, collaboration, and customer service skills to support business teams, technology partners, and stakeholders.
  • Strong understanding of data structures, business processes, and system functionality within a production environment.
  • Must have thorough technical knowledge of business systems, applications, and related data flows.
  • Ability to independently manage projects, identify business opportunities, and implement solutions with minimal supervision.

Preferred Technical Skills:

  • SQL Server Management Studio (SSMS).
  • T-SQL query development and data analysis.
  • Power Query and Power BI.
  • Python (Pandas, NumPy, data automation, reporting).
  • Data reconciliation, data quality analysis, and root cause investigation.
  • Agile/Scrum project methodologies.

Soft Skills:

  • Self-motivated, highly organized, and detail-oriented.
  • Strong analytical, critical thinking, and problem-solving skills.
  • Excellent written and verbal communication, collaboration and customer service skills.
  • Able to work in a fast-paced, multi-task environment with effective time and project management.

Skills:

Skill

Required/

Desired

Amount

of Experience

Enrollment and reconciliation expertise. (Hiring manager's reopened criteria lead requirement.)

Required

Years

Operational leadership leading initiatives, stakeholders and outcomes. (Reopened criteria.)

Required

Years

Process improvement and problem-solving capabilities. (Reopened criteria.)

Required

Years

Data analysis and reporting experience. (Reopened criteria.)

Required

Years

Navigating complex regulatory and compliance-driven environments. (Reopened criteria.)

Required

Years

Depth of knowledge and strategic thinking able to articulate how they would navigate the complexities of the role. (Reopened criteria.)

Required

Managing complex enrollment operations demonstrable examples.

Required

Years

Identifying root causes and influencing outcomes across multiple stakeholders.

Required

Years

Relevant business analysis, data analysis or operational experience.

Required

3-4

Years

Microsoft SQL Server writing complex queries from scratch and troubleshooting them.

Required

Years

Power Query data extraction, transformation, automation and reporting.

Required

Years

Python scripting data analysis, validation, process automation and reporting.

Required

Years

Microsoft Office Suite including advanced Excel functions.

Required

Years

Queries, reports, dashboards and data models for operational analysis.

Required

Years

Data reconciliation comparing client files to internal data sets.

Required

Years

Root cause investigation on application defects and data issues.

Required

Years

Requirements gathering and stakeholder management across business and IT.

Required

Years

Process documentation, work procedure manuals and technical reference materials.

Required

Years

Acting as project lead on broad-impact business initiatives.

Required

Years

Bachelor's degree in business administration, Information Systems, Computer Science, Data Analytics or related (or equivalent experience).

Required

SQL Server Management Studio (SSMS) and T-SQL development.

Desired

Years

Power BI.

Desired

Years

Python libraries Pandas, NumPy.

Desired

Years

Agile/Scrum project methodologies and sprint planning participation.

Desired

Years

Health insurance / healthcare payer environment.

Desired

Years

Jobcon Logo Position Details

Posted:

Oct 21, 2026

Reference Number:

39962-404

Employment:

Full-time

City:

Philadelphia

Job Origin:

CIEPAL_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Business Systems Analyst Hybrid    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Job Title: Business Systems Analyst

Location: Philadelphia, PA (Hybrid onsite Mon/Wed/Fri)

Duration: 6 months, Contract-to-Hire

Job Description:

The Business Systems Analyst serves as the connection between business stakeholders, IT development teams and data teams translating business needs into technical solutions, and using SQL Server, Power Query and Python to extract, validate, automate and report on operational data. The role includes reconciliation work across enrollment and ID card activities, defect and incident investigation, and acting as project lead for business initiatives with broad process and system impact.

Key Responsibilities:

  • Have a deep understanding of business needs, application functionality, underlying data processes, and data integration workflows.
  • Build strong relationships to serve as the point of contact for IT developers, data teams, and business stakeholders.
  • Initiate preliminary business requirements, assess needs, and implement appropriate solutions.
  • Evaluate business processes by tracking, trending, and analyzing work processes. Troubleshoot issues, identify root causes, and recommend solutions to management.
  • Reconcile client accounts related to enrollment and ID card activities by comparing client files to internal data sets. Analyze and summarize results for leadership, internal business partners, and external customers.
  • Utilize SQL Server, Power Query, and Python to extract, transform, analyze, validate, and automate data processes and reporting activities.
  • Develop and maintain queries, reports, dashboards, and data models to support operational analysis, decision-making, and performance monitoring.
  • Research incident tickets and email inquiries, answer program and application functionality questions, and identify application defects and data issues. Track timely resolution by IT development teams.
  • Participate in meetings and sprint planning sessions to ensure technical partners are progressing toward sprint goals and development milestones are on track.
  • Assist in training staff or collaborate with trainers to implement new procedures with minimal business disruption.
  • Respond to complex special requests that may include data analysis, research, investigation, evaluation, and documentation of findings.
  • Develop and maintain work procedure manuals, process documentation, and technical reference materials.
  • Serve as project lead for business initiatives that have a broad impact on processes, procedures, workflows, and system functionality.
  • Perform other duties as assigned.

Minimum Education and Experience (client's "Revised Qualifications"):

  • Bachelor's degree in business administration, Information Systems, Computer Science, Data Analytics, or a related field preferred; or equivalent experience.
  • Minimum of 3-4 years of relevant business analysis, data analysis, or operational experience required.
  • Demonstrated experience working with Microsoft SQL Server, including writing, and troubleshooting SQL queries to analyze and validate data.
  • Experience using Power Query for data extraction, transformation, automation, and reporting.
  • Experience with Python for data analysis, data validation, process automation, and reporting is required/preferred.
  • Proficient in Microsoft Office Suite, including advanced Excel functions, and SQL-based data analysis tools.
  • Self-motivated, highly organized, and detail-oriented with strong analytical, critical thinking, and problem-solving skills.
  • Ability to work in a fast-paced, multi-task environment with effective time management and project management skills.
  • Excellent written and verbal communication, collaboration, and customer service skills to support business teams, technology partners, and stakeholders.
  • Strong understanding of data structures, business processes, and system functionality within a production environment.
  • Must have thorough technical knowledge of business systems, applications, and related data flows.
  • Ability to independently manage projects, identify business opportunities, and implement solutions with minimal supervision.

Preferred Technical Skills:

  • SQL Server Management Studio (SSMS).
  • T-SQL query development and data analysis.
  • Power Query and Power BI.
  • Python (Pandas, NumPy, data automation, reporting).
  • Data reconciliation, data quality analysis, and root cause investigation.
  • Agile/Scrum project methodologies.

Soft Skills:

  • Self-motivated, highly organized, and detail-oriented.
  • Strong analytical, critical thinking, and problem-solving skills.
  • Excellent written and verbal communication, collaboration and customer service skills.
  • Able to work in a fast-paced, multi-task environment with effective time and project management.

Skills:

Skill

Required/

Desired

Amount

of Experience

Enrollment and reconciliation expertise. (Hiring manager's reopened criteria lead requirement.)

Required

Years

Operational leadership leading initiatives, stakeholders and outcomes. (Reopened criteria.)

Required

Years

Process improvement and problem-solving capabilities. (Reopened criteria.)

Required

Years

Data analysis and reporting experience. (Reopened criteria.)

Required

Years

Navigating complex regulatory and compliance-driven environments. (Reopened criteria.)

Required

Years

Depth of knowledge and strategic thinking able to articulate how they would navigate the complexities of the role. (Reopened criteria.)

Required

Managing complex enrollment operations demonstrable examples.

Required

Years

Identifying root causes and influencing outcomes across multiple stakeholders.

Required

Years

Relevant business analysis, data analysis or operational experience.

Required

3-4

Years

Microsoft SQL Server writing complex queries from scratch and troubleshooting them.

Required

Years

Power Query data extraction, transformation, automation and reporting.

Required

Years

Python scripting data analysis, validation, process automation and reporting.

Required

Years

Microsoft Office Suite including advanced Excel functions.

Required

Years

Queries, reports, dashboards and data models for operational analysis.

Required

Years

Data reconciliation comparing client files to internal data sets.

Required

Years

Root cause investigation on application defects and data issues.

Required

Years

Requirements gathering and stakeholder management across business and IT.

Required

Years

Process documentation, work procedure manuals and technical reference materials.

Required

Years

Acting as project lead on broad-impact business initiatives.

Required

Years

Bachelor's degree in business administration, Information Systems, Computer Science, Data Analytics or related (or equivalent experience).

Required

SQL Server Management Studio (SSMS) and T-SQL development.

Desired

Years

Power BI.

Desired

Years

Python libraries Pandas, NumPy.

Desired

Years

Agile/Scrum project methodologies and sprint planning participation.

Desired

Years

Health insurance / healthcare payer environment.

Desired

Years

Loading
Please wait..!!