Business Intelligence Analysts
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
Click Here to complete our quick 5 minute interview questionnaire
Complete our Analyst Candidate Test (see bottom of page)
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
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
1-3 years of experience working in an analyst role
Proven understanding of Alteryx, Tableau, and other business intelligence tools
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):
Alteryx Software and workflow design
Tableau Software and interactive dashboard design
Excel and VBA programming
Programming languages such as Python, Perl, C, C++, Java
Web scraping/data extraction
Data mining and market research
Data blending and wrangling
Familiar with Mac and Windows OS
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
Ability to think way outside-the-box
Extremely proactive self starter that anticipates next tasks before it is
Desire to not work at a big, bureaucratic, slow moving company
Strategic and tactical thinker
Competitive Analytics offers highly competitive compensation (full time, part time, or contract) based on experience, talent, skill, expertise, knowledge, proven capabilities, and potential capabilities.
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, click here.
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 Analytics. Thank you in advance for your time and we look forward to hearing from you and reviewing your completed exercises.
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