Business Systems Analyst (Hybrid)

Serigor•Philadelphia, PA

1d•Hybrid

About The Position

The Business Systems Analyst connects business stakeholders, IT development teams, and data teams by translating business needs into technical solutions. The role uses SQL Server, Power Query, and Python to extract, validate, automate, analyze, and report on operational data. Work includes reconciling enrollment and ID card activities, investigating defects and incidents, and leading business initiatives with broad process and system impact. The position is based in Philadelphia, Pennsylvania, with onsite work Monday, Wednesday, and Friday. It is a six-month contract-to-hire role. The analyst develops an understanding of business needs, application functionality, data processes, and integration workflows; gathers preliminary requirements; and helps implement appropriate solutions. The role also develops and maintains queries, reports, dashboards, data models, procedure manuals, process documentation, and technical references. The analyst researches tickets and inquiries, supports timely resolution of issues by IT development teams, participates in meetings and sprint planning, and helps implement new procedures and train staff.

Requirements

At least 3–4 years of relevant business analysis, data analysis, or operational experience.
Demonstrated experience 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 described as required/preferred.
Proficiency in Microsoft Office Suite, including advanced Excel functions, and SQL-based data analysis tools.
Strong understanding of data structures, business processes, and system functionality in a production environment.
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.
Self-motivated, highly organized, and detail-oriented, with strong analytical, critical-thinking, and problem-solving skills.
Ability to work in a fast-paced, multitask environment with effective time and project management skills.
Excellent written and verbal communication, collaboration, and customer service skills to support business teams, technology partners, and stakeholders.
Enrollment and reconciliation expertise.
Operational leadership, including leading initiatives, stakeholders, and outcomes.
Process improvement and problem-solving capabilities.
Data analysis and reporting experience.
Ability to navigate complex regulatory and compliance-driven environments.
Depth of knowledge and strategic thinking, including the ability to explain how to navigate the role’s complexities.
Demonstrated examples managing complex enrollment operations.
Ability to identify root causes and influence outcomes across multiple stakeholders.
Experience developing queries, reports, dashboards, and data models for operational analysis.
Experience reconciling data by comparing client files with internal data sets.
Experience investigating root causes of application defects and data issues.
Experience gathering requirements and managing stakeholders across business and IT.
Experience with process documentation, work procedure manuals, and technical reference materials.
Experience acting as project lead on broad-impact business initiatives.
Bachelor’s degree in business administration, Information Systems, Computer Science, Data Analytics, or a related field, or equivalent experience; the degree is listed as preferred.

Nice To Haves

SQL Server Management Studio (SSMS) and T-SQL query development and data analysis.
Power BI.
Python libraries including Pandas and NumPy.
Agile/Scrum project methodologies and participation in sprint planning.
Experience in a health insurance or healthcare payer environment.

Responsibilities

Understand business needs, application functionality, underlying data processes, and data integration workflows.
Build relationships and serve as a 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 with internal data sets.
Analyze and summarize results for leadership, internal business partners, and external customers.
Use 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 for operational analysis, decision-making, and performance monitoring.
Research incident tickets and email inquiries, answer questions about program and application functionality, and identify application defects and data issues.
Track timely resolution of issues by IT development teams.
Participate in meetings and sprint planning to monitor progress toward sprint goals and development milestones.
Assist in training staff or collaborate with trainers to implement new procedures with minimal business disruption.
Respond to complex special requests involving data analysis, research, investigation, evaluation, and documentation of findings.
Develop and maintain work procedure manuals, process documentation, and technical reference materials.
Lead business initiatives with broad impact on processes, procedures, workflows, and system functionality.
Perform other duties as assigned.