Data Analyst

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

At Flatfile, we believe that humans shouldn’t have to struggle to use the data that drives our work forwards. We create beautiful, human-centric experiences to remove the barriers between people and data. We’re automating every repetitive and painstaking process involved in teaching machines what data is and where it should go.

What do a grocery store, an early-stage e-commerce startup, and Fortune 500 insurance company all have in common? They are all Flatfile customers, for one.

Regardless of segment or geography, accessing usable data quickly is a baseline requirement for operating your business today. Flatfile serves as a crucial bridge between messy, 3rd party data and our customers’ systems. We call this data onboarding, and we view it as both a challenge and an opportunity to serve every company in the world.

Want to join us?

We're not just looking for someone to punch a clock. We crave your diverse perspective and your desire to solve the most unique challenges at the intersection of data and design. 

As an Analytics Engineer, and our second Data hire, you’ll play a critical role in building and scaling the reporting infrastructure that the organization relies upon, while simultaneously helping field complex analytics requests from the business. You’ll be half Data Engineer, half Senior Analyst. To be successful in this role you must have an eye for detail, an innate curiosity to discover the “why” behind whatever you see happening, strong SQL abilities, and a history of working with cross-functional business stakeholders. It’s not required, but we’d love it if you originally came from a non-technical background, and had firsthand experience of working in product, marketing, sales, CX, or some other similar role in an organization; the best data people are those who can empathize with their stakeholders!


You will...

  • Collaborate with stakeholders across the business to define and report on standardized metrics that measure the value of business activities
  • Define, build, and iterate on production-level data transformations to support stakeholders across data and BI applications
  • Build the foundation of data architecture at Flatfile and help us create a roadmap for future growth
  • Create documentation and testing to ensure that our data is accurate and easily understandable
  • Manage pre-configured data pipelines from Stitch, Segment, and Hightouch, and design custom pipelines as appropriate using Airflow
  • Research and implement new tools to enhance our data stack
  • Assist in fulfilling ad-hoc data requests from business stakeholders 
  • Enforce code quality by identifying and reducing tech debt, standardizing styles, and removing deprecated objects from code and downstream locations

What you'll need to be successful...

  • SQL: A high level of SQL wizardry, and comfort producing views and tables in BigQuery.
  • DBT: An advanced understanding of DBT’s functionality, and experience developing tests, incremental tables, snapshots, and generalized macros.
  • BI Tooling: Experience working in BI environments (e.g. Looker, Sisense, Tableau) 
  • Scoping information: An ability to autonomously work with stakeholders to understand their function-specific needs and convert those into data and reporting specifications
  • Python: A familiarity with writing python to query external APIs
  • Git: An understanding of pull requests, using version control, and committing code to a production environment.

In the next 6 months you will...

  • Own the data infrastructure for two of our most critical organizations, Finance and Marketing, and will be the go-to data person as both of these organizations expand their respective scopes and information needs. Build out the reporting infrastructure that allows the business to understand cashflow projections, customer churn, and ROAS in ever-increasing levels of sophistication.
  • Produce proactive insights for the business as you come to understand the nuances of our data and feel empowered to explore your burning curiosity.
  • Lead the charge on enforcing DBT best practices and discovering new tools to help us work more efficiently. Expand our use of DBT test functionality, develop an initial system for alerting stakeholders and monitoring data integrity, and advocate for new tooling that improves our workflows and improves data visibility / observability. 

Benefits

Our goal is to be the best remote company in the world. We take this very seriously and aim to treat every employee like a million-dollar hire.

We’re team-focused here: we look for great teammates (not just great individuals) and strive to be a place where you’re surrounded by the best people in your career, where we all make each other better.

What we offer . . .

* The best tools to do your work, including a Mac laptop and top-of-the-line hardware.
* Unlimited discretionary vacation, and recommend a minimum of 3 weeks
* Comprehensive healthcare plans (including Vision and Dental), with fully covered options for you and your dependents
* 24/7 access to a Health Advocate
* Free annual membership to One Medical in participating regions
* Short term disability insurance
* 12 weeks of paid parental leave
* 401k retirement plan, with 100% matching for up to 3% and a 50% match for the next 2%
* Equity options

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
    • JavascriptLanguages
    • SqlLanguages
    • TypescriptLanguages
    • ReactLibraries
    • Node.jsFrameworks
    • SparkFrameworks
    • NetlifyFrameworks
    • MongoDBDatabases
    • PostgreSQLDatabases
    • BigQueryDatabases

Location

We are a fully distributed business. From Downtown Denver to Midtown Atlanta, NYC to SF, our aim is to be the world's best remote company.

An Insider's view of Flatfile Inc.

What’s the vibe like in the office?

Flatfile is the most challenging workplace I've been able to be a part of so far, and I can happily say that it's entirely because of the interesting problems we get to solve, and has nothing to do with the excessively goodnatured people I've had the pleasure of working with every day. I love being surrounded by such curious coworkers!

Elizabeth

Customer Success Manager

What projects are you most excited about?

Our team has been hard at work for months on a new product called Flatfile Concierge. This has been super exciting for me to be apart of as the new product allows non-technical users to benefit from what we’ve worked on at Flatfile for nearly 2 years! We’ve built an entirely new experience for every day users!

David

Growth Marketer

How does the company support your career growth?

By allowing employees to fail and then try again. I've been at companies where I couldn't experiment or solve problems in a different way - not Flatfile. Professional development is also important and I've been encouraged to take classes and improve upon my skills in product management.

Randy

Product Designer

What is your vision for the company?

Our mission is crafted with "humans" ahead of "data" quite intentionally. We imagine a world where data, no matter how complex or messy, can be shared seamlessly with just the click of a button. By focusing on the person's experience, we intend to turn that dream into reality.

Eric

Co-founder, COO

What does your typical day look like?

An incredible thing about being at Flatfile is that one day I'm working with a CTO at a major healthcare company and the next I'm talking to a founder of a brand new company but both see the value that we provide. The work is challenging, interesting and always keeps me on the edge of my seat!

Dylan

Senior Sales Development Rep

What are Flatfile Inc. Perks + Benefits

Flatfile Inc. Benefits Overview

As a fully remote company, our vision is to create the best remote job in the world. This includes providing employees with top of the line hardware, a home office makeover, a remote office stipend, and more!

Culture
Open door policy
Team based strategic planning
Group brainstorming sessions
Diversity
Unconscious bias training
Diversity manifesto
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Professional Development Benefits
Job Training & Conferences
More Jobs at Flatfile Inc.10 open jobs
All Jobs
Data + Analytics
Dev + Engineer
HR + Recruiting
Marketing
Product
Project Mgmt
Sales
Project Mgmt
new
Denver
Sales
new
Denver
Data + Analytics
new
Denver
HR + Recruiting
new
Denver
Developer
new
Denver
Marketing
new
Denver
Product
new
Denver
Developer
new
Denver
Sales
new
Denver
HR + Recruiting
new
Denver
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Flatfile Inc.'s full profileSee more Flatfile Inc. jobs