Business Intelligence Developer, Web
- 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 Web Data Engineer, you will join a newly formed team whose mandate is to build and maintain foundational data infrastructure essential to driving Square’s revenue growth and accelerating seller acquisition. You will work closely with marketing analytics, business intelligence, and platform engineering teams to build best-in-class data pipelines and processes that stitch together complex sets of data stores and drive large investment decisions. Your work will have a direct impact on hundreds of stakeholders at Square.
You Will:
Be the expert on end-to-end data flow for website data
Design, build and maintain critical data pipelines to ensure highly accurate and reliable business reporting
Monitor daily execution, diagnose and log issues, and fix business critical pipelines to ensure SLAs are met with internal stakeholders
Bridge gap between business requirements and ETL logic by troubleshooting data discrepancies and implementing scalable solutions
Make data model and ETL code improvements to improve pipeline efficiency and data quality
Own data import/export pipelines and incorporate into existing workflows to enable reporting and optimization efforts
Make underlying data architecture improvements and integrating new data sources
Qualifications
You Have:
2-4 years experience in a data engineering or business intelligence role supporting Marketing or Sales organizations
Expertise in SQL, especially within cloud-based data warehouses like Snowflake, Google BigQuery, and Amazon Redshift
Experience with collecting and processing event-level or web analytics data from sources like server logs, Google Analytics, and Adobe Analytics
Experience with ETL scheduling technologies with dependency checking, such as Airflow, as well as schema design and dimensional data modeling
Experience with Linux/OSX command line, version control software (git), and Python/Ruby
Strong business intuition and ability to understand complex business systems, data architecture, and software design patterns
Excellent communication skills, particularly when explaining technical matters to less technical co-workers
Experience with Tableau and Looker data visualization technologies is a plus
BS degree in Engineering, Computer Science, Math or a related technical field
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.