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)