ZipRecruiter

Log In

1

Intermediate Data Analyst Jobs in Philadelphia, PA

Varsity Tutors

Data Analysis Tutor

Trenton, NJ · Remote

$18 - $40/hr

... intermediate analysts building professional data analysis capabilities. * Effective Teaching ... Methods: Ability to identify concepts students commonly struggle with, explain material using ...

Varsity Tutors

Data Analysis Tutor

Chester, PA · Remote

$18 - $40/hr

... intermediate analysts building professional data analysis capabilities. * Effective Teaching ... Methods: Ability to identify concepts students commonly struggle with, explain material using ...

next page

Showing results 1-20

All JobsIntermediate Data Analyst JobsIntermediate Data Analyst Jobs in Philadelphia, PA

Intermediate Data Analyst information

See Philadelphia, PA salary details

$34.3K

$83.4K

$137.3K

How much do intermediate data analyst jobs pay per year?

As of Aug 27, 2026, the average yearly pay for intermediate data analyst in Philadelphia, PA is $83,401.00, according to ZipRecruiter salary data. Most workers in this role earn between $63,100.00 and $97,900.00 per year, depending on experience, location, and employer.

What is an intermediate data analyst?

Intermediate Data Analysts are professionals who collect, process, and analyze data to help organizations make informed decisions. They possess solid analytical skills, working knowledge of data analysis tools, and the ability to interpret complex data sets. Typically, they have some experience beyond entry-level roles and can handle more advanced tasks such as building reports, creating dashboards, and supporting business strategies with data-driven insights. Their work often involves collaborating with other teams to identify trends and provide actionable recommendations.

How does an intermediate data analyst typically collaborate with other departments within an organization?

As an Intermediate Data Analyst, you'll frequently work alongside teams such as marketing, finance, operations, and IT to gather requirements, interpret data needs, and deliver actionable insights. You may be responsible for translating business questions into analytical tasks, sharing findings through presentations or dashboards, and supporting decision-making processes. Collaboration often involves participating in cross-functional meetings, clarifying data definitions, and ensuring that analysis aligns with organizational goals. Building strong relationships with stakeholders is key to understanding their challenges and ensuring your work has maximum impact.

What are the key skills and qualifications needed to thrive as an intermediate data analyst, and why are they important?

To thrive as an Intermediate Data Analyst, you need strong analytical skills, experience with data manipulation and statistical analysis, and a relevant degree such as in mathematics, statistics, or computer science. Proficiency in tools like SQL, Excel, Python or R, and familiarity with data visualization platforms such as Tableau or Power BI are typically required. Attention to detail, effective problem-solving, and clear communication skills help you translate complex data into actionable insights for stakeholders. These skills and qualities are crucial for delivering accurate analyses that drive informed business decisions.

Is it still worth it to become a data analyst in 2026?

Data analyst roles remain valuable in 2026 as organizations continue to rely on data-driven decision-making, with skills in SQL, Excel, and data visualization tools like Tableau or Power BI in demand. The role often requires strong analytical skills, familiarity with programming languages such as Python or R, and the ability to interpret complex data sets, making it a stable career choice for those with relevant skills. Continuous learning and certification can enhance job prospects in this evolving field.

What is intermediate level data analysis?

Intermediate data analysts perform more complex data analysis tasks than entry-level roles, including data cleaning, visualization, and basic statistical modeling using tools like Excel, SQL, or Python. They interpret data insights to support decision-making and often work with larger datasets and more advanced techniques than beginners.

What are the most commonly searched types of Data Analyst jobs in Philadelphia, PA?

The most popular types of Data Analyst jobs in Philadelphia, PA are:

What are popular job titles related to Intermediate Data Analyst jobs in Philadelphia, PA?

For Intermediate Data Analyst jobs in Philadelphia, PA, the most frequently searched job titles are:

What job categories do people searching Intermediate Data Analyst jobs in Philadelphia, PA look for?

The top searched job categories for Intermediate Data Analyst jobs in Philadelphia, PA are:

What cities near Philadelphia, PA are hiring for Intermediate Data Analyst jobs?

Cities near Philadelphia, PA with the most Intermediate Data Analyst job openings:

Intermediate Data Analyst jobs near you
Infographic showing various Intermediate Data Analyst job openings in Philadelphia, PA as of August 2026, with employment types broken down into 1% As Needed, 85% Full Time, 12% Part Time, and 2% Contract. Highlights an 84% Physical, 4% Hybrid, and 12% Remote job distribution, with an average salary of $83,401 per year, or $40.1 per hour.

Data Analyst, Enterprise Reporting & Analytics

Philadelphia, PA • On-site

The Board of Pensions of the Presbyterian Church
Religious Organizations • 51 - 200 employees
Learn more about The Board of Pensions of the Presbyterian Churchexternal

Full-time

Medical, Dental, Vision, Retirement, PTO

Re-posted 18 days ago

Job description

The role:
The Data Analyst partners with business stakeholders to define data reporting requirements and builds business intelligence reports and dashboards to the support operational and strategic goals of the Board of Pensions. The Data Analyst presents data analysis, communicating valuable insights and educates others in the organization in how to effectively engage with these insights.
What you will do:
  • Design, build, and maintain Power BI Reports and dashboards for various business domains, including Benefits, Operations, Marketing, and Finance.
  • Analyze and model raw data in the Snowflake data warehouse using SQL. Utilize findings to improve report structure and/or recommend Data Engineering improvements.
  • Maintain clean, well-documented report logic in a team setting to promote shared understanding and collaboration.
  • Contribute to and improve upon a consistent design language across your output.
  • Validate business logic and use testing frameworks that improve the quality of analytics objects.
  • Collaborate with both stakeholders and data engineers and architects, demonstrating the ability to translate between business requirements and technical requirements.
  • Proactively identify ongoing and ad-hoc reporting and analysis that will support business decisions and generate insights to improve strategic decision making.
  • Contributes to the Data, Reporting and Analytics 'Center of Excellence' by providing training, resources, process documentation, and governance to maintain best in class data platform usage across stakeholders.

What you need to succeed:
  • Bachelor's degree
  • 5-7 years of related professional experience.
  • An ability to work as an effective team member.
  • Excellent verbal, written and interpersonal communication skills to explain and translate complex terms into easily understandable terms.
  • Exceptional data acumen and attention to detail.
  • Excellent data visualization skills, specifically with Power BI.
  • Intermediate SQL to access and model data needed for reports, interfaces, and metrics.
  • Working knowledge and understanding of basic statistics and mathematical models.
  • Experience using AI tools or agents in a data warehousing context a plus.
  • Working knowledge and understanding of Wireframe design and PowerPoint.
  • Advanced understanding of data and system validation methods.
  • An ability to create and implement testing scenarios as part of a change control / CICD pipeline.
  • An ability to stay current and maintain a level of professional expertise in analytical best practices via seminars, literature, and formal training.
  • An ability to work on-site Tuesday - Thursday at the 2000 Market Street office in Philadelphia.

We offer a generous benefits package for eligible employees.
  • Medical, dental, and vision coverage.
  • Defined benefit pension plan.
  • 403(b)(9) retirement savings plan.
  • Generous paid time off, including sick time, holidays, and 22 days of personal leave.
  • Tuition assistance.
  • Employee Assistance Plan and other health and well-being resources.
  • Employer-paid death benefits with opportunities to purchase additional coverage.
  • Employer-paid Short-Term and Long-Term disability coverage.
  • Access to the Board's education and grant assistance programs.
  • Discount programs on entertainment, travel, and more.
  • Satisfaction gained from working for a service-oriented employer.
  • Volunteer and other service opportunities in the community at large.

Our recruiting process is simple.
If you're interested in a role at the Board of Pensions, apply online at pensions.org. If your skills match an open position, one of our recruiters will set up a phone or Microsoft Teams interview to discuss your interests, background, and skills. They'll also answer any questions you might have. If you are selected to continue with the recruitment process, you will meet the hiring manager and other relevant team members.
To protect the health of our staff, we encourage everyone to receive FDA-approved vaccinations that may reduce the spread of certain infectious diseases, such as the flu and COVID-19.
We are an Equal Opportunity Employer.
The Board of Pensions of the Presbyterian Church (U.S.A.) is proud to be an equal opportunity employer We value diversity, equity, and inclusion and do not discriminate based on race; color; sex; national origin; age; pregnancy, childbirth, or a related medical condition; military/veteran status; marital/domestic partner status; physical or mental disability; medical condition; religion or religious affiliation, except where determined to be a bona fide occupational qualification; sexual orientation; gender; gender identity or expression; genetic information; ancestry; or any other category protected by applicable federal, state, or local law.

Apply