BI Data Engineer

  • San Francisco, CA
  • Full-time

Company Description

We believe the economy is better when everyone has access. When everyone has room to grow. No one should be left out because the cost is too great or the technology too complex. We started with a little white credit card reader but haven’t stopped there. We’re empowering the independent electrician to send invoices, setting up the favorite food truck with a delivery option, helping the ice cream shop pay its employees, and giving the burgeoning coffee chain capital for a second, third, and fourth location. We’re here to help sellers of all sizes start, run, and grow their business—and helping them grow their business is good business for everyone.

Job Description

As a Business Intelligence Data Engineer, you will be partnering with Business Partnerships, Developers and F&S teams to architect, implement and manage Data Models and ETLs that will enable business partnership and developer API data. You are a self-starter and you are comfortable working cross-functionally with other teams across Square.

 

You will:

  • Partner with various stakeholders within Business Partnership, Developers and F&S teams to understand their priorities, identify the right data sets to work on, understand their data and reporting requirements, and translate them into definitions and technical specifications (PRD)

  • Be responsible for defining, developing and optimizing curated datasets and schemas with standardized metrics and definitions across the company

  • Develop, deploy and maintain ETL jobs and visualizations

  • Build tools that will help Business Partner Managers and Business Analysts on-board new partners

  • Work closely with technical partners in BI team on designing and developing robust data structures and highly reliable data pipelines

  • Troubleshoot technical issues with platforms, data discrepancies, alerts etc

  • Perform ad hoc analysis, insight requests, and data extractions to resolve critical business issues

Qualifications

You have:

  • 5+ years working experience in a successful data engineering or business intelligence team

  • Expert knowledge in data modeling concepts and implementation

  • Strong technical accomplishments in SQL, ETLs and data analysis

  • Hands on experience in processing extremely large data sets.

  • Strong business intuition and ability to understand complex business systems

  • Experience with Linux/OSX command line, version control software (git)

 

Even Better:

  • Familiarity with technologies such as Airflow

  • Experience with Snowflake database

  • Work experience with Python or any programming language

  • Experience with visualization technologies such as Looker

  • Knowledge of payment network transactional data

Additional Information

At Square, our purpose is to empower – within and outside of our walls. In order to build the best tools for the businesses and customers we support all over the world, we have to start at home with a workforce as diverse and empowered as our sellers. To this end, we take great care to evaluate all employees and job applicants equally, based on merit, competence, and qualifications. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any other characteristic protected by law. We encourage candidates from all backgrounds to apply and always consider qualified applicants with arrest and conviction records, in accordance with the San Francisco Fair Chance Ordinance. Applicants in need of special assistance or accommodation during the interview process or in accessing our website may contact us by sending an email to assistance(at)squareup.com. We will treat your request as confidentially as possible. In your email, please include your name and preferred method of contact, and we will respond as soon as possible.