About the RoleWe are seeking a Senior Data Engineer to work in a fast-paced and fun environment in our Helena office.Ideal candidates must be enthused about Data Warehouse development, dimensional modeling and ETL.They must 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 dimensional modeling concepts and techniques.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.By joining SoFi, you ll become part of a forward-thinking technology company that is transforming financial services with innovative loan products and investment tools.Recently ranked as one of the fastest growing fintech companies in the Bay Area, we ve grown from 150 to 800+ employees in the past year and just raised a $1 Billion and $500 million round of funding.We offer the excitement of a rapidly growing startup with the stability of a seasoned management team.

Desired SkillsDimensional Modelling, SQL, ETL, pl/pgsql Key responsibilities includeUnderstand and interpret customer requirements and design solutions to meet those requirementsDevelop new dimensional data models, and modify existing schemas to assist the team in meeting customer requirementsOptimize SQL queries in current ETL processCreate and maintain existing ETL processesConvert production data into a Data Warehouse modelTroubleshoot data inconsistency issuesMaintain the security, data integrity, and availability of data in the Data WarehouseExecute System and Integration TestingImprove Data Warehouse automationHelp data analytics team in their querying and understanding of the Data WarehouseRequirementsBachelor's degree (or equivalent work experience) and 3+ year data warehouse related experience.Experience designing dimensional data modelsExperience in creating and maintaining ETL processesExperience analyzing and optimizing SQLSelf-motivatedAbility to bring new ideas and promote process improvementPlussesExperience with reporting systems such as Tableau.Experience implementing, and administering Oracle, Postgres, or MYSQLKnowledge of PythonExperience with PL/SQL or pl/pgsqlAWSExperience using an ETL toolPersonal Attributes of the Ideal Candidate IncludeAbility 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. BenefitsCatered 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.

Dimensional Modeling, SQL, ETL, PL/PGSQL, SQL Queries, Data Warehouse Model, ETL, optimization, pl/sql, AWS, oracle, mysql
Associated topics:
data analyst, data manager, data quality, data scientist, data warehouse, database administrator, etl, erp, sql, teradata

Read More

Copyright © 2017 Americanlisted.com, All Rights Reserved.
Designated trademarks and brands are the property of their respective owners.