Information Analyst II

at  ButlerTill Inc

DESCRIPTION

This position is considered hybrid for candidates living in the Rochester, NY area.
Butler/Till is a results-driven marketing agency offering deeply collaborative client experiences, proprietary technology, and world-class partnerships. At Butler/Till, we take immense pride in our independent, women-owned and led status, our unwavering commitment to a purpose-driven approach, our B-Corp status, and our unique structure as a 100% employee-owned company (ESOP).

SUMMARY

The Information Analyst plays a vital role in distilling raw data into actionable insights to inform campaign optimizations. They exercise discretion and independent judgment within the data collection, modeling, measurement planning, visualization, and analysis process. This individual collaborates closely with senior team members to analyze information needs, data relationships, workflow, and technical documentation. Strong communication skills, proactive attitude, and adaptability are crucial for success in this fast-paced, deadline-driven environment.

REQUIRED QUALIFICATIONS

• 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 BIStrong written and verbal communication skills

PREFERRED QUALIFICATIONS

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

CORE COMPETENCIES

• CUSTOMER FOCUS/CLIENT INTIMACY: seeking to understand client business challenges/needs and delivering continuous value to our clients
• COLLABORATIVE: working with teams and across the organization with ease
• OWNER AGILITY: able to continuously learn and quickly adapt to changing circumstance
• RESULTS DRIVEN: accepts accountability to deliver business outcomes, even under changing circumstances. Delivers on commitments
• DISCIPLINED: Thinks, plans, and prioritizes work on an ongoing basis, plans and aligns with key team members before acting

KEY OUTCOMES & RESPONSIBILITIES

Key Outcome: Represent media data with domain expertise for campaign performance reporting.

Key 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.

Key Outcome: Measurement Planning, Visualization & Analysis.

Key Responsibilities:

• 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.

Key Outcome: Technical Process Maintenance & Improvement

Key Responsibilities:

• Assist in the development of formal processes and conduct efficiency audits.
• Proactively support agency improvement/innovation initiatives.

OTHER RESPONSIBILITIES:

• 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.