PayPal

Data Engineer

PayPal

April 7, 2021

Scottsdale, AZ 85258, US


Who we are: Fueled by a fundamental belief that having access to financial services creates opportunity, PayPal (NASDAQ: PYPL) is committed to democratizing financial services and empowering people and businesses to join and thrive in the global economy. Our open digital payments platform gives PayPal’s 375 million active account holders the confidence to connect and transact in new and powerful ways, whether they are online, on a mobile device, in an app, or in person. Through a combination of technological innovation and strategic partnerships, PayPal creates better ways to manage and move money, and offers choice and flexibility when sending payments, paying or getting paid. Available in more than 200 markets around the world, the PayPal platform, including Braintree, Venmo and Xoom enables consumers and merchants to receive money in more than 100 currencies, withdraw funds in 56 currencies and hold balances in their PayPal accounts in 25 currencies.
Job Description Summary: Seeking data engineer candidate for PayPal's CTO business technology team that looks to optimize internal infrastructure and processes.
Job Description:
Position Overview
PayPal's mission to democratize financial services relies on platform & infrastructure that is fast, reliable and secure. That infrastructure must be managed thoughtfully, be able to handle organic and intermittent growth and stay within budget.
The Technology Business Management (TBM) team is a small results-driven group that focuses on enterprise efficiency from assets and applications, to operations and processes and is part of a larger organization that reports directly to the CTO.
The Efficiency-Showback program is one of key strategic programs for the org and is an expansion of the work we have done around efficiency in 2020. The program measures impact, provides accountability through cost transparency, and operational efficiencies of our physical technology infrastructure, thousands of applications used to run PayPal, and the processes that govern IT. The TBM team performs detailed analytics using data from multiple data sources / monitoring tools to identify inefficiencies and work within the organization to communicate / remediate them.
The team is rapidly growing its area of responsibilities and is seeking a multi-disciplined engineer who is strong in database engineering as well as solid software development skills. This person will develop and enhance the current data pipeline used to perform efficiency analytics, write and maintain integrations with other systems of record and help the team scale to become an enterprise-wide product.
We are looking for a candidate who is motivated to build solid, scalable platform capabilities, someone who likes to raise the bar with respect to code quality, testability and maintainability standards. Typical day to day involves working with your teammates on solution discussions, implement complex stored procedure logic, work on integration scripts as well as attend and actively participate in scrum ceremonies and have at least a little fun.
Core Duties
  • Work with the DB architect to create and maintain optimal data pipeline architecture
  • Assemble large, complex data sets that meet functional / non-functional business requirements
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Google ‘big data’ technologies
  • Build APIs that expose the data so customers can consume and integrate with our data
  • Evaluate large and complex queries / stored procedures and recommend changes to optimize performance
  • Assist with the expansion into public cloud cost transparency
  • Lead automation efforts leveraging innersource interaction models with other teams
  • Assist data analysts on our team with query development, statistical analysis, and data visualization as needed
  • Maintain technical documentation on stored procedures and ETL logic used to managed the database

Core Competencies
Core Behavioral Competencies
  • Strong written and verbal communication skills
  • Ability to write clear and concise communications
  • Ability to work effectively in a global team environment

Role Specific Behavioral Competencies
  • Ability to translate complex problems into simpler terms
  • Ability to work independently

Prerequisite Knowledge & Proficiencies
Must Have
  • Experience building and optimizing ETLs, data pipelines, architectures and data sets
  • Proficient in Microsoft SQL Server 2016 & 2019 Database Development (T-SQL), Data Analysis and Support.
  • Thorough understanding of RDBMS concepts and ability to write complex SQL queries, Stored procedures, Functions & triggers
  • Proficiency with python scripting language
  • Experience with Splunk and splunk query language
  • Experience Google Big Query and AWS redshift
  • Experience with No SQL / Hadoop
  • Demonstrated experience working with large data sets and a love for working with data
  • Understand or be keen to learn about REST API development and design
  • Very strong foundational knowledge in Object-Oriented Design Principles, Data Structures, Algorithms, and Software Engineering
  • Working knowledge of web technologies (such as HTTP, HTML/DOM, JavaScript, CSS, AJAX)
  • Experience with code repositories like Git/GitHub
  • Experience writing and maintaining technical documentation
  • Basic familiarity with MS Word, Excel & Visio knowledge needed
  • A constant desire to grow, learn, and explore new things

Nice to Have
  • Experience with SignalFX analytics platform
  • Experience with gimmel notebooks
  • Experience with some visualization tool (e.g. tableau or power BI)
  • Experience managing database upgrades / data migrations
  • Experience optimizing queries
  • Basic fundamentals of JAVA
  • Understanding of Angular and/or ReactJS

Experience & Education
  • 4-5 years working experience as a Data Engineer
  • 3+ years software development in front-end and/or back-end technologies
  • BS in computer science, Information systems or equivalent field, MS preferred

Examples of Specific Job Tasks/Accountabilities
  • Work with lead to define technical requirements and design for new tables, ETLs, integrations,
  • Perform development of new stored procedures, integrations, views etc as part of bi-weekly agile sprints
  • Maintain scheduled jobs and debug when necessary
  • Attended technical meetings with customers of the IT efficiency product so they can integrate with us to consume data
  • Attend daily status calls to track sprint progress
  • Create, update, maintain documentation on stored procedures, ETL logic, db schema etc.
  • Work with cross-functional teams to build and enhance automation workflows
  • Build / optimize queries needed by team as needed
  • Provide demos and code reviews when applicable
  • Track data quality / integrity issues with the db and report them

We're a purpose-driven company whose beliefs are the foundation for how we conduct business every day. We hold ourselves to our One Team Behaviors which demand that we hold the highest ethical standards, to empower an open and diverse workplace, and strive to treat everyone who is touched by our business with dignity and respect. Our employees challenge the status quo, ask questions, and find solutions. We want to break down barriers to financial empowerment. Join us as we change the way the world defines financial freedom.
PayPal provides equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, pregnancy, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, PayPal will provide reasonable accommodations for qualified individuals with disabilities.