Deloitte Consulting LLP is one of the world's leading management
consulting firms for executable strategy, operations, technology, and
human capital advisory services. The 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
Federal Practice - Deloitte Consulting LLP
Deloitte Consulting's dynamic Federal Practice 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 Federal 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.
As a Data Warehouse Architect, you will act as the primary technical architect for our data warehousing projects to solve some of the toughest challenges in business intelligence today. The successful candidate should possess deep technical expertise in database design, ETL, reporting and analytics and will have previous consulting experience utilizing a structured delivery methodology.
• A minimum of 10 years experience architecting large scale data warehouses using Oracle
• A minimum of 7 years of relevant consulting experience preferred or 15 years of corporate IT
• Expert data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3rd normal form as well as dimensional modeling (star, snowflake), experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts
• Expert with pro's and con's of multiple warehouse architectures
• Expert RDBMS knowledge of Oracle (release 9i and 10g) including very large databases
• Expert in load design strategies and optimization techniques
• Implementation experience with ETL concepts and tools such as: Oracle Warehouse Builder, Informatica, DataStage, and ab Initio
• Implementation experience with one or more of the following BI/Enterprise Reporting tools: Oracle Discoverer, Business Objects, Cognos, Brio, and Microstrategy
• Possess strong communication and client management skills.
• Ability to effectively manage multiple projects simultaneously
• BS in Computer Science or equivalent experience in a relevant field
• Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
• Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)
• Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)
• Oversight of tool evaluation and selection
• Hardware recommendations, sizing and configuration
• RDBMS installation, configuration and tuning
• Oversight and/or coordination of system testing phase
• Problem and issue resolution
• Mentoring and developing junior staff
• Participation in proposal development and client presentations
Deloitte is one of the leading professional services organizations in the United States, specializing in audit, tax, consulting and financial advisory services with clients in more than 20 industries. We provide powerful business solutions to some of the world’s most well-known and respected companies, including more than 75 percent of the Fortune 100.
At Deloitte, you can have a rewarding career on every level. In addition to challenging and meaningful work, you’ll have the chance to give back to your community, make a positive impact on the environment, participate in a range of diversity and inclusion initiatives, and find the support, coaching, and training it takes to advance your career. Our commitment to individual choice lets you customize aspects of your career path, your educational opportunities and your benefits. And our culture of innovation means your ideas on how to improve our business and your clients’ will be heard.
Visit www.deloitte.com/us/careers to learn more about our culture, benefits and opportunities.
About Deloitte
As used in this document, “Deloitte” means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/ about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Deloitte LLP and its subsidiaries are equal opportunity employers.
More On: http://careers.deloitte.com/jobs/eng-US/details/j/E12ROSCMGRRV123/data-warehouse-architect
Federal Practice - Deloitte Consulting LLP
Deloitte Consulting's dynamic Federal Practice 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 Federal 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.
As a Data Warehouse Architect, you will act as the primary technical architect for our data warehousing projects to solve some of the toughest challenges in business intelligence today. The successful candidate should possess deep technical expertise in database design, ETL, reporting and analytics and will have previous consulting experience utilizing a structured delivery methodology.
Job Requirements:
Ability to Obtain a US Govt security clearance• A minimum of 10 years experience architecting large scale data warehouses using Oracle
• A minimum of 7 years of relevant consulting experience preferred or 15 years of corporate IT
• Expert data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3rd normal form as well as dimensional modeling (star, snowflake), experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts
• Expert with pro's and con's of multiple warehouse architectures
• Expert RDBMS knowledge of Oracle (release 9i and 10g) including very large databases
• Expert in load design strategies and optimization techniques
• Implementation experience with ETL concepts and tools such as: Oracle Warehouse Builder, Informatica, DataStage, and ab Initio
• Implementation experience with one or more of the following BI/Enterprise Reporting tools: Oracle Discoverer, Business Objects, Cognos, Brio, and Microstrategy
• Possess strong communication and client management skills.
• Ability to effectively manage multiple projects simultaneously
• BS in Computer Science or equivalent experience in a relevant field
Responsibilities:
• Translate client user requirements into technical architecture vision and implementation plan• Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
• Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)
• Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)
• Oversight of tool evaluation and selection
• Hardware recommendations, sizing and configuration
• RDBMS installation, configuration and tuning
• Oversight and/or coordination of system testing phase
• Problem and issue resolution
• Mentoring and developing junior staff
• Participation in proposal development and client presentations
Deloitte is one of the leading professional services organizations in the United States, specializing in audit, tax, consulting and financial advisory services with clients in more than 20 industries. We provide powerful business solutions to some of the world’s most well-known and respected companies, including more than 75 percent of the Fortune 100.
At Deloitte, you can have a rewarding career on every level. In addition to challenging and meaningful work, you’ll have the chance to give back to your community, make a positive impact on the environment, participate in a range of diversity and inclusion initiatives, and find the support, coaching, and training it takes to advance your career. Our commitment to individual choice lets you customize aspects of your career path, your educational opportunities and your benefits. And our culture of innovation means your ideas on how to improve our business and your clients’ will be heard.
Visit www.deloitte.com/us/careers to learn more about our culture, benefits and opportunities.
About Deloitte
As used in this document, “Deloitte” means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/ about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Deloitte LLP and its subsidiaries are equal opportunity employers.
More On: http://careers.deloitte.com/jobs/eng-US/details/j/E12ROSCMGRRV123/data-warehouse-architect
Thank you for the nice article here. Really nice and keep update to explore more ideas.
ReplyDeleteBig Data Testing Services