Senior Data Engineer, Data Warehouse
Employee Applicant Privacy Notice
Who we are:
Shape a brighter financial future with us.
Together with our members, we’re changing the way people think about and interact with personal finance.
We’re a next-generation fintech company using innovative, mobile-first technology to help our 2+ million members reach their goals. The industry is going through an unprecedented transformation, and we’re at the forefront.
We’re proud to come to work every day knowing that what we do has a direct impact on people’s lives, with our core values guiding us every step of the way. Join us to invest in yourself, your career, and the financial world.
The Role
We are seeking a Data Engineer to join our Data Warehouse team and work in a fast-paced environment. Ideal candidates must be enthused about writing SQL and Python, solving complex data problems, data good modeling, as well as building automated data pipelines. They must be a quick learner, self-starting, and have the ability to maintain and build within a horizontal and vertical scaling data warehouse. The role will require extensive hands-on experience with handling data, demonstrated understanding and experience with troubleshooting and fixing data issues, as well as provisioning data pipelines and reports.
You’ll need to demonstrate first-rate attention to detail, and the ability to work quickly and accurately under pressure. You’ll need to be comfortable in developing ideas to solve problems, then executing on those ideas though deployment. In addition to the needed technical skills, the engineer will need strong verbal and written communication skills to interface with many areas of the business.
Responsibilities
- Contribute to the development and testing of our system and services
- Participate in shaping the technical architecture SoFi’s data
- Help translate product requirements into technical documents and solutions
- Generate ideas for new initiatives and technologies
- Mentor other engineers, support the technical culture, and help grow the team
- Communicate with project leads, product managers and software developers, and data consumers
- Develop scalable data models where complex data relationships exist
- Architect and maintain highly automated and scalable ETL/ELT data pipelines
- Provision, optimize, and maintain data feeds to external systems
- Write code to validate data quality and clean existing data
- Be part of an on call support rotation to support the Data Warehouse and it’s automated processes
- Troubleshoot data inconsistency issues
- Identify inefficiencies, optimize processes and data flows, as well as make recommendations for improvements
What You’ll Need
- Bachelor's degree in a technical field and 5+ years working experience working with automated scripting, data modeling, and data architecture
- 3+ years experience, ideally on a modern stack
- Our core stack is Snowflake / PostgreSQL / Python / SQL / GitLab / AWS / Airflow
- Expert at writing and optimizing SQL scripts
- Solid working knowledge of relational database platforms and cloud database platforms such as Snowflake, Redshift, or GCP
- Strong in Python and/or another data centric language
- Experience in AWS or other cloud data environments
- Understanding of the software development lifecycle process
- Skills and experience in finding, investigating, and resolving data quality issues
- Ability to work in a fast-paced environment, meet deadlines, and prioritize a workload
- Ability to bring new ideas and promote process improvement
- Strong business communication skills that can break down technical problems into business language for non-technical personnel
Nice to Have:
- Experience using business intelligence reporting tools (Tableau, Looker, etc.)
- Experience in docker
- Experience using kafka
- Experience scaling data architecture
- Experience integrating external data sources via API
- Interest in personal finance
Why you’ll love working here:
- Competitive salary packages and bonuses
- Comprehensive medical, dental, vision and life insurance benefits
- Generous vacation and holidays
- Paid parental leave for eligible employees
- 401(k) and education on retirement planning
- Tuition reimbursement on approved programs
- Monthly contribution up to $200 to help you pay off your student loans
- Great health & well-being benefits including: telehealth parental support, subsidized gym program
- Employer paid lunch program (except for remote employees)
- Fully stocked kitchen (snacks and drinks)
*These benefits are only applicable to full time employeesSoFi provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion (including religious dress and grooming practices), sex (including pregnancy, childbirth and related medical conditions, breastfeeding, and conditions related to breastfeeding), gender, gender identity, gender expression, national origin, ancestry, age (40 or over), physical or medical disability, medical condition, marital status, registered domestic partner status, sexual orientation, genetic information, military and/or veteran status, or any other basis prohibited by applicable state or federal law.Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.