At ShopGrok, data is at the heart of what we do. Your main responsibilities will be working closely with the Founder and Head of Analytics to collect, blend and manage our datasets using SQL and ETL tools, and to build Tableau dashboards that provide retail insights to some of the world’s biggest retailers.
The ideal candidate’s favorite words are learning, data, scale, and agility. You will leverage your strong collaboration skills and ability to extract valuable insights from highly complex data sets to ask the right questions and find the right answers.
What you’ll do:
- Collaborate with the Founder, Head of Analytics and Data Engineering team to bring analytical prototypes to production
- Collaborate with peer-level counterparts from our customers’ analytics teams to gather requirements, perform data mapping, and collect feedback
- Lead data workstreams end-to-end, from requirements gathering, to data mapping and design, ETL build, data visualisation, and automation
- Analyze raw retail data: assessing quality, cleansing, structuring for downstream processing
- Build and maintain our large and growing SQL datasets and base of Alteryx workflows that power our analytics platform
- Bring in and discuss new trends/tools into our team, proactively helping the product stay ahead.
- Work with our technology stack of Snowflake (SQL), Alteryx (ETL), GCP (Cloud) and Tableau (Visualisation) and become an expert in these technologies.
Requirements
Eligibility
- Open to candidates residing in Sydney, Australia with full Australian working rights.
Essential Skills
- A Bachelor’s degree in Software Engineering, Software Development, Data Analytics or a related discipline
- Mastered relational database concepts and at least 2 years professional experience working in SQL, including experience in building robust and extensible data pipelines to/from secure, performant and well-modelled data stores.
- Eagerness to embrace our tech stack (Snowflake, Alteryx, Tableau, GCP) and upskill quickly where needed, primarily via self-learning.
- Passed the Alteryx Designer Core Certification, or willingness to learn as part of the interview process and be competent to pass the prior to commencing the role.
- At least 2 years professional experience building and scheduling ETL workflows to blend and process data from multiple sources, with Alteryx or an equivalent platform
- Highly proficient in data cleansing including regex, data transpose / crosstab, join, group, union, etc
- Good stakeholder management skills
- Good written and verbal communication skills
- Used to working autonomously
Other Highly Desirable Skills
- Experience building data visualizations in a modern data viz platform such as Tableau
- Experience with cloud platforms such as Azure, Google Cloud or AWS
About you
Technical: You love working with data to derive insights and build powerful data visualisations. You're a keen learner and, where you don't know the best way to tackle an implementation problem, are happy to get your hands dirty with the rest of the team learning how to make your designs a reality.
Hungry: You are excited for the opportunity to build out our data infrastructure, and to make your mark on a growing company.
Collaborative: You love working with a team and are adept at explaining technical decisions to other team members, and helping them to bring their ideas to life. You are also comfortable working with developers to ensure a consistent code base across the company.
Thoughtful: You view software development as a never-ending process, and are always thinking about ways to improve our product and its backend infrastructure.
Data-driven: You take a hypothesis driven, data-first approach to attacking any problem, and are adept at separating a complex problem into its mutually exclusive parts and systematically finding solutions through testing and learning.
Perceptive: You are excited by the challenge of answering complex questions in accessible ways using data, you have an eye for detail and will not rest until your implementations function as specified in the design phase.
Benefits
- Competitive salary with startup perks, in a flexible and remote-friendly work environment.
- Opportunity to quickly progress into a Lead Data Engineer role (and commensurate remuneration) in as little as 12 months depending on performance, due to the first growing nature of the business.
- Comfortable office within broader coworking community, with perks such as Friday drinks, fr