Business Analyst I

Title: Business Analyst I

Duration: 6-month contract

Pay rate: $49.8/hour on W2 payroll

Location: Redwood City, CA

Overall responsibilities:

Drive the analysis behind key strategic initiatives, working cross-functionally with multiple business areas. Translate data into actionable insights, using SQL to extract and manipulate data, analyze it, and turn it into a compelling story. Work with a varying group of stakeholders to understand business problems and translate them into analytical requirements. Research and analyze key business drivers, trends, and operating metrics. Monitor key performance indicators for the business for executive performance reviews. Build and maintain critical data layers for use by the broader team. Build and maintain dashboards to support strategic pilot programs.

Please NOTE: Candidates with sales operations, business operations, consulting experience who are currently based in the Bay Area are highly preferred.

Top 3 daily responsibilities:

• Conduct strategic analysis, using SQL and Google Sheets. Must be able to write queries and understand complex data structures and the business problems associated with them.
• Meet with key stakeholders to understand business problems and review analysis.
• Build and maintain dashboards to support strategic pilot programs.

Skill/Experience/Education

Mandatory

• B.A. in a quantitative field (Econ, Stats, Engineering, Computer Science, etc.)
• Fluency in SQL, MS-Excel/Google Sheets
• 2+ years of analytical work experience in marketing and sales, management consulting, or in business operations and analytics environment
• Ability to multi-task, set priorities and work efficiently in a fast-paced environment

Desired

• 4+ years of analytical work experience
• Prior experience in a sales operations role
• Strong interpersonal skills and ability to work with cross-functional teams
• Powerpoint/Google Slides skills

Prescreen questions:

1. Please describe the difference between an INNER Join & and OUTER join in SQL *

2. Describe a project that was your most complicated application of SQL and/or data. *

If interested, please send your resume and your answers to the prescreen questions to alicia.jobs247@gmail.com