Information Analyst II

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.

Requirements

• 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

Preferred

• Experience with digital media platforms.
• Experience analyzing media data.
• Experience in the Healthcare vertical.
• Experience using project management software.

Benefits

• This is just one component of Butler/Till’s total compensation package for employee owners. The total compensation package for this position may also include other elements, including ESOP (employee stock ownership plan), an annual bonus, in addition to a full benefits package, and paid time off benefits, including 100% paid parental leave.