Data Ops Engineer - Retail SaaS (Snowflake, SQL, Alteryx)
At ShopGrok, data is at the heart of what we do. We are scaling rapidly and investing heavily in the efficiency and quality of our data delivery.
This role will be part of our Data Operations team that bridges the gap between raw data infrastructure and customer insights. Your primary focus will be on building and maintaining the semantic layer using Snowflake and Alteryx, and designing high-impact visualisations in Tableau. You will translate complex retail datasets into actionable intelligence, ensuring our customers receive accurate, timely, and structured data. While we are building out dedicated Customer Success resources to manage relationships, you will need a strong product mindset to understand how our clients consume our data.
Experience working with retail data is a strong plus.
What you’ll do:
- Collaborate with the Data Platform team to consume raw data and transform it into the semantic layer for reporting.
- Develop and maintain complex ETL workflows using Alteryx and Snowflake SQL.
- Design, build, and maintain Tableau dashboards that provide actionable insights for major retailers.
- Ensure data quality and integrity in client deliverables, proactively identifying anomalies before they reach the customer.
- Troubleshoot and resolve data discrepancies across the collection and reporting pipeline.
- Work with our core stack: Snowflake (SQL), Alteryx (ETL), and Tableau (Visualisation).
- Identify opportunities to automate manual "break-fix" tasks to improve team efficiency.
Requirements
Eligibility
- Open to candidates residing in Sydney, Australia with full Australian working rights.
Essential Skills
- Bachelor’s degree in Data Analytics, Engineering, or related field.
- Deep expertise in SQL (2+ years), with the ability to write complex queries for data transformation and analysis.
- Strong proficiency in ETL tools, specifically Alteryx (or similar tools with a willingness to master Alteryx).
- Highly proficient in data cleansing including regex, data transpose / crosstab, join, group, union, etc.
- Strong problem-solving skills to trace data issues from the dashboard back to the source.
- Good written and verbal communication skills to articulate data logic to internal stakeholders.
Other Highly Desirable Skills
- Experience building dashboards in Tableau, or a similar data visualisation tool, with an eye for design and usability.
- Knowledge of retail data sets (ranges, pricing, promotions) and use cases.
- Experience working in a SaaS or data product environment.
About you
- Analytical: You don't just move data; you understand what it means and how it's used.
- Detail-Oriented: You spot the 1% error that everyone else misses.
- Visual: You understand that a great dataset needs a clear visualisation to be useful.
- Efficient: You hate doing the same manual task twice and look for ways to automate workflows using SQL or Alteryx.
- Collaborative: You work closely with the Development team to leverage our core infrastructure, and partner with Customer Success to align on customer feedback and prioritize feature requests.
Benefits
- Competitive salary with startup perks and flexible work arrangements.
- Opportunity to grow into a Senior Data Engineer role as we scale.
- Vibrant coworking space with free coffee, 1x weekly free breakfast/lunch, and community events.