Butler/Till
Posted 48 days agoVerified live 2d ago
Informtation Analyst II
Brief overview
Remote
UndergradOr in progress
$48k–$76k/yrStated range
2+ yrsMinimum
SQLMicrosoft ExcelDAXPower BIData ManagementData VisualizationCampaign MeasurementMedia Data Analysis
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, employee-owned marketing agency providing collaborative client experiences, proprietary technology, and marketing partnerships. The Information Analyst II transforms and analyzes media data to support campaign performance reporting, measurement planning, visualization, and optimization. This role develops KPIs and Power BI dashboards, maintains data processes, audits data quality, and collaborates on process improvements.
Responsibilities
- Identify, collect, prepare, transform, and validate data
- Understand and maintain data models, mappings, and relationships
- Complete data transformations
- Perform data quality audits
- Act as a subject matter expert in data use for measuring and improving marketing campaigns
- Establish business objectives and define KPIs and metrics
- Assist in developing solutions to achieve client measurement goals
- Create visualizations to effectively communicate performance
- Build, update, and maintain Power BI dashboards 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
- Additional accountabilities and tasks may be assigned by leader/management, to contribute to overall team and agency success
Skills
- Bachelor's degree in marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics, or a related field
- 2+ years of relevant experience in data management, data visualization and/or campaign measurement
- Developing or intermediate ability to code 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
- Experience 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
- 2+ years of relevant experience in data management, data visualization and/or campaign measurement
- Developing or intermediate ability to code 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
- Experience 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
