Enterprise Analytics Data Analyst (Power BI)

The Board of Pensions of the Presbyterian Church (U.S.A.); Philadelphia (Philadelphia County); On-site; USD 85,000 - 115,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Defined benefit pension plan

403(b)(9) retirement savings plan

Generous paid time off

Tuition assistance

Employee Assistance Plan

Disability coverage

Education and grant assistance

Discount programs

Volunteer opportunities

Job summary

The Data Analyst at The Board of Pensions of the Presbyterian Church (U.S.A.) partners with business stakeholders to define data reporting requirements and builds BI reports and dashboards to support operational and strategic goals. You will present data insights and educate others on engaging with these insights.

Design, build, and maintain Power BI reports, analyze Snowflake data with SQL, and ensure well-documented report logic.

Qualifications

• Bachelor’s degree.
• 5-7 years of related professional experience.
• Excellent verbal, written and interpersonal communication skills to explain and translate complex terms into easily understandable terms.
• 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

Responsibilities

• 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.
• 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.
• Contribute 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.

Skills

Data analysis

Communication

Team collaboration

Statistics basics

AI tools in data warehousing

Education

Bachelor's degree

Tools

Snowflake

Power BI

Job description

The Data Analyst at The Board of Pensions of the Presbyterian Church (U.S.A.) partners with business stakeholders to define data reporting requirements and builds BI reports and dashboards to support operational and strategic goals. You will present data insights and educate others on engaging with these insights.

Design, build, and maintain Power BI reports, analyze Snowflake data with SQL, and ensure well-documented report logic.