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.
Our Analytics team at UpGuard supports all of our teams to extract key insights from the data that we collect.
We extract data from multiple sources and build insightful dashboards to display key metrics and support leaders to make decisions.
We also build integrations between systems to seamlessly collect required data.
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 function is bandwidth constrained and needs to scale with our business growth.
What do we need from you?
As a Lead Technical Business Analyst, you will be responsible for enabling our team and stakeholders to investigate hypotheses and provide actionable insights to the organization.
You will ensure our internal systems are robust and efficient, allowing access to data in the right format for discovery and analysis.
You should identify process improvements without loss of accuracy or capability, and lead research into key business objectives and problems.
In essence, you should share the same metrics concerns as our executives and be capable of end-to-end analysis, building solutions with the Analytics Team.
What you will accomplish :
Understand the business context of stakeholders and focus on relevant metrics, from product engagement to revenue, finance, HR, and legal.
Understand our data warehouse structure, suggest and lead improvements, and measure their benefits while maintaining business continuity and accuracy.
Be familiar with industry-standard ETL techniques and technologies.
Transform raw data into actionable insights using our Business Intelligence platform and infrastructure.
Learn and understand our business processes, including sales pipeline and product metrics.
Maintain data security, as we handle sensitive information.
Lead Analysts, Data Engineers, and cross-functional stakeholders through projects end-to-end, serving as a critical project driver.
What would give you an edge?
Experience with Looker: managing Explores, Looks, Dashboards, and the Developer interface, creating models, and debugging SQL queries.
Ability to deploy custom visualizations with Looker's SDK.
Proficiency with Google Sheets: functions like pivot tables, vlookup, charting, importrange, query, and possibly using the Sheets API/SDK.
Experience with CloudSQL (PostgreSQL) and BigQuery: writing complex queries, managing indices, materialized views.
Familiarity with Containers, Docker, Kubernetes (GKE): understanding platform engineering in GCP.
Knowledge of automation tools like n8n and programming languages like Golang.
Ability to interface with APIs (REST+JSON, SOAP+XML).
Experience with version control (GitHub) and review processes.
Comfort with fallback solutions using Golang, TypeScript, and ChartJS for data shaping and analysis.
What's in it for you?
Stock Options: share in our future success.
Monthly Lifestyle subsidy for wellbeing.
Wfh setup allowance for your home office.
USD 1500 annual Learning & Development allowance.
Generous annual leave/PTO.
18 weeks paid parental leave.
Personal leave including sick and carer's leave.
Fully remote environment, with optional office visits.
Top-spec hardware for your role.
Generative AI subscription support.
LI-SR1
UpGuard is a Certified Great Place to Work in multiple countries.
99% of team members agree it's a great place to work.
Apply now to find out why!
As an Equal Opportunity Employer, we consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, veteran status, or disability.
For US applicants, we support hiring only in specified states.
Prior to employment, a police check and references are required.
We currently cannot support visa sponsorship or relocation.
#J-18808-Ljbffr