Summary

Competitive Analytics is avidly searching for extremely intelligent, detail-oriented, and proactive analysts, data scientists, and business intelligence analysts to join our team (and individuals wishing to grow into these roles). These positions require excellent interpersonal skills, strong speaking and writing skills, and very strong work ethic. This position reports directly to the Director of Analytics and will perform various tasks involving big data, advanced analytics, applied statistics, applied mathematics, interactive data visualization, programming, market analysis, and economic modeling tasks. Competitive Analytics is an innovative, high-tech, and dynamic working environment where analysts will work on a variety of advanced analytics, challenging client projects, and innovative business development initiatives . . . across all industries and spanning the entire business intelligence process. All analysts are required to work in our office (Costa Mesa, CA), with occasional field work and remote office opportunities possible.

Required Submittals for Consideration

  1. Cover letter
  2. Resume
  3. Click Here to complete our quick 5 minute interview questionnaire
  4. Complete our Analyst Candidate Test (see bottom of page)

Analyst Positions

Director of Analytics

8+ years of experience working in a senior analyst role

Thorough knowledge of Alteryx, Tableau, and other business intelligence tools

3-5+ years of experience managing other analysts

3-5+ years of experience with diagnosing, prescribing, planning, executing, and presenting large analytics and BI projects

Senior Analyst

3-5+ years of experience working in a senior analyst role

Advanced skills in Alteryx, Tableau, and other business intelligence tools

1-2 years of experience managing other analysts

1-2 years of experience with diagnosing, prescribing, planning, executing, and presenting small to medium analytics and BI projects

Analyst

1-3 years of experience working in an analyst role

Proven understanding of Alteryx, Tableau, and other business intelligence tools

Jr. Analyst

Entry level analyst position

Familiarity of Alteryx, Tableau, and other business intelligence tools (Experience and proven skills with BI software and tools is a plus)

Intern / Analyst in Training

Entry level, educational position

Ideal Experience and Expertise

(the following list of attributes, skills, and experience are ideal, yet not all required):

Technical:

Alteryx Software and workflow design

Tableau Software and interactive dashboard design

R

Excel and VBA programming

SQL programming

Programming languages such as Python, Perl, C, C++, Java

Database management

Data visualization

Web scraping/data extraction

Data mining and market research

Data blending and wrangling

Econometric modeling

Familiar with Mac and Windows OS

Non-Technical:

Passion for big data and advanced analytics

Exceedingly fast learning curve

Passion and tenacity to learn new skills and adapt to new challenges

Excellent communication skills, both written and verbal

Ability and tenacity to develop creative solutions to complex

problems

Ability to think way outside-the-box

Extremely proactive self starter that anticipates next tasks before it is

assigned

Desire to not work at a big, bureaucratic, slow moving company

Strategic and tactical thinker

Compensation

Competitive Analytics offers highly competitive compensation (full time, part time, or contract) based on experience, talent, skill, expertise, knowledge, proven capabilities, and potential capabilities.

Internship Opportunities

If you do not meet the experience and/or expertise required for this position yet are still highly motivated and passionate about this position, Competitive Analytics offers internship opportunities on a case by case basis. If interested, please inquire about our paid and unpaid internship programs.

About Competitive Analytics

From Fortune 100 companies to SMBs spanning myriad industries, Competitive Analytics helps the worlds most successful companies analyze their data and the competitive forces affecting them; with a customized business intelligence approach that addresses the challenges unique to each organization. Since our founding in January 2000, Competitive Analytics literally delivers “competitive analytics”. Competitive Analytics is an innovative, high-tech, and dynamic working environment where analysts work on a variety of advanced analytics, challenging client projects, and innovative business intelligence initiatives . . . across all industries and spanning the entire business intelligence process. For more information, please visit www.competitiveanalytics.com

Analyst Candidate Test

The following four exercises will help us gauge your level of analytics expertise and evaluate your level of analytical problem solving ability.  These exercises are based on the powerful software platform we use called Alteryx. Please follow the instructions below, and, after completing one or all four exercises, be prepared to share and describe the process you created in Alteryx to solve these use cases below. Partial solutions are acceptable as we are also gauging your proficiency in learning and explaining the core analytics technology we deploy here at Competitive AnalyticsThank you in advance for your time and we look forward to hearing from you and reviewing your completed exercises.

Instructions

First, download a free trial of Alteryx from the home page of our web site at www.competitiveanalytics.com. Tutorials can be found at http://www.alteryx.com/product-training.
Second, click here to access a Dropbox folder which contains four files, one for each exercise.
Finally, complete any or all four exercises.
————————
Exercise 1: Data Prep Qualtrics Survey Parsing
Objective: The data contained in the field: “DownloadData” needs to be parsed effectively for analysis. Please reshape the data from the Input (results from a download tool) and parse into a table for analytics.
Tools to Investigate: Text to Columns, Sample, Dynamic Rename
————————
Exercise 2: Spatial Trade Area Creation
The Customer File contains Total Sales and Total Visit Data to a Store.
The Customers visit the stores in the Store File.
Objective: Create a Convex Hull Trade Area that encapsulates 80% of the customer base who spend more than $10 and have had more than 1 visit for each store. The 80% should define the closest customers to the store location.
Question: For the 3 stores, what is the Area Sq Miles for each Trade Area?
Tools to Investigate: Join, Distance, Poly Build, Spatial Info
————————
Exercise 3: Preparing Sales Data for Visualization
A company would like to visualize their sales data in tableau. The source data contains monthly data for two months (Jan, Feb), two reporting types (customer count and revenue), and various classes of business (NB, NBEC, ECR, ECUR, Total).
Objective: This data needs to be transposed into a format that is easily visualized in Tableau.
Tools to Investigate: Filter, Multi-Row Formula, Transpose
————————
Exercise 4: Time Series Forecasting
A retailer would like to forecast how many units of a particular product will be purchased from their locations based on a historical trend.
The source data contains weekly data for 2012 and 2013 details how many units have been moved. Some of the data, however, is populated with NULL values. For the NULL values, please assign the monthly average. If the monthly average is also NULL, assigned the annual average.
Objective: Forecast how many units will be moved for the next 6 weeks.
Tools to Investigate: Formula, ARIMA, Summarize