Job Description
Technical challenges excite you, and you enjoy finding simple and elegant solutions to complex problems. You care about quality, performance and time to production. You thrive in a highly collaborative, agile, open and honest work environment. You want to bring new ideas to the table, along with a plan to implement them. You want to help define the vision for the software that you will build, and you care about the business impact of your ideas.
The Data Engineer will be responsible for developing, tuning, and implementing data pipelines for our in house reporting solution by sending data to and from a Hadoop infrastructure. Deep knowledge of SQL, preferably on Hadoop/HBase (Hive, Impala, Phoenix), but large scale ETL scripting is acceptable. This person will work alongside the data architect and front end developer to surface data, metrics and insights by building and maintaining a fault tolerant data pipeline.
WHAT YOU’LL DO:
- Design and develop SQL ETL process and procedures for reporting needs
- Develop process to manage database DDL & DML changes in the Hive meta-catalog
- Design and deploy data table structures, forms, reports, and queries
- Develop automation to monitor existing ETL processes and maintain on time data processing
- Participate in the research and evaluation of new/additional software tools to assist database development
- Effectively communicate issues and concerns to appropriate parties
- Be responsible for continued development of Ripple’s Data API (https://data.ripple.com) which powers Ripple Charts (https://charts.ripple.com) and internal systems to analyze and annotate Ripple Consensus Ledger data
WHAT WE’RE LOOKING FOR:
- Advanced knowledge of SQL scripting and execution
- Proficient in database development for Oracle and MS-SQL
- Strong problem solving and analytical skills (performance analysis, defect analysis and reporting)
- Able to work effectively independently, and within a collaborative team oriented environment
- Strong written and communication skills; ability to articulate complex ideas clearly and effectively
- Organized and detail-oriented
BONUS POINTS IF YOU:
- Worked with financial exchange platforms and know how to visualize trading data
- Worked with Kafka/Storm streaming data ingestion systems
- Worked with HBase bulk data manipulation
WHAT WE OFFER:
- Competitive salary and equity
- 95% paid medical, dental & vision insurance for employees; 65% paid for employee dependents
- Generous Health & Wellness program
- Industry-leading maternity & paternity leave policies
- Flexible vacation policy- work with your manager to take time off when you need
- Modern penthouse facility with roof deck in San Francisco’s Financial District
- Fully-stocked kitchen with organic snacks, beverages and coffee drinks
- Bi-weekly lunches and optional gourmet dinners
- Monthly team outings to sports games, happy hours, game nights and more!
- A learning environment where you can dive deep into the latest technologies and make an impact
WHO WE ARE:
We provide global financial settlement solutions to ultimately enable the world to exchange value like it already exchanges information – giving rise to an Internet of Value (IoV). Ripple solutions lower the total cost of settlement by enabling banks to transact directly, without correspondent banks, and with real-time certainty of settlement. Banks around the world are partnering with Ripple to improve their cross-border payment offerings, and to join the growing, global network of financial institutions and market makers laying the foundation for the Internet of Value.
We’re backed by prominent investors like Google Ventures, Andreessen Horowitz, CME Group, Santander Bank and Seagate Technology. We’re headquartered in San Francisco’s Financial District with offices in New York and Sydney. As an industry advocate for the Internet of Value, Ripple sits on the Federal Reserve’s Faster Payments Task Force Steering Committee and co-chairs the W3C’s Web Payments Working Group.
