Data Integration Engineer

Social Finance (SoFi) is a finance company that offers a range of lending and wealth management services. The company primarily caters to early-stage professionals and offers variable and fixed rate parent, personal, and MBA loans, mortgage refinancing, and more. Based in San Francisco, California, the company was founded in April 2011.

We are seeking a Data Integration Engineer to work in a fast-paced and fun environment in our Helena office. Ideal candidates must be enthused about database development, be a quick learner and be self-starting. The role will require extensive hands-on experience with the SQL language, and a solid understanding of and background in data modeling concepts and techniques, including modeling for OLTP and Data Warehouse environments. The ideal candidate will have experience in all phases of the project development lifecycle, solid problem-solving and communication skills, and the ability to work quickly and accurately under pressure.

• Understand and interpret customer requirements and design solutions to meet those requirements
• Develop new entity relationship models, and modify existing schemas to assist the team in meeting customer requirements
• Write SQL queries to meet customer requirements and analyze/optimize queries written by other developers
• Create/maintain applications and dashboard reports
• Convert production data into a data warehouse model, and troubleshoot data inconsistency issues
• Maintain the security, data integrity, and availability of data in production environments
• Execute System and Integration Testing

Requirements

• Bachelor's degree (or equivalent work experience) and 3+ years related experience.
• Experience designing data models
• Experience implementing, and administering Oracle, Postgres, or MYSQL
• Experience analyzing and optimizing SQL
• Self-motivated
• Ability to bring new ideas and promote process improvement
• Experience in designing, implementing, and managing large databases, including tuning and performance enhancements

Plusses

• Experience with reporting systems such as Crystal or Birt.
• Java Development
• Experience with PL/SQL or plpgsql
• 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.

Desired Skills

NOSQL, PostgreSQL, MySQL.