Application Support Specialist I

Philabundance; Philadelphia (Philadelphia County); On-site; USD 58,500 - 71,500; Full time

Job summary

Philabundance in Philadelphia, PA is seeking an Applications and Database Support Specialist to provide day-to-day support for the data and reporting environment. You will monitor integrations, maintain reports, and troubleshoot BI tools to ensure data reliability and availability for Finance, Operations, and Human Resources.

The role emphasizes SQL, SSIS/SSAS, Power BI, and Power Platform tasks; you will develop ad hoc queries, help with data quality, documentation, and user training, while

Qualifications

• Minimum 2 years in business/data analysis or related roles.
• Experience managing data and reporting for dynamic teams.
• Experience leading projects from concept to production.
• Experience with data integration, reporting, and BI tools.
• Knowledge of SQL and database design.
• Familiarity with Power Platform and API integration.
• Strong attention to detail and meeting deadlines.

Responsibilities

• Monitor SSIS package failures and SQL Agent alerts.
• Run and validate Power BI reports; troubleshoot data refresh.
• Support data quality checks and QC logging.
• Write and optimize ad hoc SQL queries for business teams.
• Document stored procedures, views, and SSIS packages.
• Maintain Power Automate flows and PowerApps updates.
• Monitor API integrations and triage issues with stakeholders.
• Collaborate with IT and end users to deploy new functionality.
• Analyze data to provide management insights.

Skills

SQL

Data analysis

Cross-functional collaboration

Attention to detail

Data security

Education

High School Diploma or GED

Bachelor's degree preferred

Tools

SSIS

SSAS

Power BI

Power Automate

REST APIs

C# / VB

Job description

Job Details Job Location: Philadelphia, PA 19122 Position Type: Full Time Education Level: High School / GED Salary Range: $65,000.00 - $65,000.00 Salary/year Travel Percentage: None

Position Summary:

The Applications and Database Support Specialist provides day-to-day operational support and maintenance for the organization's data and reporting environment. This role assists with monitoring data integrations, maintaining reporting solutions, supporting database quality assurance processes, and troubleshooting business intelligence tools. The incumbent works closely with business stakeholders across Finance, Operations, and Human Resources to ensure the reliability, accuracy, and availability of critical data systems and reports.

Primary Responsibilities:

• Assist with monitoring and triaging SSIS package failures and SQL Agent job alerts
• Run and validate existing Power BI reports; perform basic DAX edits and data refresh troubleshooting
• Support data quality checks and QC logging procedures across operational databases
• Write and optimize ad hoc SQL queries to support business teams
• Assist with documentation of stored procedures, views, and SSIS packages
• Support Power Automate flow maintenance and minor PowerApps updates
• Help manage API integration monitoring (Raiser's Edge, DoorDash, Omnitracs) — log errors, flag anomalies, and expedite issues as they arise
• Collaboration and Training: Work closely with IT management, project managers, and internal teams to deliver new system functionality. Provide training on new application tools, reports, and data processes to end users.
• Data Analysis and Insights: Conduct thorough analysis of data, emphasizing quality, relevance, and identifying variables that impact cross-functional user groups. Prepare detailed reports and analysis for management and team projects.
• Customer Service: Maintain high levels of internal customer service by addressing user concerns promptly and providing effective solutions.
• Compliance and Security: Ensure data protection measures align with organizational policies, job roles, and industry standards.
• Process Improvements: Utilize advanced SQL knowledge, Power Platform tools, SSIS/SSAS, and programming skills (C#/VB) to support technology initiatives and data analysis needs. Identify and implement technology solutions to improve business processes and address organizational needs.
• Support Organizational Culture: Align responsibilities with Philabundance's cultural pillars, fostering a focus on People, Partnerships, Professionalism, and Progress.

Qualifications Required Skills and Abilities:

• Strong working knowledge of SQL and an understanding of database designs.
• Strong data analytic ability aligned with goals, projections, and trend identification.
• Ensures the protection of data is appropriate by job roles.
• Builds open relationships with cross-functional leadership to initiatives appropriately.
• Must have strong attention to detail and deadlines.
• Using SSIS/SSAS (SQL Server Integrated and Analysis Services)
• Knowledge of different system platforms C#/VB, Microsoft Power Platform, API development and integration
• Utilize advanced SQL knowledge, Power Platform tools, SSIS/SSAS, and programming skills (C#/VB) to support technology initiatives and data analysis needs.

Preferred:

• PowerShell scripting basics
• Experience with REST APIs or Power Automate

Work Experience:

• Minimum 2 years of previous experience as a Business Analyst, Data Analyst or related experience. Previous experience working managing data and reporting for dynamic teams.
• Demonstrated ability to lead projects from conceptual, through development and testing and into production.
• Experience collaborating to support a shared and diverse goal which requires deadlines, accuracy, and broad data sets.

Preferred:

• Experience working in an industry with distribution, order fulfillment and product selection

Educational Achievement:

• High School Diploma or GED required. Education or experience equal to a bachelor's degree