Butler/Till
Information Analyst II
Butler/Till, Rochester, New York, United States, 14600
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.
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 transformationsPerform data quality audits.Act as a subject matter expert in data use for measuring and improving marketing campaigns.Key Outcome: Measurement Planning, Visualization & Analysis .
Key Responsibilities:
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.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 conclusionsRequirements
REQUIRED QUALIFICATIONS -
Bachelor's degree in Marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics, or a related field2+ years of relevant experience in data management, data visualization and/or campaign measurement.Developing or intermediate ability to code in SQLDeep experience in Microsoft Excel, including DAX, complex formulas, pivot tables, Power PivotExperience in BI tools, preferably Power BIStrong written and verbal communication skillsPREFERRED QUALIFICATIONS -
Experience with digital media platforms.Experience 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 circumstances.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.
WORK ENVIORNMENT & PHYSICAL DEMANDS
The work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.). Reasonable accommodation may be requested to enable individuals to perform the essential functions.
Commitment to Diversity, Equity, Inclusion and Belonging
Our dedication to Diversity, Equity, Inclusion, and Belonging (DEIB) is a cornerstone of our culture. We believe that the diversity and inclusivity of our workforce are sources of strength. As you become part of our community, you'll discover that we are dedicated to creating a positive impact, not only for our clients but also for the communities where we live and work.
EEO DISCLAIMER
Butler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
COMPENSATION
Butler/Till is committed to providing pay transparency of our compensation philosophy and ensuring equitable pay practices for our employee owners. The compensation range for this position is $54,000 - $76,000 and represents the annual salary range in Rochester, NY. Base pay offered may vary depending on multiple individualized factors, including location, skills, and experience.
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. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.
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.
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 transformationsPerform data quality audits.Act as a subject matter expert in data use for measuring and improving marketing campaigns.Key Outcome: Measurement Planning, Visualization & Analysis .
Key Responsibilities:
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.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 conclusionsRequirements
REQUIRED QUALIFICATIONS -
Bachelor's degree in Marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics, or a related field2+ years of relevant experience in data management, data visualization and/or campaign measurement.Developing or intermediate ability to code in SQLDeep experience in Microsoft Excel, including DAX, complex formulas, pivot tables, Power PivotExperience in BI tools, preferably Power BIStrong written and verbal communication skillsPREFERRED QUALIFICATIONS -
Experience with digital media platforms.Experience 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 circumstances.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.
WORK ENVIORNMENT & PHYSICAL DEMANDS
The work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.). Reasonable accommodation may be requested to enable individuals to perform the essential functions.
Commitment to Diversity, Equity, Inclusion and Belonging
Our dedication to Diversity, Equity, Inclusion, and Belonging (DEIB) is a cornerstone of our culture. We believe that the diversity and inclusivity of our workforce are sources of strength. As you become part of our community, you'll discover that we are dedicated to creating a positive impact, not only for our clients but also for the communities where we live and work.
EEO DISCLAIMER
Butler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
COMPENSATION
Butler/Till is committed to providing pay transparency of our compensation philosophy and ensuring equitable pay practices for our employee owners. The compensation range for this position is $54,000 - $76,000 and represents the annual salary range in Rochester, NY. Base pay offered may vary depending on multiple individualized factors, including location, skills, and experience.
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. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.