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

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.