Butler/Till
Posted 46 days agoVerified live 1d ago
Information Analyst III
Brief overview
Remote
UndergradOr in progress
$58k–$92k/yrStated range
4+ yrsMinimum
Data ModelingMeasurement PlanningData VisualizationSQLMicrosoft ExcelDAXPivot TablesPower PivotPower BIDigital Media PlatformsHealthcare Domain ExperienceProject Management Software
About the company
Butler/Tillbutlertill.com
Independent, women-owned, 100% employee-owned Certified B Corp delivering measurable marketing through media, analytics, and technology.
Job description
Summary
Butler/Till is a results-driven marketing agency offering deeply collaborative client experiences and proprietary technology. The Information Analyst plays a vital role in distilling raw data into actionable insights to inform campaign optimizations, collaborating with senior team members to analyze information needs and data relationships.
Responsibilities
- Identify, collect, prepare, transform, and validate data
- Understand and maintain data models, mappings, and relationships
- Complete data transformations across all data sources, including 3rd party measurement data
- Perform data quality audits for all media platforms
- Act as a subject matter expert in data use for measuring and improving marketing campaigns
- Confidently respond to client questions in meetings and clearly articulate answers to questions in written form, demonstrating knowledge and understanding of both client business problem but interpretation of the data used to address it
- Establish business objectives and define KPIs and metrics, thoroughly documenting in standard Measurement Framework
- Assist in developing solutions to achieve client measurement goals
- Create visualizations to effectively communicate performance
- Build, update, and maintain Power BI dashboards across all media data and 3rd party measurement sources for internal and external stakeholders
- Documents observations resulting from Power BI dashboard reporting
- Responsible for timely and accurate reporting delivery
- Assist in the development of formal processes and conduct efficiency audits
- Proactively support agency improvement/innovation initiatives
- Continuously learn and improve processes to ensure accuracy and efficiency
- Organize and manage multiple priorities and projects
- Take full responsibility and accountability for contributions and outcome
- Ability to define problems, collect and review data, establish facts, and draw valid conclusions
Skills
- Bachelor's degree in Marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics or a related field
- 4+ years of demonstrated experience in data modeling, measurement planning and data visualization
- Proficient in SQL
- Deep experience in Microsoft Excel, including DAX, complex formulas, pivot tables, Power Pivot
- Experience in BI tools, preferably Power BI
- Strong written and verbal communication skills
- Experience with digital media platforms and analyzing media data
- Experience in the Healthcare vertical
- Experience using project management software
Qualifications
Must Haves
- Bachelor's degree in Marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics or a related field
- 4+ years of demonstrated experience in data modeling, measurement planning and data visualization
- Proficient in SQL
- Deep experience in Microsoft Excel, including DAX, complex formulas, pivot tables, Power Pivot
- Experience in BI tools, preferably Power BI
- Strong written and verbal communication skills
Nice to Haves
- Experience with digital media platforms and analyzing media data
- Experience in the Healthcare vertical
- Experience using project management software
Benefits
- ESOP (employee stock ownership plan)
- An annual bonus
- A full benefits package
- Paid time off benefits
- Including 100% paid parental leave
