Senior Data Architect / Data Modeler at Double Good

Chicago, Illinois, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

TechnologyIndustries

Requirements

8+ years of experience in data modeling, with a strong focus on Kimball-style dimensional modeling
Deep understanding and hands-on experience with SCD2 (Slowly Changing Dimension Type 2) modeling
Experience with BI tools and a solid understanding of how data models drive business analytics
Proficiency in dbt, including implementation of macros, hooks, and custom tests
Advanced skills in Snowflake, including query optimization and use of advanced functions
Proficient with Git and comfortable working on the command line (preferably on Mac workstations)
Experience working in customer, order, manufacturing and shipping domains
Required technical stack: Snowflake, dbt, familiarity with BI tools, ERP
Preferred technical stack: Fivetran, Looker, Microsoft D365

Responsibilities

Design, implement, and maintain robust data models (star and snowflake schemas) for core business domains using Snowflake and dbt, ensuring our data platform supports diverse analytics needs across the organization
Engineer Slowly Changing Dimensions Type 2 (SCD2) data structures in dbt, ensuring high accuracy, lineage tracking, and consistency for evolving business attributes
Develop and maintain comprehensive Entity Relationship Diagrams (ERDs) for all data domains, using tools such as db_diagram.io
Write and optimize complex SQL queries to support analytical workflows, ensuring high performance and efficiency
Own and orchestrate data transformation activities, leveraging dbt to structure, document, and test data pipelines
Implement rigorous data quality checks and automated testing, upholding best practices for naming conventions, data types, data structures, and clear documentation
Ensure all logic adheres to established data architecture standards; actively participate in evolving and improving these frameworks with the team
Work closely with Analytics Engineers, BI Engineers, and business stakeholders to gather requirements, troubleshoot issues, and translate business needs into scalable technical solutions
Use Git for version control, contributing to collaborative and well-structured codebases; utilize command line tools to automate, monitor, and maintain the data modeling environment
Respond to issues as they arise and participate in resolution and troubleshooting based on priority

Skills

Snowflake

dbt

SQL

Star Schema

Snowflake Schema

SCD2

ERD

db_diagram.io

Query Optimization

Double Good

Gourmet popcorn production and fundraising platform

About Double Good

Double Good specializes in gourmet popcorn, offering 16 unique flavors that are handcrafted and made to order for freshness. The company operates primarily in the fundraising sector, partnering with schools, sports teams, and non-profits to help them raise money by selling its popcorn. Participants in these fundraising efforts earn 50% of the profits from each sale, with no minimum order requirements or fees, making it accessible for organizations of all sizes. This profit-sharing model not only supports community causes but also drives sales for Double Good. The company is based in Chicago and is known for its commitment to quality, providing popcorn that is free from preservatives. Double Good aims to provide an effective and straightforward fundraising solution while delivering a premium snacking experience.

Chicago, IllinoisHeadquarters

1998Year Founded

$2.3MTotal Funding

DEBT_GENERALCompany Stage

Food & Agriculture, Consumer GoodsIndustries

51-200Employees

Benefits

Health Insurance

Dental Insurance

Vision Insurance

401(k) Company Match

Paid Vacation

Paid Sick Leave

Paid Holidays

Risks

Increased competition from gourmet popcorn brands could dilute Double Good's market share.

Rising ingredient costs may impact Double Good's profit margins and pricing strategy.

Health-conscious trends could reduce demand for traditional gourmet popcorn offerings.

Differentiation

Double Good offers 16 unique, handcrafted popcorn flavors, setting it apart in the market.

The company provides a risk-free fundraising model with no minimum orders or fees.

Double Good combines gourmet snacks with a robust fundraising platform, appealing to various organizations.

Upsides

Double Good's online fundraising model is attractive in the post-pandemic virtual fundraising trend.

Growing consumer interest in gourmet foods aligns with Double Good's preservative-free popcorn offerings.

Cause-driven consumerism supports Double Good's fundraising model, enhancing brand appeal.

Land your dream remote job 3x faster with AI

Try Jobo Free