Data Analyst at UpCounsel

Data Analyst

At UpCounsel we live and breathe data. Every department is collecting data and making data-driven decisions every day. We are looking for a very strong data analyst to turn data into insights, and insights into actions, driving UpCounsel's business in every way. You will be a key resource for the company and work directly with executives, engineers, operations, and everything in-between.

At UpCounsel, you will:

  • Partner with product, engineering, marketing, growth and operations teams to define goals and KPIs and build/maintain reports/dashboards to monitor the performance of our products and identify trends and opportunities.
  • Work closely with the executive team to build and maintain projections
  • Determine and quantify impact of product features and launches across the product.
  • Act as the liaison between analytics, product management, engineering, and business intelligence staff for websites and mobile product tracking implementations for various reporting systems.
  • Create complex SQL queries to perform data mining and exploratory analyses.
  • Facilitate experimentation and conduct experiment analysis
  • Develop and manage data analysis and forecasting methodologies needed to generate traffic and consumer usage forecasts.
  • Monitor data quality, investigate data issues and ensure issues are identified, documented, tracked, reported to and resolved in a timely matter.
  • Consistently identify best-suited data sources to serve business reporting needs.
  • Be a self-starter; proactively solve problems, identify opportunities for product growth and business value potential

You will be responsible for:

  • Drive business intelligence report design and development
  • Gather requirements and own KPI metric development and accuracy of data delivery
  • Take a lead on ad-hoc data analysis to validate business assumptions and deliver data driven decisions while avoiding analysis paralysis
  • Drive product analytics research design, development, and analysis to produce recommendations on improvements to product stakeholder
  • Utilize predictive analytics methods for forecasting and benchmarking business KPIs
  • Assist in auditing and architecting raw and post-processed data warehouse to generate maximum reporting value across multiple business units
  • Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment

An ideal candidate will have experience with:

  • 5+ years experience as a data analyst, preferably with experience in startups
  • Proficient in SQL (Redshift or PostgreSQL preferred)
  • Experienced with data visualization and BI software such as Looker, Tableau, or D3.js
  • Limited Experience with Programming (Python and/or Bash)
  • A strong passion for data, charts, process analysis, trends, and evangelizing data usage
  • A solid understanding of web technologies, relational databases, and data warehousing
  • Strong database experience, data analysis and analytical skills
  • Experience developing and modifying scripts in a Linux or Unix environment
  • Bonus: ETL skills to import 3rd-party data
  • Bonus: Advanced Statistical Skills (Prediction, Significance, Modeling, Recommendation Engines)
  • Bonus: Data Warehousing Skills
  • Bonus: Python, R, Stats Packages

Perks & Benefits

Health + Vision + Dental Insurance

Full medical, dental and vision to keep you healthy

Competitive salary + equity

Competitive salary & generous stock option package

401(k)

We encourage our team to be thinking about their future

Open vacation policy

We don’t track PTO - take the time that you need

Enjoy delicious meals

Enjoy lunch at the office

Flexible work hours

Flex your schedule to start and end work when is best for you

Commuter reimbursements

Get reimbursed for your public transportation costs each month

Customize your workstation

Build your workstation and desk to make it comfortable

Team Retreats

Quarterly off-site team retreats full of fun surprises and team inspiration

Games

When it comes to games, we know how to have fun! Foosball, Xbox, fantasy football, and more!

Great coffee 24/7

We're serious about getting quality coffee from throughout the world

We're in San Francisco