Business Systems Analyst - SQL, Python | 40% Remote | Philadelphia PA 19103

Alpha Business Solutions
  • Philadelphia, PA
  • Remote
  • $42–$46 Per Hour
  • Instant Apply
1 day ago

Job Description

Job Title: Business Systems Analyst – SQL, Python, Power Query
Location: Hybrid (Tues, Wed, Thurs onsite, 3 days/week onsite) | Philadelphia, PA 19103
Contract-to-Hire
Pay rate: $42/HR - $46/HR W2 (negotiable)
 
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.
 
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
 
Please apply with your interest. You may also reach out to me at

abaranwal@alphambe.com


 
Thank you,
Ashu
 
We provide a comprehensive package which includes.
Benefits
  • Medical for full time employees
  • Dental, and Vision Insurance
  • Life Insurance, Short-Term Disability, Long-Term Disability, etc.

Numbers & Facts

LocationPhiladelphia, PA (
Remote
)
Salary$42–$46 Per Hour

Skills

  • Agile Programming Methodologiesunmatched
  • Analysis Skillsunmatched
  • Automationunmatched
  • Business Administrationunmatched
  • Business Analysisunmatched
  • Business Processesunmatched
  • Business Solutionsunmatched
  • Business Supportunmatched
  • Computer Scienceunmatched
  • Consultingunmatched
  • Customer Support/Serviceunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Setsunmatched
  • Data Structuresunmatched
  • Dental Insuranceunmatched
  • Detail Orientedunmatched
  • Documentationunmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Leadershipunmatched
  • Microsoft Excelunmatched
  • Microsoft Officeunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Multitaskingunmatched
  • Needs Assessmentunmatched
  • Operational Auditunmatched
  • Operational Supportunmatched
  • Organizational Skillsunmatched
  • Performance Analysisunmatched
  • Plan Meetingsunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Procedure Implementationunmatched
  • Process Analysisunmatched
  • Production Systemsunmatched
  • Project/Program Managementunmatched
  • Python Programming/Scripting Languageunmatched
  • Query Analysisunmatched
  • Reconciliationunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • Root Cause Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Scrum Project Management and Software Developmentunmatched
  • Software Debuggingunmatched
  • Sprint Planningunmatched
  • Staff Trainingunmatched
  • Systems Administration/Managementunmatched
  • Systems Analysisunmatched
  • Technical Writingunmatched
  • Time Managementunmatched
  • Trend Analysisunmatched
  • Vision Planunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder