Data Analyst

Company: Study.com
Location: Mountain View
Posted on: November 22, 2021

Job Description:

Our mission is to make education accessible, and over the last two decades Study.com has become the leading online education platform delivering--a--personalized learning experience across a broad continuum of education for over 30 million students, instructors, and professionals every month. As a member of the Study.com team, you'll help empower millions of learners to achieve their education and career goals. We focus on increasing access to education because we know information is the ultimate equalizer and that education is key to upward mobility. Every minute a learner enrolls in a course and our College Accelerator solution. Study.com has collectively saved students $132 million in college tuition. You'll also be part of a company dedicated to contributing to society. Study.com has donated $23 million in-kind value across social impact programs, including matching employee contributions to non-profit organizations and millions to help schools during the pandemic. At Study.com, we know that strong communities are built on the power of our diversity and we respect and strive to understand for the diverse identities, race, ethnicities, backgrounds, and perspectives of our team members. And our work and company culture have been consistently recognized, including:

• Inc. Best Place to Work
• Fortune Great Places to Work - Best Workplaces in the Bay Area
• San Francisco Business Times & Silicon Valley Business Journal - Best Places to Work As an education technology leader, Study.com owes much of its success to its data driven approach. We help over thirty million learners and instructors on Study.com--each month, improving their user experience and driving growth by collecting,--storing and presenting massive amounts of data that are crucial to everyday business decisions. We're looking for a Data Analyst to join our growing team. The ideal candidate is--passionate about digging into data, understanding and explaining the stories the data tell as well as helping others solve problems, gain insights, and make smart decisions rooted in data. Additionally, our team built and maintains the entire data and ETL pipeline, so an inclination toward engineering is highly preferred. Come join us on our mission and make a difference. About the Data Analyst Position Responsibilities
  • As part of the Business Intelligence team, own and maintain the entire data warehouse, including 50 - 100 million events coming through a Kafka queue each day, a 15 TB relational data warehouse and an integration with Google Bi gQuery.
  • Work in a cross-functional team and be the team's point person for any data related tasks (ETLing new data, analysis, visualizations, etc.)
  • Monitor and analyze the team's A/B tests and proactively communicate key insights within your team and to external stakeholders.
  • Be the voice of data by supporting the team's product owner in finding business opportunities, defining KPIs, and setting team goals.
  • Actively establish processes and build tools to make data more accessible to everyone.
  • Use your knowledge of statistics to support the--Business Intelligence--team in--building and maintaining machine learning models (logistic regressions, neural networks, k-means clustering, etc.) that drive a significant portion of our revenue.
  • Help and teach others throughout the company to better use and understand our data.
  • Present findings and insights to teammates, stakeholders, and leadership. Requirements
    • A passion for learning and a willingness to pick up whatever you need to get the job done
    • 2+ years of experience in a data analyst role, experience with web analytics is a plus
    • Solid SQL experience (we use MySQL and BigQuery)
    • Strong analytical skills and ability to draw conclusions based on data
    • Comfortable working in a fast-paced, dynamic environment while juggling multiple projects
    • Solid experience in Excel for data analysis and visualization
    • BS in Mathematics, Statistics, Computer Science, Operations Research, or similar fields
    • Good interpersonal communication and presentation skills
    • Self-motivated, detail-oriented, and passionate
    • Some programming experience. We primarily use Java/Groovy and Python, with some legacy code written in R. Preferred Qualifications
      • Reporting and Business Intelligence experience (Tableau, Looker, QlikView, Microstrategy, etc)
      • Hands-on experience with advanced statistical concepts, such as cluster analysis, singular value decomposition, stochastic gradient descent, and Bayesian methods
      • Experience using an ETL tool (Pentaho, Talend, SSIS, etc.) on large datasets (terabytes in size)
      • Knowledge of web analytics software and best practices
      • Masters Degree or PhD Please Note: Our primary concern is for the health and well-being of our employees, as well as candidates. Given ongoing COVID concerns, new employees are being onboarded and working remotely. Once we return to the office, this position will be located in our office in Mountain View, CA. Study.com will be implementing a hybrid model that will include both in-office and remote work. In addition, Study.com will be requiring all employees be fully vaccinated as a condition of employment. If an accommodation is required, please speak with a member of the People Team. Life at Study.com At Study.com, you'll join an Agile team, making a big impact in a cross-functional, collaborative environment where team members wear different hats and regularly interact with senior leadership. We get things done and move quickly. Study.com's team members, together with our Study Studio network of instructors, tutors, subject matter experts, video animators, and editors, have developed 1.5 million learning resources on our platform. This includes micro-lessons, videos, flashcards, lesson plans, worksheets and more, fueling 16 million hours of learning engagement a year. We are in the heart of downtown Mountain View, just a few steps from the Caltrain station. And regardless if we are in the office or sheltered at home, we have comprehensive health and wellness benefits. We offer ongoing education and professional growth opportunities, including a life-long membership to Study.com. You can also expect:
        • 100% paid health, vision, and dental insurance for employees
        • 401(k) with employer match
        • 20 - 30 PTO days each year (increases with tenure)
        • 10 paid holidays
        • Work at home setup stipend
        • Company-sponsored gym memberships
        • Free Caltrain Pass
        • Tuition reimbursement and gift matching programs Study.com provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran or disability status. In addition to federal law requirements, Study.com complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.--Additionally, qualified applicants with arrest and conviction records will be considered for the position in accordance with applicable state and local laws. Consider the following tables:
          
          /* one row for every lesson on the site. Each lesson is part of a course. */
          CREATE TABLE lesson (
          lesson_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
          date_published datetime,
          course_id INT(11),
          name VARCHAR(255),
          subject VARCHAR(255),
          FOREIGN KEY (course_id) REFERENCES course (course_id)
          )
          
          /* one row for every course on the site */
          CREATE TABLE course (
          course_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
          date_published datetime,
          name VARCHAR(255),
          subject VARCHAR(255)
          )
          
          /* one row for every time a person views a page */
          CREATE TABLE page_view (
          page_view_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
          page_view_time NOT NULL datetime,
          session_id int(11) NOT NULL,
          url NOT NULL varchar(255),
          page_title varchar(255)
          lesson_id INT(11),
          course_id INT(11),
          FOREIGN KEY (lesson_id) REFERENCES lesson (lesson_id)
          FOREIGN KEY (course_id) REFERENCES course (course_id)
          )
          
          /* one rows for every session a user has on the site. A session generally spans several page_views */
          CREATE TABLE session (
          session_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
          session_start_time NOT NULL datetime,
          unique_user_id INT(11) NOT NULL /* This is a unique identifier of a user's device. Could be based on a long lasting cookie or derived from user agent + IP address */
          )
          
          Write a query to get name of the most popular (defined as has the most page_views) course.* Are you currently eligible to work in the US?* Will you need sponsorship in the future?* Upon returning to the office, this position will be located in Mountain View, CA. Will you be able to commute to Mountain View at least 3 days/week?* I understand that Study.com is mandating all employees to be vaccinated for Covid-19 as a condition of employment and will require proof of vaccination or request for accommodation by the 1st day of employment.* The following questions are entirely optional. To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more . Invitation for Job Applicants to Self-Identify as a U.S. Veteran
          • A "disabled veteran" is one of the following:
            • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
            • a person who was discharged or released from active duty because of a service-connected disability.
            • A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
            • An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
            • An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
              I AM NOT A PROTECTED VETERAN
              I DON'T WISH TO ANSWER Voluntary Self-Identification of Disability Voluntary Self-Identification of Disability Form CC-305
              OMB Control Number 1250-0005
              Expires 5/31/2023 Why are you being asked to complete this form? We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years. Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp . How do you know if you have a disability? You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:
              • Autism
              • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
              • Blind or low vision
              • Cancer
              • Cardiovascular or heart disease
              • Celiac disease
              • Cerebral palsy
              • Deaf or hard of hearing
              • Depression or anxiety
              • Diabetes
              • Epilepsy
              • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
              • Missing limbs or partially missing limbs
              • Nervous system condition for example, migraine headaches, Parkinson's disease, or Multiple sclerosis (MS)
              • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression Please check one of the boxes below: YES, I HAVE A DISABILITY, OR HAVE A HISTORY/RECORD OF HAVING A DISABILITY NO, I DON'T HAVE A DISABILITY, OR A HISTORY/RECORD OF HAVING A DISABILITY I DON'T WISH TO ANSWER PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete. Your Name Today's Date Human Check* I consent to be contacted over SMS/Text for this job.

Keywords: Study.com, Mountain View , Data Analyst, Professions , Mountain View, California