JOB DESCRIPTION
Title Junior Analytics Analyst
Department Data, Insights & Strategy
Reports to Head of Insights & Strategy
SUBSTANCE GLOBAL
Substance Global is a digital marketing agency specialising in a range of services across different media and industries. We are proud of our work and our people in equal measure and our passion for what we do and the culture we have developed is what drives us in everything we do. Founded in 2003, we have grown to over 60 people in London, Los Angeles, Singapore and Buenos Aires. Our work is insights-driven and innovation-led and our strategies are made up of a blend of creativity and collaboration, tailor-made for each of our client’s brands.
GENERAL SUMMARY
As an Analytics Engineer, you will play a critical role in designing and developing data pipelines, ensuring data integrity, and enabling data-driven decision-making. The ideal candidate will have a strong background in data engineering and analytics, with expertise in Google Cloud Platform (GCP) services. This role requires a blend of technical proficiency, analytical thinking, effective project & time management, and communication skills. You will have the opportunity to engage in diverse, innovative projects spanning multiple platforms, including real-time data processing and emerging AI technologies, offering opportunities to work with cutting-edge tools and methodologies in the rapidly evolving field of data analytics.
Substance Global is a digital marketing agency; as such a proficiency in sentiment and social analysis via social listening tools like Brandwatch/Talkwater/ etc, working knowledge and of 3rd party tools such as Sprinklr, Sprout Social and GWI. As well as experience working with platform scraping tools like Fivetran/Adverity/Apify etc (working knowledge of JSON files and API calls).
How You’ll Make An Impact
- Design and implement high-performance, reusable, and scalable data models for our data warehouse using scheduling tools and GCP/BigQuery.
- Design and implement visualisation tools (explores, views, etc) which will enable users across the organization to self-serve analytics
- Work closely with key stakeholders to understand business requirements and provide data ready for analysis and reporting.
- Blended data approaches include owned, earned, and paid data sources. Plus, the inclusion of social listening and 3rd party data sources.
- Continuously discover, transform, test, deploy and document data sources and data models
- Apply, help define, and champion data warehouse governance: data quality, testing, documentation, coding best practices.
- Take initiative to improve and optimise analytics engineering workflows and platforms
Key Responsibilities
- Design, develop, and maintain scalable data pipelines on GCP (Or other cloud services ie. Snowflake) using services such as BigQuery and Cloud Functions.
- Designing and building data models for analytics, reporting, and data science applications in Looker/Metabase(Visualisation solutions) using (explores, views, etc) which will enable users across the organization to self-serve analytics.
- Strong Python (Pandas/SQL Alchemy) & SQL(BigQuery/Snowflake) skills for maintaining ETL/ELT pipelines.
- Developing tools and processes to ensure the quality and observability of data
- Monitoring and improving the performance and efficiency of the data stack
- Producing excellent documentation on all of the above
- Working in a small, agile team to build excellent data product
- Continuously discovering, transforming, testing, deploying, and documenting data sources and data models
- Building great relationships with stakeholders and understanding their needs and challenges. Being curious, adaptable, and willing to pitch in to help with data problems of all shapes and sizes
Qualifications
- Proven delivery experience as a data, business intelligence or analytics engineer
- Hands-on proven data modeling and data warehousing skills demonstrated in data environments
- Excellent Python & SQL and data transformation skills (e.g. ideally proficient in dbt or similar)
- Familiarity with at least one of these Cloud technologies: Snowflake, AWS, Google Cloud, Microsoft Azure
- Good attention to detail to highlight and address data quality issues
- Excellent time management and proactive problem-solving skills
What’s in it for you:
💷Competitive Salary.
🏖️23 days holiday.
🚃In-office/Hybrid or Fully remote.
🏋️Vitality Healthy care package
🛍️Perkbox discount and points program.
☕️Access to Co-working spaces.
📚LinkedIn Courses and time for training.
How to apply:
Send your CV and portfolio link to: jobs@substanceglobal.com
This role is perfect for a creative designer with the ability to push creative ideas to new heights.
EDI statement and our people pledge
Don’t meet every single requirement? Research shows that women and people of colour are less likely that other to apply if they don’t match 100% of the job requirements. Don’t let the confidence gap stand in your way, we’d love to hear from you! We understand that experience comes in many difference forms and are dedicated to adding new perspectives to the team.
Substance Global is committed to providing and fair, inclusive, and diverse work-environment. We believe that different perspectives lead to better ideas, and better ideas allow us to better understand the needs and interests of our diverse, global community with who we work. We welcome people of different backgrounds, experiences, abilities, and perspectives and are an equal opportunities employer.
