BI Data Engineer
- San Francisco, CA
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.
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.
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
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)
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
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.