About Our Organization

Campfire is an analytics collective specializing in digital data collection, synthesis, and activation. Analysts, marketers, engineers: together we're experts in architecting systems, operationalizing data, and driving insight. Our mission is to build sustainable analytics solutions for companies large and small - solutions that are flexible, scalable, and easy for your teams to maintain over time.

About The Role

At Campfire, a successful Data Engineer will be able to strike a balance between strategy and execution to ultimately deliver best-in-class client service.  We're looking for bright and curious individuals who thrive on solving complex data infrastructure challenges and building scalable solutions that power analytics. Our consultants are passionate self-starters who operate comfortably with ambiguity and can navigate complex challenges with minimal oversight.

• Partner directly with clients to understand business problem, project goal, and requirements both functional and technical
• Architect end-to-end solutions from ingestion, storage, prepping, and modeling to serve client needs
• Build scalable data pipelines programmatically using languages such as SQL, Python, or Spark, including extracting data using APIs
• Implement data structures using data modeling, ETL/ELT processes, and SQL technologies

Minimum Qualifications

• 2+ years of work experience with data warehousing, data modeling and building ETL pipelines using Python/C#/.NET
• 2+ years of work experience working with cloud-based technologies such as: Azure, AWS, or Google Cloud Platform
• 1+ years of work experience writing SQL queries across large datasets such as clickstream data (terabytes)
• 1+ years of experience working with data visualization tools such as Power BI, Tableau, or Looker
• On-the-job experience with version control systems (e.g., Git) and DevOps best practices

Preferred Qualifications

• Consulting and/or agency experience
• Familiarity with digital marketing concepts
• Hands-on experience working with digital media and clickstream/tapstream data
• Experience with distributed data/ cloud computing tools: Azure, AWS, Map/Reduce, MS Cosmos, Hadoop, Hive, Spark
• Experience with DAX and MDX (eg: Ranking, date changing, data transformations, relating data)

Our Compensation & Benefits

• Compensation: The base salary pay range for this position is $60,000 to $120,000, dependent on specific level of skills and work & industry experience. Full-time employees are eligible for the annual profit sharing bonus upon 3 months of employment, and may be eligible for discretionary bonuses.
• Benefits: Full-time employees are eligible for the below.
• Competitive Medical/Dental/Vision coverage: premiums for the employee are covered
• Group Life, Short- & Long-term Disability coverage: premiums for the employee are covered
• PTO (Paid Time Off): flexible vacation policy, recommended 15+ days per calendar year
• PSST (Paid Sick & Safe Time): flexible sick policy
• Holidays: 11 days per calendar year
• 401(K) match: 100% for the first 1%, then matches 50% up to another 5% (max 3.5% match on 6% contribution)
• Training Stipend: $400 per calendar year
• Ergonomics Stipend: $400 per calendar year