Job Description

Classification: Full-time

Team: Data Warehouse Team in Finance

Reporting to: Data Warehouse Architect

Estimated Start: Immediate

What's the role?

We're looking for an Analyst to join our Data Warehouse team in the Finance Function. You will be responsible for First Line Support for the Data Warehouse. The role will involve loading Transactional Data, resolving Master Data conflicts and investigating Reporting discrepancies..

Our Analyst will be familiar with issue logging, prioritisation and resolution, understand different data types and be able to write simple Transact SQL Statements to investigate issues and update records. This role will have a lot of scope to help build out and improve the Data Warehouse Functionality, Processes and Dashboards.

So, tell me about the company

Brainlabs is an experimentation-led agency famed for its world-class company culture. We seek to create an environment where everyone is excited to come to work and contribute to our two-fold mission:

• to change the future of digital advertising
• to build the best company to work for

For more info why not take a look at our and our which sets out our aim to be remarkable in diversity and inclusion, team spirit, client work, career progression, and fun.

What this job is:

• A key part in supporting our efforts to build a Business Intelligence Platform that is trusted across the business

• A chance to wow our internal customers by responding quickly and professionally to help them deliver high quality reporting and analysis
• An opportunity to be a part of highly supportive team within a growing company that values culture and diversity

What this job isn't:

• Solitary - You will work as an integral part of the the finance team but also liaise with other functions across the globe.
• Boring! - Our ambitions for the Data Warehouse development project require fast-paced change. We have a high volume of project requirements in our pipeline and this job will play an important in delivering improvements.
• Micro-managed - Upon training, you will be trusted to resolve challenges, make improvements and to give 110% into helping the future growth of Brainlabs.

Give me a breakdown of what a Data Warehouse Analyst at Brainlabs does:

Load Transactional Data (50%):

• Monitor and debug issues with scheduled data loads from Source Systems
• Liaise with Data Source Owner over timing, availability and quality of Google Sheet based Data Sources
• Make required changes to Google Sheet source data formatting to make it suitable for upload using Kleene ELT tool
• Manage mapping of Data from Source to Master
• Run non scheduled Snowflake Stored Procedures and SQL Scripts
• Reconcile Snowflake Output Views back to Source Data provided
• Refresh Reports using Looker, Looker Connect and Supermetrics for Google Sheets
• Publish Reports to Data Source Owner and Report Users

Maintain Master Data (25%):

• Liaise with Data Source Owners over requested changes to Master Data and Source Data mapping ensuring records are updated at Source
• Update Master Data tables in Snowflake using Stored Procedures, library scripts and writing simple custom TSQL scripts
• Verify Data Warehouse output and feedback to internal customers

Log, Prioritise and Resolve Issues Raised (25%):

• Log issues raised in person, via email or over, Slack into Asana
• Prioritise and triage issues into those resolvable by First Line Support and those requiring additional Second Line Support
• Resolve all First Line issues
• Work with Second Line Support to resolve and learn how to fix more complex issues
• Feedback to users on issue status

What we really want:

• A team player that loves change
• Enthusiasm to learn new skills, technologies and ways of working
• Attention to detail with long term thinking

Give me a breakdown of what a Data Warehouse Analyst at Brainlabs does:

Load Transactional Data (50%):

• Monitor and debug issues with scheduled data loads from Source Systems
• Liaise with Data Source Owner over timing, availability and quality of Google Sheet based Data Sources
• Make required changes to Google Sheet source data formatting to make it suitable for upload using Kleene ELT tool
• Manage mapping of Data from Source to Master
• Run non scheduled Snowflake Stored Procedures and SQL Scripts
• Reconcile Snowflake Output Views back to Source Data provided
• Refresh Reports using Looker, Looker Connect and Supermetrics for Google Sheets
• Publish Reports to Data Source Owner and Report Users

Maintain Master Data (25%):

• Liaise with Data Source Owners over requested changes to Master Data and Source Data mapping ensuring records are updated at Source
• Update Master Data tables in Snowflake using Stored Procedures, library scripts and writing simple custom TSQL scripts
• Verify Data Warehouse output and feedback to internal customers

Log, Prioritise and Resolve Issues Raised (25%):

• Log issues raised in person, via email or over, Slack into Asana
• Prioritise and triage issues into those resolvable by First Line Support and those requiring additional Second Line Support
• Resolve all First Line issues
• Work with Second Line Support to resolve and learn how to fix more complex issues
• Feedback to users on issue status

What we really want:

• A team player that loves change
• Enthusiasm to learn new skills, technologies and ways of working
• Attention to detail with long term thinking

What particular set of skills would suit this role?

• Logical, methodical way of thinking and working
• High attention to detail and investigative nature
• Experience of working within a Support Desk environment
• Knowledge of Databases, Data Sources, Data Types and simple Transact SQL scripts
• Familiarity with Google Sheets and ideally more sophisticated reporting tools
• Demonstrated alignment to our company values

How will I know I am doing it right

Your primary metric to success will be the timely availability of standard reports within the month-end and forecasting reporting cycles.

A secondary guide will be the volume of Support issues raised and how quickly they are resolved.

What happens next

We know searching for a job is tough and that you want to find the best career and employer for you. We also want to ensure that this position is the best fit for both you and us. Therefore, you will participate in a comprehensive interview process that includes skills interviews with our team. The goal of this process is to allow you to get to know us as we learn more about you.

Brainlabs actively seeks and encourages applications from candidates with diverse backgrounds and identities. More specifically, our equal opportunities and diversity monitoring data indicates that we under-represent BIPOC ethnic groups, so we actively encourage applications from BIPOC candidates.

Thank you for your interest in Brainlabs! We look forward to getting to know you!