Data Engineer, Business Intelligence

| Greater NYC Area
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Foursquare is the leading independent location technology company, powered by our deep understanding of how people move throughout the world. Our solutions help businesses make smarter decisions, developers create more engaging experiences, and brands build more effective marketing strategies.

Foursquare’s platform includes Attribution, Audience, Proximity, Places, Pilgrim SDK and Visits. As the industry’s first and only accredited company for location data from the Media Rating Council (MRC), this foundation powers all our solutions — those that exist today and those we have yet to build. Over 14 billion consumer-verified place visit confirmations help us keep our map and models fresh and up-to-date, building a phone’s-eye-view of the world with 105 million unique places of interest worldwide.

About the team: 

The BI team is responsible for integrating, synthesizing and interpreting critical business data. We provide support to the business by creating sophisticated reporting tools that the business can use on data-driven decisions and we deliver deep dive analysis to measure results of actions that we have taken or to answer challenging business questions.

About the role:

You are passionate about using your programming, and data wrangling expertise to create data tools that will help the analytics team answer product and business decisions questions. You are an excellent communicator that will provide thought leadership on metrics, features, and products to teams across the company. You have strong engineering experience and enjoy working in a rapidly changing environment. And most of all: you ship. 

Responsibilities of the role:

  • Creating and maintaining data pipelines using Python 
  • Creating and maintaining frameworks for data ingestion
  • Write and tune SQL and other types of queries to support internal customer requests
  • Design, develop and test ETL, and ELT data workflows from a variety of big and small data sources.
  • Work closely with a range of stakeholders and team members to understand and finalize their business requirements for reporting and data aggregations
  • Design, develop and maintain analytical databases based on business requirements
  • Perform hands on implementation and maintenance of production ETL processes.
  • Support ad-hoc data analysis requests
  • Audit quality and repair data from data sources for accuracy 

Qualifications:

  • 3+ years of industry experience maintaining production data warehouse and ETL pipelines and using data analytics to solve business problems
  • 3+ years of experience in Python
  • Deep knowledge and hands-on experience with SQL
  • Understanding of database structure, design, theories and principles
  • Experience in Cloud environments
  • Able to rapidly learn new processes/subject areas
  • Willingness and ability to wrangle messy data
  • Degree in Computer Science preferred
  • Experience working independently solving a variety of business problems.
  • Good communication skills.

Nice to have:

  • Experience with Datorama and Tableau visualization tools
  • Experience with MPP databases
  • Experience in pyspark is a plus

Foursquare is proud to foster an inclusive environment that is free from discrimination. We strongly believe in order to build the best products, we need a diversity of perspectives and backgrounds. This leads to a more delightful experience for our users and team members. We value listening to every voice and we encourage everyone to come be a part of building a company and products we love.

Foursquare is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected Veteran status, or any other characteristic protected by law.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • ReactLibraries
    • ReduxLibraries
    • HBaseDatabases
    • HiveDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • ConfluenceManagement
    • JIRAManagement
    • SalesforceCRM
    • MarketoLead Gen

Location

Our office is located in Flatiron, a central neighborhood in Manhattan with numerous trendy restaurants, shops, and workout studios!

An Insider's view of Foursquare

What are some social events your company does?

We have a strong history of fun events in our offices like an annual talent show and outside trips such as sporting events! Since going remote, there have been awesome monthly curated events such as terrarium making and Japanese water marbling classes. Not to mention all the fun competitions for big prizes that happen in between!

Garrick

Operations Manager

What projects are you most excited about?

Foursquare's working with the best location intelligence data in the industry and we're putting together the sorts of tooling that our customers are going to love! I can't divulge exactly what we're working on yet, but it’s going to be exciting.

Javier

Senior Sales Engineer

How does the company support your career growth?

I'm continuously encouraged to connect with colleagues across different teams to discover new opportunities and explore those that interest me. I also appreciate having recurring 1:1 discussions with my manager about what's happening with the company at large and how I can set myself up for success and continuous growth throughout my career.

Emily

Senior Account Manager

How do you empower your team to be more creative?

Creativity most often come from spending time with our customers, and thinking about how we as a business can solve their problems. So I encourage my team to maniacally focus on solving our customer's problems. And out of that type of focus comes new product ideas, new features and ultimately bigger and more interesting client relationships.

Jim

SVP, Client + Partner Solutions

What are Foursquare Perks + Benefits

Foursquare Benefits Overview

Learning and development programs from ICs to managers

Individual, professional coaching for all full-time employees

Flexible time off - rest and recharge when you need it!

Comprehensive and competitive health, vision, dental, life insurance

401(k) with company match

Home office setup: you get all necessary hardware and internet reimbursement

Family planning programs via Carrot and Maven

Employee Resource Groups to help you stay connected

And much more!

Culture
Friends outside of work
Eat lunch together
Intracompany committees
Team based strategic planning
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available

Additional Perks + Benefits

Full coverage for medical, dental, and vision insurance · Flexible vacation and sick days · Competitive salaries and equity packages · Discounted gym memberships and $50/month gym reimbursement · Subsidized dinner every night, delicious catered lunches, and tons of fattening snacks

More Jobs at Foursquare64 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Content
Sales
new
New York
Sales
new
New York
Data + Analytics
new
New York
Content
new
New York
Data + Analytics
new
New York
Developer
new
New York
Sales
new
New York
Marketing
new
New York
Internships
new
New York
Developer
new
New York
Developer
new
New York
Sales
new
New York
HR + Recruiting
new
New York
Developer
new
Remote
Finance
new
New York
Developer
new
Remote
Developer
new
Remote
Sales
new
New York
Operations
new
New York
Sales
new
New York
Product
new
New York
Design + UX
new
New York
Developer
new
New York
Sales
new
New York
Marketing
new
New York
Project Mgmt
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Sales
new
New York
Data + Analytics
new
New York
Developer
new
New York
Developer
new
New York
Project Mgmt
new
New York
Design + UX
new
New York
Developer
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Sales
new
New York
Developer
new
New York
Product
new
New York
Developer
new
New York
HR + Recruiting
new
New York
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Foursquare's full profileSee more Foursquare jobs