Data & BI Systems 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

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