ServiceCore Logo

ServiceCore

Data Engineer

Posted 8 Days Ago
In-Office
Denver, CO
100K-140K Annually
Mid level
In-Office
Denver, CO
100K-140K Annually
Mid level
The Data Engineer will build and optimize data models in Snowflake, implement scalable ETL pipelines, and collaborate with cross-functional teams to enhance reporting and analytics capabilities.
The summary above was generated by AI

Data Engineer

Company Overview:

ServiceCore and Docket are rapidly-growing field-service Software as a Service platforms for the portable sanitation and dumpster industries, being named as the #80 fastest growing software companies in America by Inc. 5,000. The customers we serve have been underserved by software, making us the leading players in a huge industry with very little competition. Our software helps our incredibly hard-working business owners get more done and stress less. How? By supercharging their businesses with software that cuts wasted time, manages jobs, optimizes routes, tracks inventory, and automates billing. We are proud to offer a one-stop solution that allows our hard-working customers to be more productive and successful!

We live by our core values of Love Our Customers, Be Real, Give a Shit, Deliver Results and of course Keep it Fun. ServiceCore provides hard-working individuals the opportunity to work and grow within an agile, fast-paced start-up environment. We are proud of our accomplishments and take our jobs seriously while not taking ourselves too seriously.

Role Overview

ServiceCore is seeking a mid-level Data Engineer / Analytics Engineer to help build and scale our next-generation data models, semantic layer, and analytics foundation in Snowflake.

This role is ideal for someone who has 2-4 years of experience working with data warehouses, SQL, and modeling, and is ready to take the next step into modern data architecture. You’ll help design and build data marts for ServiceCore and Docket, support our embedded reporting layer (Sigma), and lay the groundwork for future AI and agentic data workflows.

You won’t be alone, this is a hands-on builder role with mentorship and technical guidance provided by senior members of the Data & Analytics team including a Senior Data Engineer. You’ll grow into owning portions of our semantic layer and bringing best practices in data modeling, documentation, and transformation.

What You’ll Do

  • Build, optimize, and maintain data models and data marts in Snowflake for ServiceCore and Docket
  • Develop the foundational semantic layer that powers embedded reporting, dashboards, and ultimately AI/agentic use cases
  • Implement scalable ELT/ETL pipelines, transformations, and data cleaning logic
  • Partner with Data & Analytics leadership to define the canonical metrics and modeling standards used across products
  • Work closely with Product, Engineering, and Customer Success to understand reporting use cases and map them to data models
  • Support the upstream data needs for Sigma dashboards, customer-facing reporting, and internal analytics
  • Develop and maintain clear documentation for tables, schemas, and transformations
  • Monitor Snowflake performance and costs; tune queries, warehouses, and models as needed
  • Contribute to testing, data quality checks, validation frameworks, and model observability
  • Participate in code reviews, pairing sessions, and ongoing improvements to our data stack
  • Help prepare the warehouse and semantic layer for future AI enablement, including structured outputs, embeddings-ready modeling, and feature tables
  • Collaborate in planning, roadmap discussions, and architectural decisions as your expertise grows

What We’re Looking For

Required

  • 2–4+ years of experience in data engineering, analytics engineering, BI engineering, or a similar role
  • Strong SQL skills, including writing performant queries and understanding joins, aggregations, and window functions
  • Proficiency in Python for data manipulation, automation scripts, and supporting ELT workflows
  • Experience modeling data in a data warehouse environment
  • Familiarity with common modeling approaches (star schema, snowflake schema, data marts, semantic modeling concepts)
  • Experience with at least one modern cloud data warehouse (Snowflake preferred; Redshift, BigQuery, or Synapse acceptable)
  • Experience building or maintaining ELT/ETL pipelines using any toolset (Terraform, dbt, Fivetran, Matillion, Airflow, SSIS, custom Python, etc.)
  • Familiarity with BI tools such as Sigma, Looker, Tableau, or PowerBI
  • Ability to break down unclear requirements into structured technical plans
  • Curiosity, ownership, and a willingness to learn—especially around newer domains like semantic layers and AI data readiness
  • Comfortable documenting, communicating, and collaborating with cross-functional teams

Nice-To-Have

  • Experience specifically with Snowflake (warehouse optimization, cost tuning, role-based access, etc.)
  • Experience with SQL-based transformation frameworks, such as dbt
  • Exposure to Terraform or cloud infrastructure-as-code
  • Familiarity specifically with data models and data sets in Sigma
  • Familiarity with embedded BI Tools and handling user parameters for row level security
  • Experience supporting embedded analytics or product-facing reporting workflows
  • Experience preparing data for ML, agentic systems, or retrieval-augmented generation (RAG)
  • Understanding of API-based data integrations, ingestion pipelines, and event-driven workflows

Work Environment:

  • Casual, open-office environment
  • Tuesdays and Wednesday in office for local employees (free parking!)
  • Fully stocked kitchen with fresh food and coffee at our Denver HQ
  • Hybrid and fully-remote work
  • Regular company events / outings

Salary & Benefits:

  • Base Salary: $100,000 - $140,000 (Dependent on Experience)
  • 14 Company Holidays in addition to Unlimited PTO 
  • Healthcare, dental and vision insurance with generous employer contributions
  • 401K w/ match
  • Equity Appreciation Plan (units granted upon hire)
  • Regular lunches and a fully-stocked kitchen (if in Denver)
  • Bi-weekly Grubhub lunch  stipend for remote folks
  • Company-provided hardware of your choice/configuration
  • A Strong Company Culture that Lives by Our Core Values - Love our Customers, Be Real, Give a Shit, Deliver Results, and Keep it Fun.

If you believe you match the above criteria and are desiring a dynamic start-up environment with a management team that is dedicated to your success, then please apply!

In addition to our commitment to equal pay for equal work, ServiceCore is also committed to equal opportunity regardless of race, color, age, ancestry, religion, gender, gender identity, genetic information, parental or pregnancy status, sexual orientation, marital status, citizenship, national origin, disability, or veteran status.

Location

Denver, CO (Hybrid) or Remote

Department

Engineering

Employment Type

Full-Time

Minimum Experience

This is an experienced role, not an entry level position

Compensation

$100,000 - $140,000 (Dependent on Experience)

Top Skills

Bi Tools
Elt/Etl
Python
Snowflake
SQL
HQ

ServiceCore Denver, Colorado, USA Office

3615 Delgany St, Denver, Colorado, United States, 80216

Similar Jobs

Yesterday
In-Office
Greenwood Village, CO, USA
67K-107K Annually
Junior
67K-107K Annually
Junior
Information Technology • Internet of Things • Mobile • On-Demand • Software
As a Data Developer I, you will assist in data architecture, automation, and troubleshooting, contributing to effective data solutions for organizational growth.
Top Skills: AlteryxCloud-Based InfrastructuresETLMicrostrategyPythonSQLTableau
5 Days Ago
In-Office
Denver, CO, USA
120K-150K Annually
Senior level
120K-150K Annually
Senior level
Information Technology • Machine Learning • Software • Conversational AI • Generative AI • Manufacturing
The Senior BI Data Engineer will focus on data modeling, transformation, and governance using Snowflake, collaborating with BI developers, and applying advanced analytics techniques to enhance outcomes.
Top Skills: AdfAirflowDbtMicrosoft FabricPower BIPythonSnowflakeSQLTableau
6 Days Ago
In-Office
Englewood, CO, USA
79K-140K Annually
Junior
79K-140K Annually
Junior
Information Technology • Internet of Things • Mobile • On-Demand • Software
The Data Developer III role involves implementing and enhancing data architecture, ensuring reliable data infrastructure, and troubleshooting data job failures with minimal supervision.
Top Skills: AlteryxJSONMicrostrategyPythonShell ScriptSQLTableau

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account