Deloitte Senior Consultant-Data Warehouse Lead in Pittsburgh, Pennsylvania

Senior Consultant - Data Warehouse Lead

Deloitte Consulting LLP

Deloitte Consulting LLP is one of the world's leading management consulting firms for executable strategy, operations, technology, and human capital advisory services. The GPS State Local Higher Education consulting practice is built around integrated core capabilities - people, process and technology and industry expertise - the capabilities needed to help clients to tackle their most complex challenges

Work you ll do

Deloitte Consulting's dynamic GPS SLHE based in Washington D.C. and the surrounding Metropolitan area has opportunities for you to become part of their high-quality team that delivers innovative solutions to key State Local and Higher Education clients in financial management, business process improvement, strategy and operations, information systems development, package implementation, enterprise transformation, business process and applications outsourcing, and a full range of human capital advisory services.

The team

Analytics & Cognitive

In this age of disruption, organizations need to navigate the future with confidence, embracing decision making with clear, data-driven choices that deliver enterprise value in a dynamic business environment.

The Analytics & Cognitive team leverages the power of data, analytics, robotics, science and cognitive technologies to uncover hidden relationships from vast troves of data, generate insights, and inform decision-making. Together with the Strategy practice, our Strategy & Analytics portfolio helps clients transform their business by architecting organizational intelligence programs and differentiated strategies to win in their chosen markets.

Analytics & Cognitive will work with our clients to:

  • Implement large-scale data ecosystems including data management, governance and the integration of structured and unstructured data to generate insights leveraging cloud-based platforms

  • Leverage automation, cognitive and science-based techniques to manage data, predict scenarios and prescribe actions

  • Drive operational efficiency by maintaining their data ecosystems, sourcing analytics expertise and providing As-a-Service offerings for continuous insights and improvements

Our technology consultants, working with our IT organizations, can help our clients to use technology integration to solve business challenges. Our technology specialists, all with extensive experience in systems integration and development, are committed to delivering efficient, technology-based solutions to our clients. We assess our client's current technology needs and assist with systems design and implementation to improve both enterprise-wide integration and profitability. Through our long-term partnerships with many of the world's leading technology companies we can offer extremely cost-effective implementation to our clients.

  • Development Services

  • Enterprise Connection Services

  • Architecture and Network Services

  • Enterprise Systems Management and Security

  • Information Dynamics

  • CIO Services


  • 4-6 years of relevant Data Warehousing experience

  • 2 years of relevant Data Warehouse Lead experience

  • Responsible for leading maintenance and enhancement activities for an enterprise data warehouse and other similar analytics assets.

  • Work with client staff to define initiative requirements.

  • Team with off-shore staff to complete design and development work.

  • Perform testing and support user acceptance testing.

  • Must be able to analyze client's existing infrastructure and solution design and recommend appropriate electronic platform to satisfy business requirements.

  • Experience must also include contributing statements of work and to the development of client proposals.

  • Must be onsite and live local to Pittsburgh, Pa

  • Bachelor's Degree

Other technical experience that is helpful includes:

  • Experience with database engines such as Oracle or PostgreSQL

  • Demonstrated competence with tools/technologies such as PL/SQL and IDM Data Stage for data extraction, transformation, and loading; Tableau for the creation of visualizations; IBM Cognos for management reporting

  • Hands-on Big Data experience a plus

How you ll grow

At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there s always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Center. at


At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. at

Deloitte s culture

Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte. at

Corporate citizenship

Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte s impact on the world. at

Recruiter tips

We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you re applying to. Check out recruiting tips from Deloitte professionals. at

Category: Management Consulting

About Deloitte

As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.