Data Modeling Analyst, Sr. jobs in Kansas City, MO

Responsibilities

• Have a passion for data analysis, critical thinking and storytelling
• Be able to work with internal media and reporting teams to develop measurement solutions for client campaigns.
• Analyze campaign performance and other marketing efforts to assess their impact on client KPIs and make recommendations for improvements.
• Participate in the creation of our clients’ measurement strategies, including KPI selection, data capture requirements, measurement frameworks and data visualization
• Become a trusted expert regarding clients’ marketing performance data and will assist team members across departments in accessing and interpreting results.
• Have experience with digital tracking, including tagging, mobile and social limitations
• Excellent verbal and written communication skills to interpret and present business value to clients.
• Work with client internal analytics and IT teams to implement custom tracking parameters
• Implement and maintain media performance dashboard reporting across platforms like Excel, Sheets, Data Studio, PowerPoint, Slides, Datorama, Tableau and Power BI
• Demonstrate problem-solving ability with emphasis on drawing inferences with data

Personal characteristics:

• Intellectual curiosity, problem solving skills and determination
• Detail-oriented and thorough
• Effective communications verbally and in writing
• Ability to listen to stakeholders, process feedback and provide solutions
• Strong work ethic and integrity

Qualifications

• 2 years of marketing analytics and business intelligence experience with an emphasis on media and marketing measurement
• Experience with data visualization tools, especially Power BI, is a plus.  This includes both the data visualization component of dashboard development and backend data preparation and aggregation.
• Strong working knowledge of spreadsheet platforms (i.e. Excel, Sheets, etc)
• Experience with advertising planning, buying and performance metrics
• Experience with media reporting platform(s) (Doubleclick, Adwords, etc)
• Experience with web analytics platform(s) (Adobe, Google Analytics,etc.)
• Data analysis experience including spreadsheet (Excel) and SQL platforms
• Relational database programming languages (e.g. SQL) and statistical tools (e.g. SAS, SPSS, Python) is a plus
• Effectiveness in managing multiple projects across multiple clients and stakeholders
• Experience in analysis, research and presentation creation