DATA ANALYST
WHAT IS A DATA ANALYST
Our awesome client, a leading merchandising company based in the US is looking for a Data Analyst to be part of their team.
- The person in this role will analyze, design and figure out how to build two data sets that BDA will be delivering to one of BDA's largest clients.
They will also develop and produce the data sets each weekday and deliver them to the client's Amazon S3 instance.
They must be able to proactively troubleshoot and communicate with BDA and our client's data platform partner about the data sets and their status.
They must be a self-starter and able to function independently.
WHAT WILL BE YOUR MAIN RESPONSIBILITIES
Extract data about client website customers from Klaviyo
Extract data for client website customers and orders from OBIEE
Write macros to or some other solution to join data from Klaviyo and OBIEE to create the data files requested by client
Assess and troubleshoot problems
Create and save the files in the agreed upon format, 5x weekly
Move the files to Client's Amazon S3 instance 5x weekly
Communicate as necessary with BDA account team and client data platform partner (e.g., for issues, delays, to ask and answer questions, etc.)
WHAT ARE WE LOOKING FOR
Excellent data literacy and ability to understand data sets
Ability to read API documentation and formulate & execute an approach to pulling data via an API, preferably with Klaviyo experience
Ability to search for and export data from a platform via its Digital UI, preferably with Klaviyo and OBIEE experience
Excellent end-user SQL skills, preferably with Oracle SQL experience
Excellent Microsoft Excel skills
Demonstrated ability to independently design and prepare data sets to be shared in files, including joining data, assessing its quality, and troubleshooting of data & data processes
Excellent written and verbal communication skills in English
Accountability and demonstrated ability to work independently and consistently meet deadlines
DATA ANALYST