Data Analyst, Enterprise Reporting & Analytics

BOP The Board of Pensions of the Presbyterian Church (USA); United States; On-site; USD 85,000 - 125,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Defined benefit pension plan

403(b)(9) retirement savings plan

Paid time off

Job summary

The Board of Pensions of the Presbyterian Church (U.S.A) is seeking a Data Analyst to partner with stakeholders to define data reporting requirements and build BI reports and dashboards to support operational and strategic goals.

You will design and maintain Power BI reports for Benefits, Operations, Marketing, and Finance, model data in Snowflake with SQL, validate logic, and communicate insights across the organization, including training and governance to uphold data standards.

Qualifications

• Bachelor’s degree and 5–7 years of related professional experience.
• Excellent verbal, written, and interpersonal communication skills.
• Advanced data visualization skills with Power BI.
• Strong SQL and data modeling ability.

Responsibilities

• Design, build, and maintain Power BI reports and dashboards for Benefits, Operations, Marketing, and Finance.
• Analyze and model raw data in Snowflake using SQL.
• Validate business logic and improve analytics objects through testing.
• Collaborate with stakeholders and data engineers to translate requirements into reports.

Education

Bachelor’s degree

Tools

Power BI

SQL

Snowflake

Job description

The role: The Data Analyst partners with business stakeholders to define data reporting requirements and builds business intelligence reports and dashboards to 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.

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

Qualifications

• Bachelor’s degree and 5‑7 years of related professional experience.
• 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.
• Ability to create and implement testing scenarios as part of a change control / CICD pipeline.
• Ability to stay current and maintain a level of professional expertise in analytical best practices via seminars, literature, and formal training.
• Ability to work on‑site Tuesday–Thursday at the 2000 Market Street office in Philadelphia.

Benefits

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

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, sexual orientation, gender, gender identity or expression, genetic information, ancestry, or any other category protected by applicable federal, state, or local law.