Business Intelligence Systems Lead

| Greater NYC Area

We’re looking for a Business Intelligence Systems Lead who is passionate about crafting quality datasets and implementing business intelligence solutions. You will be joining an Analytics team which partners across the company, from Product and Marketing, to Growth and Customer Operations, to inform and guide decision making and strategy.


You are focused on impact and have expertise in designing, executing, and maintaining business intelligence and data-centric tooling in dynamic, product-focused organizations. In this role we expect you to take ownership of existing reporting tools and underlying data modeling. You will work with partners across the company to remove bottlenecks for data access by selecting, establishing, and evangelizing self-service tools across the org. You will set the direction to scale our analytics data infrastructure that enables both technical and non-technical partners to draw insights on current performance and make recommendations for improvements. 


You should demonstrate a collaborative work ethic, think in terms of solutions instead of tools, and take pride in elegant work products. You will work within the Analytics department and reporting to the Manager of Data Science Operations in Squarespace’s New York offices.

RESPONSIBILITIES

  • Architect and build efficient business data models, optimize technical performance of key ETLs, and troubleshoot issues
  • Write, QA and maintain/update SQL logic generating core data tables of Squarespace’s analytics databases, powering all business intelligence tooling
  • Work with the engineering team and vendors to implement ETL pipelines and data infrastructure improvements to meet our needs
  • Use business intelligence tools to create and manage reports, dashboards, and data sources that are critical for deriving insights about the business
  • Create and guide reporting best practices to ensure data and key metric standardization across the company
  • Promote business intelligence tooling and data, including documentation, assistance, and conducting training and onboarding
  • Collaborate with product and data owners to successfully implement and maintain corporate business intelligence and analytics platforms and tools
  • Monitor and evaluate the latest analytics technologies

QUALIFICATIONS

  • 5 or more years of experience in consumer technology focused on analytics architecture, data modeling, and dashboarding
  • Expertise in establishing self-service BI solutions
  • Expertise in data-centric project management, from planning to execution
  • Deep experience managing and configuring reporting platforms like Chartio, Looker, Tableau, etc.
  • Experience developing data models and databases at a nascent or scaling business
  • Strong competency with SQL
  • Exposure to scripting languages (Python preferred)
  • Familiarity with Postgres databases, Presto query engine, Airflow, and ETL pipeline design a plus

ABOUT SQUARESPACE

Squarespace makes beautiful products to help people with creative ideas succeed. By blending elegant design and sophisticated engineering, we empower millions of people from individuals and local artists to entrepreneurs shaping the world’s most iconic businesses to share their stories with the world. Squarespace’s team of more than 950 is headquartered in downtown New York City, with offices in Dublin and Portland. For more information, visit www.squarespace.com/about.

PERKS 
  • Health insurance with 100% premium covered
  • Flexible vacation & paid time off
  • Equity plan
  • 401(k) plan with employer match
  • Free lunch and snacks
  • Dog-friendly workplace
  • And more

Today, more than a million people around the globe use Squarespace to share different perspectives and experiences with the world. Not only do we embrace and celebrate the diversity of our customer base, but we also strive for the same in our employees. At Squarespace, we are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

Read Full Job Description
Apply now
loading ...
Emailed

Technology we use

  • Engineering
    • C++Languages
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PHPLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • KubernetesFrameworks
    • DockerFrameworks
    • HiveDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedshiftDatabases
    • KafkaDatabases
    • PrestoDatabases

Location

Squarespace is headquartered in the West Village of Manhattan, within walking distance from the 1, A, C, E, B, D, F, and M trains.

An Insider's view of Squarespace

What are some social events your company does?

In the past we've had trivia nights, talent shows, and video game tournaments. My background is actually in theatre, so amazingly had the opportunity of taking to the microphone and hosting some of the events here.

Jose Paz

Community Manager

What kinds of technical challenges do you and your team face?

Our team’s mission is to configure, integrate, automate, and report on all HR systems. This means we are constantly trying to do things no one has ever done before. Some of the challenges we regularly encounter are hacking together system integrations, implementing controls to ensure data integrity, and manual task automation for our users.

Paul

People Tech Manager

How has your career grown since starting at the company?

As the Data Engineering team has grown, I've become a team lead and learning lots of new technologies, such as Postgres and Airflow.

Polina

Senior Software Engineer

What are some social events your company does?

The company holiday party is a pretty big social event. Each location has one and I’ve crashed three of the four parties in Ireland as well. At this point, if I don’t go to the Dublin holiday party, I might get messages asking if I’m okay.

Vishal

Team Lead, Product Support

What are Squarespace Perks + Benefits

Squarespace Benefits Overview

We take care of our employees in more ways than one. We offer competitive medical, dental, and vision for our employees and their dependents. We also offer up to 18 weeks of paid parental leave, daily gourmet lunches, and seasonal wellness programming, including meditation, yoga, and nutritionist sessions at the office. And so many snacks.

Culture
Eat lunch together
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Someone's primary function is managing the company's diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Happy Hours
Pet Friendly
Recreational Clubs
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Cross functional training encouraged
Online course subscriptions available
More Jobs at Squarespace61 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Content
Product
new
New York
Content
new
New York
Developer
new
New York
Data + Analytics
new
New York
Design + UX
new
New York
Project Mgmt
new
New York
Developer
new
New York
Product
new
New York
Data + Analytics
new
New York
Developer
new
New York
Finance
new
New York
Marketing
new
New York
Data + Analytics
new
New York
Operations
new
New York
Developer
new
New York
Operations
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
HR
new
New York
Finance
new
New York
Developer
new
New York
Design + UX
new
New York
Design + UX
new
New York
Design + UX
new
New York
Data + Analytics
new
New York
Operations
new
New York
Marketing
new
New York
Finance
new
New York
Data + Analytics
new
New York
Design + UX
new
New York
Finance
new
New York
Developer
new
New York
Product
new
New York
Developer
new
New York
Content
new
New York
Content
new
New York
Content
new
New York
Design + UX
new
New York
Design + UX
new
New York
Design + UX
new
New York
Design + UX
new
New York
Operations
new
New York