Data Engineer at UpGuard

Analytics, Full-time, Sydney sydney engineering analytics full-time
Posted a month ago

Who are we?
UpGuard’s mission is to protect the world’s data. We obsessively seek out elegant, robust ways to enable our customers to find, acknowledge, and remediate cyber risk. With UpGuard, organizations leverage our security expertise and software to automate what was once laborious, spreadsheet-driven processes–whether it's monitoring the attack surface of hundreds of vendors or assessing the security of their own infrastructure. UpGuard is used by some of the world’s largest, fastest-growing, and most innovative companies. 

Why are we hiring this role?
As UpGuard continues to scale at an increasing rate, each of our teams, from Product to Sales, are becoming more data and insight hungry. As a result, our central Analytics and BI function is bandwidth constrained and needs to scale with our business growth.

As a Data Software Engineer you will be responsible for enabling our Analysts to investigate hypotheses and provide actionable insights to the wider organisation. You will ensure our internal systems are kept robust and efficient and allow people to access data in the right format for discovery and analysis. You should be able to identify areas where our processes can be improved without loss of accuracy and capability. The Analytics function up UpGuard is also responsible for helping teams automate their processes. You should be able to use your experience as an Engineer to design and construct innovative solutions to help us automate our processes as we scale.

We are looking for someone with 3 or more  years of experience working in either a Data Engineering or Software Engineering  role. Candidates should have a Bachelor's Degree in a Mathematical, IT, Science or Engineering field. As our team is currently small, we're looking for someone who is self-sufficient.

In this role you will:

  • Understand the data needs of various teams within the organisation, from stakeholders that do and do not have a technical background. A successful candidate will not only be able to digest requirements, but also converse with stakeholders in a constructive and comfortable manner, as you are providing “customer support” to our Analysts and members of the wider organisation.
  • Be able to transform raw data into an actionable format through the use of our Business Intelligence platform and our underlying infrastructure. 
  • Our BI platform is Looker, so we are looking for candidates who are familiar with both the Explore/Look/Dashboard side of Looker as well as having experience with the Developer side of Looker.
  • Our infrastructure uses a combination of PostgreSQL and BigQuery along with automations built in Golang where required.
  • You should be comfortable constructing a query in SQL, analysing the performance of a query, knowing when to use table indices, knowing how to configure and maintain materialised views.
  • Be able to learn and understand our business processes, from our sales pipeline structure to our product usage metrics.
  • Be able to not only suggest areas of improvement for our processes, teams and infrastructure, but also be able to plan, implement and test the proposed solution, while maintaining absolute business continuity.
  • Be data secure - we are a cybersecurity company and in this role you will handle sensitive data.
  • What would give you an edge:

  • We have a Google Platform-based BI-stack. These are the technologies and skill sets we are looking for:
  • Looker is our main BI platform: a candidate should be familiar with Explores, Looks, Dashboards and the Developer interface - maintaining dimensions and measures, create and maintain models, and be able to run and debug raw SQL queries.
  • Google Sheets when we need to explore data in more detail: you should be comfortable with functions like pivot tables, vlookup, charting, importrange, query and potentially even the Google Sheets API/SDK.
  • CloudSQL (PostgreSQL) and BigQuery for storage and query: be comfortable with writing complex queries, indices, materialised views, etc.
  • Containers, Docker and Kubernetes (via GKE) are used to run our internal automations.
  • Be familiar with Golang as a programming language as our non-standard ETL workers are written in Go.
  • Be comfortable interfacing with a variety of APIs from our vendor platforms (either REST+JSON or SOAP+XML, depending on what a vendor platform throws at you).
  • Have experience with version control via GitHub, and a basic review process, like GitHub Flow.
  • If all else fails, being comfortable and confident falling back to a Golang+TypeScript+ChartJS solution, just to get data in the right shape or form to enable the Analyst to continue their work.
  • What's in it for you?

  • Hybrid or Remote: you choose.  While we have offices in Sydney & Hobart, we don’t mandate how often you need to be there.  We focus on what you deliver, not where you deliver it from.  
  • Impact: Influence the direction and design of projects that push the boundaries of your field and see the impact of your work daily.
  • Be part of an energetic team: Our team is highly collaborative, fostering a positive work environment that encourages creativity and innovation.
  • We value work-life balance: We recognize the importance of maintaining balance and provide a supportive work environment that allows you to prioritize your personal life and well-being.
  • Generous reward: We offer a competitive salary + equity 
  • Great perks: You won’t find table tennis tables or office mandates - we prefer to offer perks that support your overall well-being - including a lifestyle allowance, well-being program, WFH budget, personal learning & development budget, generous leave benefits, and plenty more!
  • #LI-JD1

    UpGuard is a Certified Great Place to Work® in the US, Australia, UK and India, establishing its position as a leading global technology employer. 99% of team members agree that UpGuard is a great place to work, apply now to find out why!

    As an Equal Employment Opportunity and Affirmative Action Employer, qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.

    For applications to positions in the United States, please note, at this time we can only support hiring in the following US states: CA, MD, MA, IL, OR, WA, CO, TX, FL, PA, LA, MO, DC or NV. 

    Before starting work with us, you will need to undertake a national police history check and reference checks. Also please note that at this time, we cannot support candidates requiring visa sponsorship or relocation.