Storyblocks

Analytics Engineer

Storyblocks

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $136,000 - $152,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AirflowAmazon RedshiftBigQueryCloudETLSQL

About the role

  • Write and maintain dbt models.
  • Debug tricky SQL logic.
  • Work with the Data team in a highly collaborative environment.
  • Translate ambiguous business requirements into dependable datasets.
  • Build logical data models and automated data quality checks.
  • Partner with data engineers, analysts, and stakeholders to ensure data is accurate and actionable.
  • Create and maintain thorough documentation of data models and analytical processes.
  • Advocate for best practices in data modeling, data governance, analysis methodologies, and model testing.

Requirements

  • 5+ years of experience in analytics, data science, or equivalent analytical functions.
  • Advanced proficiency in SQL, including concepts such as window functions, CTEs, and User-Defined Functions.
  • Hands-on experience with dbt or an equivalent tool.
  • Experience with data warehousing platforms and tools like Databricks, Snowflake, BigQuery, or Redshift.
  • A good understanding of Git and version control.
  • A collaborative mindset with the ability to work effectively alongside data engineers, analysts, and business teams.
  • Strong analytical skills with comfort in exploratory and descriptive data analysis.
  • Experience integrating dbt into cloud-based data pipelines (Preferred).
  • Experience with data orchestration tools like Airflow or Dagster (Preferred).
  • Familiarity with reverse ETL using tools like Census or HighTouch (Preferred).
  • Understanding of data warehousing concepts and modern data architectures (Preferred).
Benefits
  • Competitive and fair compensation: We believe in fair pay--equal pay for equal work. For each title, we consistently apply competitive salary bands based on market data and benchmarks which are reviewed twice a year. What you’ve been paid before, fear of conflict, or willingness to negotiate does not play a part in determining your pay.
  • 401(k) retirement plan: We offer both a Traditional and Roth 401(k) with a company match.
  • Company-paid medical: Our medical, dental and vision premiums are covered 100% for you and your dependents.
  • Paid parental leave: Welcoming new family members is exciting, but it can also be challenging. We offer twelve weeks paid leave for primary caregivers and four weeks for secondary caregivers.
  • Unlimited vacation: At Storyblocks, we believe in the importance of taking time off when you need it. Typically, employees take about three or four weeks each year. Plus, two company-wide week breaks in July and December.
  • Flexible work options: As a fully remote company, we’ve got you covered...
  • Company-sponsored mentorship and growth: We encourage attending virtual meetups and are happy to host them as well. We also have a leadership coach, on staff, available to all employees to enhance your professional development.
  • Employee perks: We help employees maintain work-life balance and honor their contributions to the organization by offering resources such as a financial wellness program, a subscription service that offers unlimited deliveries from thousands of eligible restaurants with $0 delivery, and a recognition and rewards program that celebrates their accomplishments.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLdbtdata modelingdata quality checksdata warehousingdata orchestrationreverse ETLexploratory data analysisdescriptive data analysisdata governance
Soft skills
collaborative mindsetanalytical skillscommunicationproblem-solvingstakeholder engagement