Data Architect

| Greater NYC Area

Data Architect

Squarespace is looking for hands-on Data Architect to join the newly created Data Integrity organization. As a member of this new organization you will engage with business and technology SMEs to develop practical, robust and Agile Data Architecture to support fast changing requirements. You’ll be a point of contact for Data related projects and promote how Data can support the business strategic programs including the ownership and implementation of the data strategy.

You’ll partner with data engineers and data scientists, as well as Finance and Compliance, Marketing and Product Leads.

You’ll report to Data Integrity Lead. Position is located in New York City.

RESPONSIBILITIES

  • Candidates are expected to demonstrate the following skills/experience: hands-on skills in processing large datasets, familiarity with data structure, big-data concepts, cloud computing, open-source tools, and optimization techniques
  • Design unified metadata platform using existing products and homegrown tools
  • Design Instrumentation framework for various data pipelines to collect metadata and executes data controls
  • Design Master Data Management and Reference Data platform
  • Develop mapping documents that demonstrate data lineage
  • Create and revise data dictionaries and governance standards
  • Convert logical data models into working physical data models and document and maintain lineage between the two artifacts
  • Extensive architecture and design experience with complex applications across various data platforms (Relational, NoSQL, Big Data)
  • Conduct walkthroughs of the data models with different stakeholders

QUALIFICATIONS

  • Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
  • Working knowledge of data warehousing concepts and various design patterns. Data Vault design is a big plus
  • Knowledge of Agile development methodology and concepts
  • Hands-on experience implementing and tuning Data Stores and queries
  • Experience with three or more of the following technologies: Postgres, HDFS, Hive, Spark, Presto, MongoDB
  • Customer relationship management skills and the ability to support and promote teamwork


PERKS

  • Health insurance with 100% premium covere
  • Flexible vacation & paid time of
  • Up to 18 weeks of parental leav
  • Equity pla
  • 401(k) plan with employer matc
  • Free lunch and snack
  • Squarespace sends engineers to speak at and attend the most relevant and impactful conferences throughout the yea
  • Dog-friendly workplac
  • Education reimbursement

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 570 is headquartered in downtown New York City, with offices in Dublin and Portland. For more information, visit www.squarespace.com/about.

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

Technology we use

  • Engineering
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • SwiftLanguages
    • ReactLibraries
    • HadoopFrameworks
    • SparkFrameworks
    • 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

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Happy Hours
Pet Friendly
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
More Jobs at Squarespace65 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Content
Product
new
New York
Product
new
New York
Design + UX
new
New York
Operations
new
New York
Design + UX
new
New York
HR
new
New York
HR
new
New York
Finance
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Finance
new
New York
Content
new
New York
Data + Analytics
new
New York
Design + UX
new
New York
Design + UX
new
New York
HR
new
New York
Finance
new
New York
Project Mgmt
new
New York
Operations
new
New York
Marketing
new
New York
Data + Analytics
new
New York
Project Mgmt
new
New York
Marketing
new
New York
Data + Analytics
new
New York
Internships
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Design + UX
new
New York
Developer
new
New York
Internships
new
New York
Internships
new
New York
Data + Analytics
new
New York
Internships
new
New York
Marketing
new
New York