Data Analyst

Dimensional Modeling, SQL, ETL, PL/PGSQL, SQL Queries, Data Warehouse Model, ETL, optimization, pl/sql, AWS, oracle, mysql
Full Time, Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

About the Role

Ideal candidates must be enthused about writing SQL, data problem solving and troubleshooting data integrity issues. They must be a quick learner and be self-starting. The role will require extensive hands-on experience with the SQL language, demonstrated understanding and experience with troubleshooting and fixing data issues.

The ideal candidate will first-rate attention to detail and the ability to work quickly and accurately under pressure.

By joining SoFi, you're joining a new kind of finance company based around speed, transparency, and alignment with our members’ interests. Our goal is to be the center of our members’ financial lives. We created student loan refinancing, addressing the biggest financial challenge this new generation has through a new approach to lending. We expanded into other types of loans, and then into insurance and wealth management with similarly inventive products. As the company has grown, we’ve been able to help more people with these tools.

 SoFi has achieved significant growth, with big plans ahead. In just the last year, we've more than doubled our member base (260,000 strong), doubled loan volume ($8 billion in 2016), and grown our team from under 200 people to more than 900. We're preparing to go global, with expansion to Australia and Canada planned this year. And we're well capitalized to power all this growth, having raised $1.9 billion in equity backing. But we'll only be able to continue this growth with great talent, and that includes you.

Desired Skills

SQL, Data Analysis

Key responsibilities include

  • Find and investigate data issues in the data warehouse

  • Write SQL to validate quality of existing data

  • Build out automated checks for data quality

  • Troubleshoot data inconsistency issues

  • Contribute to the success of the data warehouse by improving the standards of data integrity

  • Write SQL scripts to clean existing data

  • Help data analytics team in their querying and understanding of the Data Warehouse

  • Write SQL to produce reports for external investors

Requirements

  • Bachelor's degree (or equivalent work experience) and 1+ year data analyst experience.

  • Experience writing SQL against different database platforms

  • Demonstrated skills and experience in finding, investigating and resolving data quality issues

  • Self-motivated

  • Ability to bring new ideas and promote process improvement

Plusses

  • Experience with reporting systems such as Tableau.

  • Understanding of Data Warehouses and ETL

  • Knowledge of Python

  • Experience with PL/SQL or pl/pgsql

  • AWS

Personal Attributes of the Ideal Candidate Include

  • Ability to thrive in a fast-paced growing company.

  • Ability to drive a project from inception to completion.

  • Enthusiasm for solving challenging problems.

  • Team attitude: a willingness to roll up your sleeves, work with others and get stuff done.

Benefits

  • Catered lunches, a fully stocked kitchen, and subsidized gym membership.
  • Competitive salary packages and bonuses.
  • A flexible vacation policy allows you to truly relax and reboot. 
  • Comprehensive health, vision, dental, and life insurance as well as disability benefits.
  • 100% of health, vision, and dental premiums paid by SoFI for employees and their dependents. 
  • 401(k) and education on retirement planning. 
  • Tuition reimbursement on approved programs, up to $5,250 a year.
  • Monthly contribution to help you pay off your student loans.

Posted By

Eddy Lee

1 Letterman Dr Bldg A, Ste 4700 San Francisco, CA, 94129

Dice Id : 10522162S
Position Id : 963512
Have a Job? Post it

Similar Positions

Business Data Analyst
  • University Of Utah
  • Salt Lake City, UT
Business Intelligence Analyst
  • Apremis
  • Salt Lake City, UT
Analytics Consultant
  • Domo, Inc
  • American Fork, UT
Junior Business Analyst
  • U.S. Tech Solutions Inc.
  • South Jordan, UT
Client Success Operations Analyst
  • Qualtrics
  • Provo, UT
Business Analyst
  • Career Advancements, Inc.
  • Salt Lake City, UT
Sr. Data Engineer
  • Zions Bancorporation
  • Salt Lake City, UT
Partner Analyst
  • Overstock.com
  • Salt Lake City, UT
Sr. Healthcare Business Analyst
  • CNSI
  • Salt Lake City, UT
Revenue Intelligence Analyst
  • Instructure
  • Salt Lake City, UT
Artificial Intelligence Engineer
  • Digital Harbor
  • American Fork, UT