Data Engineer

| Greater Boulder Area
Our Company:
PopSockets LLC, based in Boulder, Colorado, designs, manufactures and sells innovative lifestyle products. Our flagship product, the PopSockets grip, was invented by philosophy professor David Barnett, with the first grip sold on in 2014. We’ve since sold more than 200 million grips and expanded our portfolio to include a broad range of empowering, expressive, and fun products. We aim to build an Eternal Positivity Machine—an adaptable global brand that makes an increasing positive impact on the world every year.

The Role

PopSockets is looking for a Data Engineer/ Data Integration Engineer to guide both strategic architecture and day-to-day development of our Data Warehouse and the integration from internal and external data sources. Popsockets has implemented a DataWarehouse/DataLake on a SnowFlake database platform. The ETL’s have been developed with FiveTrans and Azure Data Factory. The DataWarehouse is typically used for Business Analytics using the Looker Platform. As the Data Engineer you will integrate new applications and data sources into the Data Warehouse Model. Our goal is to use this DataWarehouse to evolve from being able to provide insights as to what has happened, “descriptive” questions, to driving “predictive insight’, what is likely to happen, to ‘prescriptive directions'', what should we do to hit our goals. As the Data Engineer/ Data Integration Engineer your job is to develop code to ingest, transform and integrate data into our data warehouse. You will work closely with our Financial Planning and Accounting teams, Data Scientist and Business Analytics team to prepare structured and unstructured data for analytic modeling.


  • Engage directly with business analysts and end customers to participate in design and development of data integration/transformation solution according to functional requirements
  • Development of Extract-Transform-Load (ETL) logic to meet functional business requirements to support business intelligence needs using large, disparate data sets
  • Perform debugging, troubleshooting, modifications and unit testing of integration solutions
  • Support, monitor, execute production application jobs and processesParticipate in the development of documentation, technical procedures and user support guides
  • Promotion of code into the Test and Production environments
  • Management of the database environment working in concert with IT DBA resources
  • Monitoring daily job scheduling activities
  • Tracking usage and contracts for Fivetran and Snowflake resource usage and billing
  • Troubleshoot production issues, identifying root cause and implementing sound technical resolutions in a timely manner
  • Scale and optimize performance via schema design, query tuning, and index creation
  • Identify and document data sources, criteria, and data mapping.
  • Manage projects through to completion
  • Manage work through Agile tools/methodology, collaborative repositories, issue tracking platforms, and wikis


  • Strong SQL experienceIntegration of multiple data sources and databases into one system
  • Well-versed in structured and unstructured data with a proven track record of working with JSON and XML
  • Experience combining disparate data sources to facilitate cross platform analyses
  • Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
  • Drive to succeed and improve personally, and in ability to add value to the role, team, and company
  • Self-starter, relentlessly curious, resourceful, collaborative, and inventive
  • Good team player and communicator
  • Highly organized and meticulous
  • Positivity, and the desire to solve problems in elegant and creative ways

Our Ideal Candidate has

  • BS in Computer Science or equivalent experience or field
  • At least 2 years experience using Snowflake or a similar
  • Data WarehouseAt least 5 years experience programming, preferably with Python 
  • Hands-on experience with SQL, ETL, Data Warehousing and Data Orchestration
  • Familiarity with scheduling frameworkExperience with business intelligence/data modeling/ analytics tools like Tableau or Looker

Salary range: $80,000 to $90,000

PopSockets is dedicated to the practice of equal opportunity employment. We prohibit unlawful discrimination against applicants and employees on the basis of age, race, sex, sexual orientation, gender identity, religion, national origin, disability, military status, genetic information, color, creed, ancestry, or any other status protected by applicable federal, state or local law. This prohibition includes unlawful harassment based on any of these protected classes. Unlawful harassment includes verbal or physical conduct which has the purpose or effect of interfering with an individual’s work performance, or creating an intimidating, hostile, offensive, unsafe or otherwise non-welcoming work environment. This policy applies to all employees, including managers, supervisors, co-workers; and non-employees such as customers, clients, vendors, consultants, etc.

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
    • RubyLanguages
    • SqlLanguages
    • Ruby on RailsFrameworks
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • Power BIAnalytics
    • NAVAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • SolidWorksDesign
    • InDesignDesign
    • FigmaDesign
    • PremiereDesign
    • After EffectsDesign
    • Cinema 4DDesign
    • ProToolDesign
    • BasecampManagement
    • SmartsheetManagement
    • TrelloManagement
    • HubSpotCRM
    • KlayvioEmail


We're just outside Downtown Boulder (no traffic!) in a gorgeous, newly built and designed office with terrific mountain views!

An Insider's view of PopSockets LLC

How does your team reward individual success?

We have an internal bonus system that allows everyone to reward each other with points that you can then convert for real world rewards including everything from gift cards to your favorite stores, Amazon, discounted travel and more.


Sr. HR Manager

How do you collaborate with other teams in the company?

Our office is designed to foster collaboration. There are comfortable meeting areas around every corner, and an open office plan. Even a walk to grab some coffee often results in multiple, impromptu meetings. All of our conference rooms are equipped with huge screens that allow us to stay close with everyone offsite as well.


Lead Recruiter

How does the company support your career growth?

Because we're growing so quickly, you don't have to wait for a role to open above you to advance. We welcome new ideas and perspectives, and people are able to grow, develop and advance at their own rate. Want to expand your role? Tell us how!



How do you empower your team to be more creative?

We work very hard on recruiting in order to bring in passionate people with good ideas, and then let them run. You won't run into the excuse of "this is the way we've always done things". We want change, and growth and innovation, and trust in our people and their skills to get us there.


Associate Design Director

What are PopSockets LLC Perks + Benefits

PopSockets LLC Benefits Overview

Employees are valued at PopSockets. We provide a number of perks and benefits to show we care and are always looking for ways to do more for our employees. We provide a dog-friendly office, stocked with snacks and high end coffee and tea options. We have a fully stocked bar with a view of the mountains. We offer competitive benefits and 4 weeks of starting vacation time, in addition to time off each year for volunteer opportunities.

Volunteer in local community
PopSockets Employees are offered two paid volunteer days. Our Manager of DoGoods works directly with local nonprofits we can support as a company. Volunteer opportunities are coordinated quarterly.
Partners with Nonprofits
PopSockets partners with more than 100 nonprofits—large and small—through Poptivism, our unique give back program. Over the past three years, we have contributed more than $3 million to charity!
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Open office floor plan
Unconscious bias training
Diversity manifesto
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
PopSockets has a flexible spending account
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
We offer Cardio and Yoga classes three days per week!
Retirement & Stock Options Benefits
401(K) Matching
We contribute 3% of of an employee's annual gross pay to their 401K
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
We provide an option to create a dependent care account
Generous Parental Leave
We provide 12 weeks paid paternal leave for employees who have been here 6 months.
Flexible Work Schedule
PopSockets provides employees with a flexible work schedule that includes Flexible start and end times.
Family Medical Leave
Company sponsored family events
PopSockets sponsors family oriented events throughout the year.
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
We love our snacks at PopSockets. We also offer plenty of tea, coffee and beer on Tap. We also have our own Bevi machine!
Some Meals Provided
Bagles and Donuts every Wednesday and Breakfast burritos the last Friday of the month!
Happy Hours
Pet Friendly
Recreational Clubs
Softball, Soccer and more!
Fitness Subsidies
We offer thrive pass, $50 per month toward the wellness activity of your choice.
Professional Development Benefits
Tuition Reimbursement
Diversity Program
Lunch and learns
Promote from within
Customized development tracks
More Jobs at PopSockets LLC14 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Design + UX
Data + Analytics
Data + Analytics
Data + Analytics