Accenture LLP has multiple openings for the position of Data Warehousing And Business Intelligence Manager in Los Angeles, CA to design data warehousing/business intelligence solutions using Microsoft SQL server 2012/2014, SQL Server Integration Services (SSAS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and manage overall delivery. S/he will perform the following duties: manage overall project execution and coordination with project team members and stakeholders; participate in projects and release status meeting to update status, risks and issues; identify and point out potential issues/risks to be actioned/escalated; review business requirement documents/functional design documents to clarify requirements; prepare detailed estimate for assigned projects/release items; lead ETL (Extract, Transform and Load) Application Development and Integration Teams For Microsoft Business Intelligence Development; conduct technical reviews of design, code and other deliverables; support QA team in test data preparation and assembly/functional/regression observations; support user acceptance testing exhibit preparation along with BAs (Business Analysts); support compliance, regulatory or ad hoc data pulls and validations; ensure best practices are followed with respect to design, performance, automation and data reconciliation; support production migration planning, execution and post production validations; identify and act on opportunities to improve efficiency and pace within the team. This position requires domestic travel approximately 50% of an average work week.
This position requires at least a bachelor's degree, or its foreign equivalent, in Computer Science, Information Systems/Technology, or Engineering (any), plus 5 years of post-baccalaureate experience as A Data Warehousing and Business Intelligence Manager or a closely related position in the IT industry. The position must include the following professional experience: 5 years performing ETL (Extract Transform Load) implementation as well as Multidimensional Cube Reporting; 3 years creating Data Modeling (conceptual, logical and physical data models), Enterprise Data Warehouse Design, Datamart Design, Data Quality and Data Governance; 5 years extracting, cleansing and transferring the data from various data sources including SQL Server, DB2, Access, Excel, Csv, Flat Files along with analyzing business requirements to translate into technical specifications and provide technical design solutions; 4 years designing, developing and maintaining data analytics using report tools including SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), Excel; and 4 years leading and mentoring technical, cross functional teams across locations.