Information Analyst II

Role overview

Data and campaign measurement

• Identify, collect, prepare, transform, and validate data; maintain data models, mappings, and relationships; and conduct data quality audits.
• Use media data expertise to measure and improve marketing campaigns.
• Establish business objectives and define KPIs and metrics; help develop solutions for client measurement goals.
• Create visualizations and maintain Power BI dashboards for internal and external stakeholders; document observations and deliver accurate reporting on time.
• Assist with formal process development and efficiency audits, and support agency improvement and innovation initiatives.
• Improve processes, manage multiple priorities and projects, and define problems, review data, establish facts, and draw conclusions.

Required qualifications

• Bachelor’s degree in marketing, computer science, information technology, statistics, mathematics, finance, economics, or a related field.
• At least 2 years of relevant experience in data management, data visualization, and/or campaign measurement.
• Developing or intermediate SQL coding ability.
• Deep Microsoft Excel experience, including DAX, complex formulas, pivot tables, and Power Pivot.
• Experience with BI tools, preferably Power BI.
• Strong written and verbal communication skills.

Preferred qualifications

• Experience with digital media platforms or media data analysis.
• Experience in the healthcare vertical.
• Experience using project management software.

Work environment and travel

• The work is typically performed in an office or home office setting.
• Employees attend in-person onboarding during their first week and an annual Shareholder’s Summit in June; additional travel may be required for key meetings and events.

About Butler/Till