Officer, Business Intelligence and Analytics

Agile, Analysis, Architecture, Business Intelligence, Business Requirements, Consulting, Data Analysis, Data Modeling, Desktop Support, Development, Director, Foundation, Iterative, Iterative Development, Lifecycle, Modeling, OLAP, Project, SQL, Sun, Testing
Full Time
Telecommuting not available Travel not required

Job Description


The Pew Charitable Trusts is driven by the power of knowledge to solve today's most challenging problems. Pew applies a rigorous, analytical approach to improve public policy, inform the public and invigorate civic life.

We are an independent nonprofit organization - the sole beneficiary of seven individual trusts established between 1948 and 1979 by two sons and two daughters of Sun Oil Company founder Joseph N. Pew and his wife, Mary Anderson Pew.

Our work lays the foundation for effective policy solutions by informing and engaging citizens, linking diverse interests to pursue common cause and insisting on tangible results. Our projects encourage efficient, responsive governments - at the local, state, national and international levels - serving the public interests.

With offices in Philadelphia, Washington, DC, Brussels and London and staff in other regions of the United States as well as Australia, Pew provides an exciting learning environment and the opportunity to work with highly talented individuals. We are a dynamic, rapidly evolving organization that values creativity and innovative thinking and fosters strong teamwork with mutual respect.

Overview of Information Technology
Pew's Information Technology department (IT) takes a proactive approach toward the use of technology to increase the organization's capacity for exceptionally high-quality strategic philanthropy. Executive staff at the Trusts recognizes the importance of technology, and supports related initiatives to advance the institution's goals and achieve and maintain a leadership position in the philanthropic community. As a result, IT is in a mode of continuous improvement, applying leading-edge technology to the pursuit of the goals of the institution.

The department comprises highly competent, forward-thinking professionals who are responsible for the technology needs of all Pew staff, as well as for Pew's subsidiaries in Philadelphia and Washington, D.C. IT is organized into distinct areas of responsibility, including application operations, infrastructure operations (including desktop support and technical training), project delivery and solution design.

Position Overview
The Officer, Business Intelligence and Analytics, is responsible for ensuring the successful operation and ongoing enhancement of the institution's Business Intelligence and Analytics applications, primarily Tableau. To strengthen our growing team, we are looking for an experienced Tableau Architect to design and build highly scalable business intelligence and analytics solutions. As an integral member of the IT application operations team, this position will be responsible for developing and executing innovative business intelligence and data visualization solutions for business performance optimization. Candidates must possess outstanding interpersonal skills and demonstrate themselves to be a great analytical thinker and a creative data visualizer. Candidates must also be team-oriented and thrive in a fast-paced environment.

The Officer, Business Intelligence and Analytics reports to the Director, IT Operations.


* Work with the Director, IT Operations and the business stakeholders to drive Pew's BI strategy and execution.
* Work closely with business teams to determine business requirements to design, develop and deliver the BI / Analytics and dashboards.
* Work with multiple business stakeholders to develop solutions against departmental roadmap.
* Provide business with operational support around existing and newly developed analytics solutions and reports.
* Responsible for Tableau Administration.
* Support cross-organizational initiatives to improve key performance indicators, offering suggestions as to how information can be used more effectively to improve business performance.
* Perform high-level data analysis, dashboard interface design, develop user acceptance testing (UAT) criteria.
* Develop and deliver presentations to BI stakeholders, evangelize BI, and help train our business users.
* Partner with internal IT teams, third party vendors to develop consistent solutions.
* Work with other members of the IT Application Operations team for coordinated delivery.
* Acts as a point of technical and functional expertise related to Business Intelligence and Analytics capabilities, and related technology. Provides guidance to the business regarding BI solution design and implementation.
* Apply agile approaches for proof-of-concept requirements. Using iterative methods to help drive and refine information requirements, dashboard mockups, and prototyping.
* Support ongoing development within an Agile, iterative development methodology and contribute to all phases of the software development lifecycle.
* Establish and maintain key relationships with Pew program and operations staff; works with them and Director, IT Operations to align unit strategy with institutional and programmatic goals.


* Bachelor's degree required.
* Minimum of eight years of relevant, IT experience with a focus on Business Intelligence.
* Four or more years of experience in Tableau (specifically Desktop, Online, and Server products)
* Four or more years of experience in Tableau Report Development in terms of end-to-end experience in the design and development of Tableau solutions.
* Hands on experience in Tableau architecture.
* Experience of tableau 9.x.
* Data modeling and advanced reporting experience.
* Advanced knowledge of reports performance optimization.
* Understanding of data warehousing and business intelligence concepts and dashboard.
* Experience in OLAP, EDW and Redshift Concepts.
* Strong data development skills, particularly using SQL.
* Demonstrated success in Business Intelligence/analytics operations or consulting role, working collaboratively with developers as an integral part of an agile team.
* Ability to translate business needs to technical solutions.
* Excellent analytical and problem solving skills.
* Excellent interpersonal, written and verbal communication.
* Team oriented approach.
* Ability to work in an aggressive, fast paced environment managing multiple priorities.
* Experience working within an Agile development framework.
* Tableau certification preferred.

We offer a competitive salary and excellent benefits package.

Occasional travel required between Pew's main Philadelphia and Washington, DC offices, and smaller remote offices. Minimal additional travel required to attend trainings, seminars or conferences.

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.

Dice Id : RTL110183
Position Id : 5029
Have a Job? Post it

Similar Positions

Cloud Reporting Architect/Data Modeler
  • geicodc
  • Chevy Chase, MD
Business Intelligence (BI) Consultant
  • Robert Half Technology
  • Washington, DC
Business Intelligence Analyst
  • National Association of Corporate Directors
  • Washington, DC
BI Developer
  • OST, Inc.
  • Mclean, VA
Manager, Microstrategy BI and Analytics
  • Request Technology, LLC
  • Mclean, VA
Data Warehouse and Business Intelligence Architect
  • General Dynamics Information Technology
  • Fairfax, VA
  • ASD, Inc.
  • Falls Church, VA
Tableau Developer
  • Squires Group, Inc
  • Alexandria, VA
MCAT Data and Analytics Specialist
  • Association of American Medical Colleges
  • Washington, DC
Data Warehousing BI Analyst
  • Grant Thornton
  • Washington, DC
Data Architect
  • Softworld Inc
  • Herndon, VA
Solution Architect (Reporting, BI and Analytics)
  • Lumen Solutions Inc
  • Washington, DC
Manager, Business Intelligence
  • Career Path Group LLC
  • Gaithersburg, MD
Business Intelligence Developer (IT)
  • Metropolitan Washington Airports Authority
  • Arlington, VA