Experience:
5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Posted:
6/6/2017
Job Category:
Information Services
See more jobs for students and recent grads who studied:
Meetings Data Management Specialist (Evanston, IL)
ZS Associates, Inc. | Evanston, Illinois
Tell Us More About Your Job Preferences
By telling us what you think of this job, we can help find jobs that match your interests. If you want to see more jobs like this, click on the smiley face. Or if this job isn't what you are looking for, click the frowny face. Learn More...

Follow This Company
Share

Job Description

 

ZS is the world’s largest consulting firm focused exclusively on improving business performance through sales and marketing consulting solutions, from customer insights and strategy to analytics, operations and technology. Together, we design and implement strategies that lead to greater market share, more competitive operations and increased use of today’s latest technologies. From 22 offices worldwide, ZS professionals draw on deep industry and domain expertise to deliver impact where it matters for clients. We are particularly known for our expertise in the pharmaceutical and health care sectors, yet work across a range of industries.

ZS' Business Technology group helps companies define and execute their technology strategy by designing, building and operating the business intelligence (BI), cloud, data management, dashboard and analytics capabilities that are at the core of sales and marketing operations.

The Meetings Intelligence Expertise Center (MIEC) supports implementation and fact-based evaluation of corporate meetings programs. MIEC team members develop supporting documents for meetings management proposals, provide expert project framework design and management advice to client-focused teams, and develop expertise within the broader ZS community through on-the-project training.

MEETINGS DATA MANAGEMENT SPECIALIST

We seek an experienced Meetings Data Management Specialist in our Evanston, IL office. The Meetings Data Management Specialist will be part of our Meetings Intelligence Expertise Center, both delivering projects as well as developing expertise within the broader ZS community.

Responsibilities:

  • Work as part of the Meetings Analytics Solution Area to build, modify and maintain core systems that perform data operations for our clients which includes:
    • Lead the implementation of clients to SQL Server core system.
    • Design and implement new client solutions;
    • Develop and support core data warehouse functions;
    • Develop databases, BI objects and data-driven software applications;
    • Maintain key integration data flows from our clients’ systems to our data warehouse;
    • Lead the transition of client projects from implementation to operations, including resolving data loading and transformation operational issues, detecting and diagnosing data services issues;
  • Work with client managers to provide business analyst services including:
    • Lead interactions with internal project managers during the design and development phase;
    • Develop functional descriptions, designs and mapping to SQL procedures, given understanding of systems of record and current data infrastructure;
    • Develop and lead functional and UAT testing, participate in unit test design;
    • Candidates should be able to completely own deliverables after a short ramp up time.

Qualifications:

  • Bachelor's/master's degree with specialization in engineering or other computer-related disciplines with strong record of academic achievement;
  • 7-10 years of relevant consulting industry experience working on small/medium-scale solution delivery engagements;
  • Strong knowledge of Excel (pivot tables, formulas, macros/VBA, table functions); Advanced MS Access skills and Tableau experience desirable;
  • Have an “application” view to conceptualize processes from end-to-end;
  • Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams;
  • Proven ability to work creatively and analytically in a problem-solving environment;
  • Ability to work within a virtual global team environment and contribute to the overall timely delivery of multiple projects;
  • Willingness to travel to other global offices as needed to work with client or other internal project teams. 

Technical Qualifications

  • Understand & develop stored procedures (SPROC’s) of medium to high complexity;
  • Write advanced TSQL report definitions;
  • Solid experience in database operations and/or data warehouses, particularly those based on SQL Server;
  • Experience building and deploying reports in SSRS;
  • Ability to quickly learn db structure, table layout and production processes;
  • Knowledge of database design, database tuning and implementation, index tuning, SQL programming including creating databases, tables, views, stored procedures, user defined functions, and triggers;
  • Working Knowledge of Team Foundation Server (build and release functions in TFS);
  • Windows .Net Applications in Visual Studio (build basic user interfaces (Windows Forms) to initiate and monitor processes, build and maintain ASPX pages for client facing applications).

ZS is a global consulting firm; English fluency is required, additional fluency in at least one European or Asian language is highly desired.

Candidates must possess work authorization for their intended country of employment. An on-line application, including a cover letter expressing interest is required to be considered.

ZS offers a competitive compensation package with salary and bonus incentives, complete medical/dental/life insurance programs and retirement benefits. We are an Equal Opportunity Employer.

NO AGENCY CALLS, PLEASE.

 

Connect with ZS on social media:

ZS has been recognized globally for its expertise in consulting and its flexible work environment. View ZS’s accolades.

 

#LI-PS1

About ZS Associates, Inc.

ZS Associates is a global management consulting firm specializing in sales and marketing strategy, operations and execution. Since our founding in 1983, ZS has been recognized around the world for our expertise in go-to-market and sales force strategies and our implementation capabilities. ZS helps companies achieve sales success by delivering both issue-specific solutions and large-scale business transformations. We focus on increasing sales for our clients, addressing a broad range of business issues in pursuit of that single goal. More than twenty years ago, ZS founders Andy Zoltners and Prabha Sinha, as professors, put their theories into practice with the creation of ZS. While we have strong academic roots, we're growing beyond them. We've expanded our industry focus, developed new product service areas and created new software tools to enable our services. One hallmark of ZS is our relationship with our clients. We partner with them, helping them make decisions about their business, and implementing change within their organizations. Our culture is unique, too. ZS is a place where excellence is the standard, teamwork is emphasized, and integrity is the norm.

This company profile was created by AfterCollege and is about ZS Associates, Inc.. This page is not endorsed by or affiliated with ZS Associates, Inc.. For questions regarding company profiles, please email: care@aftercollege.com.