
Staff Data Engineer
Amplify
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $145,000 - $155,000 per year
Job Level
Lead
Tech Stack
AirflowETLPythonSQLTableau
About the role
- Work with data scientists, data analysts, data engineers, and software engineers to provide clean, accurate, reliable models and metrics for our products
- Architect data warehouse schemas and SQL transforms with just the right CTEs, window functions, and pivots
- Create data solutions using tools like Snowflake, Airflow, DBT, SQL, Python, Cube.dev
- Lead collaboration, pull request-ing, CI/CD processes, and mentoring on a cross-functional team
- Participate in cross-team share-outs, brownbags, and workshop series
- Become an expert in the data models and standards within Amplify to deliver quality and consistent solutions
Requirements
- BS in Computer Science, Data Science, or equivalent experience
- 8+ years of professional software development or data engineering experience
- 5+ years experience in computer, data, and analytics engineering
- Expertise in SQL and its use in code-based ETL frameworks, preferably dbt
- Expertise in ETL/ELT pipelines, analytical data modeling, aggregations, and metrics
- Expertise in dbt and git preferably with automation skills
- Expertise in analytical modeling architectures, including the Kimball design
- Strong communication skills in writing and conversation, including writing engineering training documentation
- Fluency in a development language such as Python (preferred)
- Familiarity with metadata management tools such as Atlan (preferred)
- 3+ years Experience building dashboards, reports, and models in business intelligence tools such as Tableau or Looker (preferred)
Benefits
- Competitive health insurance and mental health options
- 401(k) plan
- Basic life insurance
- Paid time off
- Parental leave
- Access to best-in-class development programs
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythonETLELTdata modelingaggregationsmetricsdbtgitanalytical modeling
Soft skills
communicationmentoringcollaborationdocumentation
Certifications
BS in Computer ScienceBS in Data Science