DETAILED RESPONSIBILITIES/DUTIES:

• Generate on-going statistical reports, data investigations, "what-if" modeling and sales analyses for Sr. Management to support critical decisions related to the overall company strategy.
  
• Analyze Distributor/Member metrics and prepare high level monthly and quarterly analysis to be used for summary highlights and commentaries for Senior Management containing insights on top and bottom markets.
  
• Develop logic, build from scratch and maintain Distributor/Member analytical reports (both ad-hoc and scheduled) using Excel, SQL Server, BI/Micro Strategy and/or Access programs.
  
• Support Key Metrics monthly/quarterly/yearly reporting processes and validation.
  
• Support the country managers with development and interpretation of market-specific analysis to identify and monitor performance metrics and trends in their countries.
  
• Develop programs, methodologies and tools to better forecast, execute and analyze wide range of Distributor/Member and business statistics.
  
• Create prototype reports to fulfill requested idea where the specification is largely unclear and will likely require a significant exploration of the data and numerous iterations of the report before the needs are met and can then be coded into a production report/analysis.
  
• Collaborates with IS and Business Intelligence team, in ongoing decisions regarding data collection, validation, methodology and integration of new functionalities.
  
• Optimize and improve efficiencies, quality, timeliness and sort out relevance of current routine reports and processes. Seek opportunities for automation or enhancement of existing methodologies.
  
• Participate in the projects supporting company strategic initiatives. The role may involve gathering business requirements, developing workflows, reporting, and working with the external teams on managing the deployment of the solutions.
  

REQUIRED QUALIFICATIONS:

Skills:

• Proficient knowledge of pivot tables, macros, editing VBA/SQL, v-lookup, queries, and report writing to analyze data and consolidate reports
  
• Strong SQL experience writing complex queries and table joins
  
• Proficiency with MS Excel, MS Word, Power Point and Access
  
• Strong analytical skills to evaluate, understand and interpret data from both internal and external perspective
  
• Must be able to communicate ideas and analysis results effectively both verbally and in writing to both analytical and non-analytical audience
  
• A proven track record for executing complex data extraction and analytical projects
  
• Must demonstrate an ability to recognize and define problems, understand business and system processes, collect data, establish facts, and draw valid conclusions
  
• Must be able to formulate and communicate questions to gather the necessary missing information to resolve a problem.
  
• Self-motivated with the ability to work both independently and in a team environment
  
• Goal oriented, multi-task projects, superior time management and organizational skills
  
• Able and willing to work in the fast pace environment with demanding deadlines
  

Experience:

• 4-6 years of experience in the functional areas of business analysis, financial analysis, statistical model development, and data mining and/or CRM (Customer Relationship Management) database analysis
  
• Strong knowledge and experience with T-SQL and the SQL Server Platform or PL/SQL
  
• Knowledge of Relational Models and Data Warehouse methodology
  
• Experience with Web based project management tools
  
• Experience with Business Intelligence applications such as MicroStragegy, Cognos, Tableau.
  

• BA/BS in Business, Economics Finance or related field
  

PREFERRED QUALIFICATIONS:

• Expert knowledge of Marketing Plan and business model
  
• Project Management background