Data/Marketing Analyst

 

Job Description 

 

Must Have Skills:

 

Excel modeling skills
 Experience writing and auditing the vlookup() & hlookup() functions
 Experience writing and auditing conditional functions such as If(), Countif(), Countifs, Sumif, Sum ifs, etc
 Experience constructing and auditing Pivot tables
 Experience with the linear programming and iterative calculation functions and add-ins such as Solver, What-If Tables, and Goal Seek
 Experience with the Data Analysis tool pack add-in, especially the Regression tool
PowerPoint skills
Experience creating tables and graphs in native PowerPoint and ThinkCell

Database skills
 Familiarity with the use or relational databases
Ability to write and run basic SELECT, INSERT, UPDATE, and DELETE queries in Access
Ability to write and run basic SELECT, INSERT, UPDATE, and DELETE queries in SQL
SAAS Database skills

Analytic skills
Familiarity with and experience calculating basic descriptive statistics such as mean, median, variance, standard deviation, and correlation
Experience constructing and running basic hypothesis tests such as T-tests and P-test
Experience constructing and running single and multivariate linear regressions and interpreting the results of those regressions
Desired skills
 Advanced Excel and Access database skills
Ability to write Excel macros in VBA
 Ability to implement conditional formatting
 Ability to implement controls using the Development tab

Database skills
 Ability to construct and maintain relational databases in Access and SQL
Ability to construct and run complex queries in Access and SQL