Staff Data Engineer, Public Web

Since we opened our doors in 2009, the world of commerce has evolved immensely, and so has Square. After enabling anyone to take payments and never miss a sale, we saw sellers stymied by disparate, outmoded products and tools that wouldn't work together.
So we expanded into software and started building integrated, omnichannel solutions - to help sellers sell online, manage inventory, offer buy now, pay later functionality through Afterpay, book appointments, engage loyal buyers, and hire and pay staff. Across it all, we've embedded financial services tools at the point of sale, so merchants can access a business loan and manage their cash flow in one place. Afterpay furthers our goal to provide omnichannel tools that unlock meaningful value and growth, enabling sellers to capture the next generation shopper, increase order sizes, and compete at a larger scale.
Today, we are a partner to sellers of all sizes - large, enterprise-scale businesses with complex operations, sellers just starting, as well as merchants who began selling with Square and have grown larger over time. As our sellers grow, so do our solutions. There is a massive opportunity in front of us. We're building a significant, meaningful, and lasting business, and we are helping sellers worldwide do the same.
Job Description
As a Data Engineer on the Marketing Data Engineering team, you will join an organization 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 web analytics 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 Marketing public web event data
• Collaborate with upstream engineering teams to ensure site events are instrumented and logged accurately
• Work closely with web analytics and SEO teams to translate stakeholder needs into ETL requirements
• Design, build and maintain critical data pipelines to ensure highly accurate and reliable business reporting
• Analyze new data sources and work with stakeholders to understand the impact of integrating new data into existing pipelines and models
• Participate in on-call rotation, monitor daily execution, diagnose and log issues, and fix business critical pipelines to ensure SLAs are met with internal stakeholders
• Assist the analytics team in interpreting data trends and identifying anomalies through querying and data analysis. Act as a liaison between business needs and ETL processes by resolving data discrepancies and implementing scalable solutions. Make data model and ETL code improvements to improve pipeline efficiency and data quality
• Build and own data import/export pipelines and incorporate into existing workflows to enable reporting and optimization efforts

You have:

• At least 8 years experience in data engineering or similar discipline supporting Web Analytics and Marketing organizations
• Expertise in SQL, especially within cloud-based data warehouses like Snowflake, Google BigQuery, and Amazon Redshift
• Experience designing medium-to-large data engineering solutions and responsible for the entire lifecycle of projects including scoping, design, development, testing, deployment, and documentation.
• Experience with ETL scheduling technologies with dependency checking, such as Airflow or Prefect, as well as schema design and dimensional data modeling
• Experience with Linux/OSX command line, version control software (git)
• Working experience with Python, REST API's, and Terraform
• Strong business intuition and ability to understand complex business systems, data architecture, and software design patterns
• Experience building real-time data pipelines or working with streaming applications using with Kafka or similar streaming technologies
• Excellent communication skills, particularly when explaining technical matters to less technical co-workers
• Experience with data visualization technologies such as Amplitude and Looker is a plus
• BS degree in Engineering, Computer Science, Math or a related technical field

We're working to build a more inclusive economy where our customers have equal access to opportunity, and we strive to live by these same values in building our workplace. Block is an equal opportunity employer evaluating all employees and job applicants without regard to identity or any legally protected class. We also consider qualified applicants with criminal histories for employment on our team, and always assess candidates on an individualized basis.
We believe in being fair, and are committed to an inclusive interview experience, including providing reasonable accommodations to disabled applicants throughout the recruitment process. We encourage applicants to share any needed accommodations with their recruiter, who will treat these requests as confidentially as possible. Want to learn more about what we're doing to build a workplace that is fair and square? Check out our I+D page .
Block will consider qualified applicants with arrest or conviction records for employment in accordance with state and local laws and "fair chance" ordinances.
Block takes a market-based approach to pay, and pay may vary depending on your location. U.S locations are categorized into one of four zones based on a cost of labor index for that geographic area. The successful candidate's starting pay will be determined based on job-related skills, experience, qualifications, work location, and market conditions. These ranges may be modified in the future.
To find a location's zone designation, please refer to this resource . If a location of interest is not listed, please speak with a recruiter for additional information.
Zone A:
$180,000 - $270,000 USD
Zone B:
$171,000 - $256,600 USD
Zone C:
$162,000 - $243,000 USD
Zone D:
$153,000 - $229,600 USD
Every benefit we offer is designed with one goal: empowering you to do the best work of your career while building the life you want. Check out benefits at Block.
Block, Inc. (NYSE: SQ) is a global technology company with a focus on financial services. Made up of Square, Cash App, Spiral, TIDAL, and TBD, we build tools to help more people access the economy. Square helps sellers run and grow their businesses with its integrated ecosystem of commerce solutions, business software, and banking services. With Cash App, anyone can easily send, spend, or invest their money in stocks or Bitcoin. Spiral (formerly Square Crypto) builds and funds free, open-source Bitcoin projects. Artists use TIDAL to help them succeed as entrepreneurs and connect more deeply with fans. TBD is building an open developer platform to make it easier to access Bitcoin and other blockchain technologies without having to go through an institution.