Data Analyst Motley Fool
I can't believe it's been a month since I started as an analyst in The Motley Fool's Business Intelligence and Marketing teams. This place is even crazier than it sounded! I've heard the CEO of Honest Tea speak at the Fool, shaken hands with Vanguard founder Jack Bogle, and today had coffee with one of the Fool's co-founders. I?ve been to three happy hours, two impromptu barbecues on the balcony, and learned to like that Greek yogurt they keep in the fridge. That reminds me, I need to bring my gym bag for the in-office fitness class (and my Nerf guns to compete in the daily crossfire).
Anyway, back to today. Now that I?ve demonstrated my solid SQL skills and have learned my way around our data sets, I spent some time this morning exploring an intriguing trend in new users visiting Fool.com. I met with a few folks from the marketing team to share my findings, and everyone was super excited to learn more. We even spent some time brainstorming how to act on my findings with live tests on the site next week. So cool! I love the data-driven culture here.
I finished up a report that shows how our campaigns are performing over time and set it up to automatically refresh daily. This was hard to put together because the campaign metadata was coming from multiple systems. I?m out of practice with data warehousing and database administration, but the DW experts encouraged me to set up a feed to consolidate the data in our Data Warehouse, so I gave it a shot, and now other teams can use it, too. People have already been stopping by to ask about it.
Ginni also asked me about my analytics background, and she?s looking for some help with the data work for some predictive models we are developing for to help target the right members.. There are so many interesting projects. My career opportunities seem limitless here.
It?s great that the team has really let me get involved in a lot of the business and all sorts of reporting. It's pretty fun to get this random assortment of requests and to get to dig into the data to explain what's going on to these data-hungry Fools.
We?re looking for a data storyteller to join the Business Intelligence team. If you?re passionate about data, have a variety of technical skills, and could see yourself spending your day like the New Fool above, we want to hear from you!
The main responsibilities of the role include?
Understanding internal customers? goals and translating those into SQL queries and reports
Interpreting and communicating key metric trends as actionable, digestible insights
Building and modifying reports in Excel and MS SQL Server Reporting Services
Producing ad hoc analyses
Proactively identifying and executing on reporting and ad hoc analysis needs
Participating in predictive model development by preparing data sets, coordinating transfers and testing results
We?re looking for candidates who are?
Proficient with SQL
Proficient with Excel
Experienced with Data Analysis
Ideally candidates will have experience with some or all of the following?
Speaking marketing and business lingo and delivering relevant analysis to business clients
Microsoft SQL Server, MS SQL Server Reporting Services (or similar), and Power Pivot
Designing Tests and Analyzing Results for Direct Marketing
Web Analytics (Google Analytics, Adobe Insight, Site Catalyst, Discover)
Data Warehouse building, ETL, and SSIS
Familiarity with (or interest in) Predictive modeling
The Motley Fool, Inc. provides equal opportunity to all employees on the basis of individual performance and qualification without regard to race, sex, marital status, religion, color, age, national origin, non-job-related handicap or disability, sexual orientation, or other protected factor.
We should, however, make you aware that there is one notable exception to this policy. It is our strict and earnest intention ? and the company?s historical record will bear this out ? we will never hire any of the following: robots, replicants, or morlocks. Now keep in mind we are well aware that all of the aforementioned have intentions of world domination in the future, but as of now we have no place for them at The Motley Fool ? unless the year is 2122 and the revolution has already occurred. If that is the case we welcome our new robot, replicant, or morlock rulers!!! Perhaps we have said too much?
||2000 Duke Street |
Alexandria, VA 22314