Block is one company built from many blocks, all united by the same purpose of economic empowerment. The blocks that form our foundational teams — People, Finance, Counsel, Hardware, Information Security, Platform Infrastructure Engineering, and more — provide support and guidance at the corporate level. They work across business groups and around the globe, spanning time zones and disciplines to develop inclusive People policies, forecast finances, give legal counsel, safeguard systems, nurture new initiatives, and more. Every challenge creates possibilities, and we need different perspectives to see them all. Bring yours to Block.

As a Data Analyst, you’ll be supporting Square’s Finance & Strategy (F&S) teams. The primary focus of your job will be writing complex SQL queries to build out automated dashboards in a data visualization tool such as Looker or Tableau. The goal is that these dashboards will save the F&S team time on manual reporting while allowing them to garner insights from the data that they couldn't before.

You Will:

• Write SQL queries to support ad-hoc requests and interactive Looker dashboards that you will design, validating the data for accuracy in the process. Dashboards will be built to help our stakeholders garner insights and recommendations from the data, as well as saving time through automation.
• Interact with our F&S stakeholders directly, including providing updates on the progress of projects in weekly touchpoint meetings.
• Automate data feeds into spreadsheets to save F&S stakeholders time on manual reporting 
• Perform maintenance on existing dashboards, including, but not limited to, setting up and monitoring alerts in tools like Anomalo to ensure the data remains accurate (Block has the tools to automate reporting, but also has a very complex data ecosystem that makes maintenance necessary)

You Have:

• At least 4 years of experience in a data analytics, business intelligence, or data engineering capacity
• Highly skilled at SQL
  • Experience in SQL with window functions, case when statements, aggregations, and common table expressions (or “with statements”)
  • Expertise at validating data in SQL queries and debugging queries when data is not accurate or when queries won’t run
• Extensive experience building interactive dashboards in a data visualization platform such as Looker, Tableau, Power BI, Qlik, Mode, ThoughtSpot, etc. (experience with any data visualization platform is okay - Looker will be used primarily in this role, but can be trained if the candidate has experience with a comparable tool)
• Experience working directly with the end users of dashboards and reporting throughout the build process
• Experience with cloud based databases such as Snowflake, BigQuery, etc
• Skilled with spreadsheets (Microsoft Excel and/or Google Sheets)
• Strong communication skills

Nice to Have:

• Experience interpreting data and garnering insights and recommendations
• Experience with data quality and alerting tools like Anomalo, and/or experience dealing with problems caused by upstream datasources 
• Knowledge of finance and accounting basics, or experience analyzing financial data
• Experience creating ETLs using tools such as Airflow or using tools like FiveTran to feed data into databases

Technologies We Use:

• Reporting - Looker
• Data Warehouse - Snowflake, BigQuery
• Cloud Suites - AWS, GCP
• Data Integration & Scheduling - Fivetran, Airflow
• Version Control - GitHub

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.

Zone A: USD $114,200 - USD $139,000
Zone B: USD $106,200- USD $129,800
Zone C: USD $97,100 - USD $118,700
Zone D: USD $85,700 - USD $104,700

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. 

Full-time employee benefits include the following:

• Healthcare coverage (Medical, Vision and Dental insurance)
• Health Savings Account and Flexible Spending Account
• Retirement Plans including company match 
• Employee Stock Purchase Program
• Wellness programs, including access to mental health, 1:1 financial planners, and a monthly wellness allowance 
• Paid parental and caregiving leave
• Paid time off (including 12 paid holidays)
• Paid sick leave (1 hour per 26 hours worked (max 80 hours per calendar year to the extent legally permissible) for non-exempt employees and covered by our Flexible Time Off policy for exempt employees) 
• Learning and Development resources
• Paid Life insurance, AD&D, and disability benefits 
• Additional Perks such as WFH reimbursements and free access to caregiving, legal, and discounted resources 

These benefits are further detailed in Block's policies. This role is also eligible to participate in Block's equity plan subject to the terms of the applicable plans and policies, and may be eligible for a sign-on bonus. Sales roles may be eligible to participate in a commission plan subject to the terms of the applicable plans and policies. Pay and benefits are subject to change at any time, consistent with the terms of any applicable compensation or benefit plans.

US and Canada EEOC Statement

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 a proud equal opportunity employer. We work hard to evaluate all employees and job applicants consistently, without regard to race, color, religion, gender, national origin, age, disability, pregnancy, gender expression or identity, sexual orientation, citizenship, or any other legally protected class. 

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.

Additionally, we consider qualified applicants with criminal histories for employment on our team, and always assess candidates on an individualized basis.

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.