BI Report Developer Senior Associate

Guidehouse - McLean, VA (30+ days ago)


PwC Public Sector, LLP helps federal, state, and local governments solve complex business issues, manage risk and add value in financial management, program management, operations improvement, and security and data management. In today's changing environment, the public sector is seeing an increase in physical and cyber threats, financial and performance reporting requirements, diversity in the workforce, and the impact of rapidly changing technologies.

PwC Public Sector LLP provides management consulting, technology consulting and risk consulting services to help federal and international government agencies anticipate and address these and other complex challenges.

PwC Public Sector LLP is one of four organizations to receive the 2014 Malcolm Baldrige National Quality Award. The Baldrige Award is the nation’s highest Presidential honor for performance excellence, recognizing U.S. organizations for superior quality and world-class results across six categories defined by Baldrige including Leadership, Strategic Planning, Customer Focus, Measurement, Analysis and Knowledge Management, Workforce Focus, and Operations Focus. For more information on our journey to performance excellence, view our winner profile on the NIST website.

It was announced in February of 2018 that Veritas Capital, a leading private equity investment firm had signed a definitive agreement to acquire its US Public Sector business.

Professionals in PwC Public Sector LLP may be subject to a government security investigation and may need to meet related eligibility requirements for access to classified information. Our Information Management consultants help clients maximize the value of their data. This high performing team helps clients define their information strategy, architecture and governance, get the most value from business intelligence and analytics, and implement enterprise content and data management solutions to reduce cost and complexity, increase trust and integrity, and improve operational effectiveness.

Minimum Years of Experience: 4

Minimum Degree Required: Bachelor's degree in Computer Science or any MIS related field

Knowledge Preferred:
Demonstrates thorough knowledge of contributing on client engagement teams that design and develop business intelligence (BI) and predictive models for data warehouse (DW) information management architecture, including:
  • Evaluating enterprise DW architecture feasibility, risk and technologies related to business change (i.e. assessing, identifying and recommending BI and related business stakeholders' data requirements; BI solution prototyping and development; processes and performance from business and technical standpoints; and the impact of data changes on business and/or IT processes);
  • Advising CXO's on emerging BI/DW technologies and strategies consistent with clients' business strategies;
  • Prioritizing, preparing and implementing BI and/or DW architectural improvements (i.e. developing and recommending alternative DW technical and data management solutions, methodologies, strategies and architectural improvement plans);
  • Developing and validating business stakeholders' conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements.
Skills Preferred:
Demonstrates thorough abilities to interact with end users to understand and document business and functional requirements for complex projects, including full software development life cycle, DW/BI/ETL tools and other related technologies, including:
  • Enterprise data management, data warehousing and/or business intelligence; data modeling, integration and/or synchronization, quality, security, conversion and analysis; database administration; and/or enterprise data management policies, procedures, compliance & risk management. This includes a minimum of having participated in two full life cycle implementations
  • Architecture, design and development of enterprise business intelligence and data warehousing solutions, including utilizing leading ETL/BI tools and the ability to architect a solution
  • Design and development of data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching that leverages knowledge within data, master data, metadata and technology management.
Demonstrates proven thorough skills and success participating in consulting-related projects within a professional services environment that utilize creative thinking skills and individual initiative, including the following:
  • Collaborating and contributing as a team member: understanding personal and team roles; contributing to a positive working environment by building solid relationships with team members; proactively seeking guidance, clarification and feedback
  • Identifying and addressing client needs: building solid relationships with clients; developing an awareness of Firm services; approaching client in an organized manner; delivering clear requests for information; demonstrating flexibility in prioritizing and completing tasks; communicating potential conflicts to a supervisor
  • Prioritizing and handling multiple tasks; researching and analyzing pertinent client, industry, and technical matters; utilizing problem-solving skills; and, communicating effectively in written and verbal formats to various audiences (including various levels of management and external clients) in a professional business environment
  • Coaching and collaborating with associates who assist with this work, including providing coaching, feedback and guidance on work performance.
Travel Required
Yes. 0-20%
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information.