ZS Associates - Solutions Delivery Consultant - Reporting

About ZS Associates :

- ZS Associates (http://www.zsassociates.com) is a global leader in marketing and sales consulting, outsourcing, technology and software. Since 1983, ZS has helped companies get the most out of their marketing and sales organizations. From 22 offices around the world, ZS experts use analytics and deep expertise to help companies across a range of industries (primarily pharmaceuticals and biotech, high tech/telecommunication, financial services, medical products/services, transportation and consumer packaged goods and energy) make smart decisions quickly and cost effectively.

About the ZS Associates, India Capability and Expertise Centers :

- ZS India Capability and Expertise Centers have more than 2000 people across two locations based in Pune and Gurgaon. Globally, over 60% of ZS people are based in the Capability & Expertise Centers. Our teams work in conjunction with onshore colleagues to deliver our marketing and sales projects to our clients.

- The Centers primarily support client projects based in North America, Europe and East Asia in the areas of Business Analytics, Business Operations and Business Technology.

Business Technology Group Overview :

- ZS Associates' Business Technology group focuses on strategizing, designing and building marketing and sales technology solutions to improve commercial effectiveness.

- The types of solutions include enterprise information management, reporting, analytics, CRM/SFA and business process automation enablement.

- We provide a complete spectrum of business technology solutions, from strategy and roadmap definition to full implementation and on-going operations.

- Our team possesses deep expertise in leading analytic, business intelligence, CRM and system integration technologies, which we apply in a pragmatic fashion to create and deliver optimal architecture and implementation solutions.

Job Description :

The person in this role will be one of the leads in designing, implementing, testing, and deploying of business intelligence solutions to meet sales and marketing business process requirements using Informatica, Business Objects and Oracle.

The candidate is also expected to :

- Manage the DataWarehouse Life Cycle for large scale sales and marketing data warehouses and reporting data marts.

- Manage the day to day delivery process across 1-2 client engagements helping to deliver world-class business and technology solutions.

- Provide leadership in logical/physical data modeling and solution design.

- Use best practices to design the datawarehouse (star schema), test plans, ETL, reports.

- Guide project teams in implementing solution design.

- Lead a team of 10-15 comprising of Associates and Associate Consultants.

- Set standards for application performance, operations, programming and security.

- Guide project teams in applying business rules and systems design

- Develop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards.

- Travel to US/Europe (as needed) to work with client and provide technology expertise to other ZS teams In addition, this person will help lead a firm-wide initiative in improving ZS IT capability for clients.

- Contribute to ZS IT capability building knowledge creation.

- Coach, mentor, and conduct training programs in data modeling, data warehousing, and other IT topics.

- Play active role in developing and growing the practice.

Qualifications : 7-10 years of hands on IT consulting work experience primarily focused on designing ETL and reporting modules, developing and deploying large scale data marts, data warehouses and reporting solutions. Additionally,

- A Bachelors degree in Computer Science or related field from a top university is preferred.

- Significant design and implementation experience in ETL

- Experience with the System Development Lifecycle (SDLC) process.

- Experience in architectural design, dimensional modeling (Star schema), ETL and data migration.

- Significant experience with performance tuning and optimization of applications.

- Experience with and knowledge of reporting tools like QlikView, Tableau, MicroStrategy

- Knowledge of current data modeling, and data warehouse concepts, issues, practices, methodologies, and trends.

- Significant experience with analyzing and troubleshooting the interaction between databases, operating systems, and applications.

- Ability to communicate clearly and effectively in oral and written form.

- Help with the selling process including writing proposals and giving product demos.

- Significant supervisory, coaching and hands-on project management skills.

- Ability to work within a virtual (off-shore) team environment and contribute to the overall timely delivery of multiple projects.

- Prior experience in sales and marketing data and SAS would be a plus