IT Data Analyst ~ Expert MS Excel w/ pivot tables & fornulas, DAM, Salesforce reporting, YieldEx Analytics, Google Ad Manager
About the position
We are seeking someone for a 9 month project to be responsible for data analysis, validation, cleansing, collection and reporting. The candidate must have a strong analytical mindset and be able to communicate clearly and concisely with diverse set of organizational stakeholders. Responding to data inquiries from many groups within the organization and be able to efficiently extract and analyze data from various resources, will be a core function. At a minimum, the candidate must possess expert level knowledge of MS Excel, specifically showing proficiency with pivot tables and formulas. Experience in the Digital Advertising industry will be strongly preferred, with specific knowledge around CPMs, Impressions, and site traffic metrics (e.g. unique visitors, page views, etc). Familiarity with Salesforce reporting, YieldEx Analytics, and/or Google Ad Manager is highly desired. (Experience with Salesforce is HIGHLY desired.) NOTE: The person can be located anywhere in the continental US and willing to work EST hours.
Responsibilities
- data analysis
- validation
- cleansing
- collection
- reporting
- Responding to data inquiries from many groups within the organization
- efficiently extract and analyze data from various resources
Requirements
- strong analytical mindset
- be able to communicate clearly and concisely with diverse set of organizational stakeholders
- expert level knowledge of MS Excel, specifically showing proficiency with pivot tables and formulas
Nice-to-haves
- Experience in the Digital Advertising industry with specific knowledge around CPMs, Impressions, and site traffic metrics (e.g. unique visitors, page views, etc)
- Familiarity with Salesforce reporting
- Familiarity with YieldEx Analytics
- Familiarity with Google Ad Manager
