14 days old

Senior Associate, BI Engineer, Application Operations

Pew Charitable Trusts
Washington, DC 20001
Apply Now
Apply on the Company Site
  • Job Code
Washington, DC (901 E)

Senior Associate, Application Operations (Remote/Hybrid)

Position Overview

The Application Operations team is looking for a Senior Associate, Business Intelligence (BI) Engineer, who will provide analytical solutions and improve operational efficiencies across the organization. This highly collaborative role will work closely with cross-functional stakeholders to manage end-to-end analytics and BI projects, from discovery through implementation. We seek a candidate who is passionate about using data analysis, engineering, and data visualization techniques to turn unstructured data into actionable insights.

The Senior Associate reports to th e Senior Officer, Business Intelligence and Analytics. The position requires either monthly or quarterly travel to Pew's Washington, DC office.

  • Work collaboratively with teams across the organization to understand their data needs and support their development of relevant analyses and reports.
  • Provide oversight, best practices, and guidance for the development of interactive dashboards, including the design of data pipelines, to support the needs of department data users.
  • Design queries and scripts to collect, clean, organize, aggregate, and transform data for analysis.
  • Write code to streamline and automate manual data processing tasks.
  • Provide recommendations on reporting best practices synthesizing both unstructured and structured data sources.
  • Develop a broad understanding of all data assets and enforce and champion established guidance on best practices for storage, maintenance, and access through organization-wide data governance standards.
  • Conduct regular Tableau / PowerBI and SQL training s to support and grow Pew 's user community.
  • A Bachelors degree or equivalent experience required.
  • At least four years of dashboard design with a data visualization tool such as Tableau or Power BI , and expertise in quantative analysis and SQL required.
  • Development experience in at least one scripting language (Python, Ruby, etc.) preferred.
  • Experience with ETL development and knowledge of data warehouse technical architecture required. Experience with Amazon Redshift or Azure cloud services preferred.
  • Project management skills and an ability to communicate effectively with non-technical stakeholders.


Occasional travel required to Pew's Washington, DC office for training, meetings or conferences.

Total Rewards

We offer a competitive salary and benefit program, including: comprehensive, affordable health care through medical, dental, and vision coverage; financial security with life and disability insurance; opportunities to save using health savings and flexible spending accounts; retirement benefits to help prepare for the future; and work/life benefits to maintain a good balance.

The Pew Charitable Trusts is an equal opportunity employer, committed to a diverse and inclusive workplace. Pew considers qualified applicants for employment without regard to age, sex, ethnicity, religion, disability, marital status, sexual orientation or gender identity, military/veteran status, or any other basis prohibited by applicable law.


Posted: 2022-08-02 Expires: 2022-09-03

Job Opportunities

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Associate, BI Engineer, Application Operations

Pew Charitable Trusts
Washington, DC 20001

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast