Spot & Tango is looking to drive data-driven decision making across the organization by creating and maintaining dbt models, dashboards, and other tools to support its personalized meal plans and e-commerce business
Requirements
- Strong proficiency in SQL
- Proficiency in using dbt for data modeling and transformation
- Experience with modern BI tools (e.g. Tableau, PowerBI, Looker, Sigma, Omni)
- Experience with data warehousing and pipelines and familiarity with cloud-based data platforms, esp. Google BigQuery and Fivetran
- Knowledge of Python and experience with Airflow is a plus
- Experience with Looker and Omni preferred
- Experience with e-commerce businesses is highly preferred
Responsibilities
- Data Modeling and Transformation: Collaborate with stakeholders to understand their analytical needs and translate these requirements into well-structured data models using dbt
- BI Development: Develop Omni views and topics, allowing stakeholders to build dashboards, reports, and data visualizations
- Pipeline and Model Maintenance: Monitor our pipeline and data model refresh jobs and triage issues if jobs fail
- Leadership: Be a thought partner / mentor, and provide feedback to support team development
- Cross-Functional Collaboration: Partner with business and tech teams to identify data needs, translate business requirements into technical solutions, provide timeline expectations, and deliver actionable insights
- Cost and Performance Monitoring: Keep tabs on BigQuery, Fivetran, and other key vendor spending levels, ensuring optimized use of Data Team resources
- Documentation: Document dbt models, Omni views/explores, and analytics queries to facilitate knowledge sharing and maintain an organized and accessible data ecosystem
Other
- Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, or a related field strongly preferred
- Proven experience as a Data/Analytics Engineer with at least 3-4 years of experience in data modeling, business intelligence, and/or database management
- Previous experience as a manager is preferred, interest in management is a must
- Excellent communication skills with the ability to work collaboratively in a cross-functional team environment
- A self-motivated individual with a curiosity to stay updated with the latest trends, technologies, and best practices in data and analytics engineering
