Key Facts

Remote From:

Oregon (USA), Washington (USA)

Full time

Mid-level (2-5 years)

60 - 120K yearly

English

Hard Skills

Other Skills

•
Consulting
•
Communication
•
Dealing With Ambiguity
•
Teamwork
•
Problem Solving

Roles & Responsibilities

2+ years of experience with data warehousing, data modeling, and building ETL pipelines using Python/C#/.NET
2+ years of experience with cloud-based technologies such as Azure, AWS, or Google Cloud Platform
1+ years of experience writing SQL queries across large datasets (e.g., clickstream data)
1+ years of experience with data visualization tools such as Power BI, Tableau, or Looker

Requirements:

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

Campfire Analytics

About Campfire Analytics

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. The "Campfire Rule" is to always leave a site in better condition than you found it. We do the same for every Campfire client, promising to end each project with your team better equipped to keep the fire going. This promise means we take a different approach than other analytics consulting firms. We teach through co-creation, build analytics programs with and for your teams, and provide documentation that will serve as a map when you’re ready to continue the journey on your own. We don't believe in vendor lock-in. We believe in enablement. In fact, that's the whole reason we started Campfire Analytics - to prove that a different business model is possible for a professional services company, one that develops capability instead of dependency. This vision extends beyond our service offering into the structure of our organization itself. Campfire Analytics practices holocracy, not hierarchy - because people are more than just the job they have. We share our profits with every employee, because it's the right thing to do. Every decision we make is guided by four simple principles: PEOPLE OVER PROFIT | PROGRESS OVER PERFECTION | HUMILITY OVER HEROICS | SUSTAINABILITY OVER SHORT-TERM GAIN "BE YOU. WITH US." As an organization built on inclusion, Campfire Analytics sees the value of diversity in action every day. We recognize differences, so that we can respect and empower individuals with every opportunity to advance their work. We believe that it is everyone's responsibility, individual or organization, to embrace diversity and inclusion in the workplace.

Company type: Startup

Founded: 2018

Company size: 11 - 50

Website LinkedIn See all jobs →

Job description

Description

About Our Organization

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.

Requirements

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