Data Engineer

Campfire LLC • Seattle, WA

6h • $60,000 - $120,000

About The Position

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

• 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

Nice To Haves

• 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)

Responsibilities

• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed