Manager, Analytics Data Engineering

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

As the Manager, Analytics Data Engineering, you will spearhead a team tasked with designing, developing, and upholding the organization's data infrastructure. Guiding the efforts of Analytics Data Engineers, you'll blend data engineering expertise with business intelligence methods to swiftly meet our clients' reporting needs. Collaborating closely with Manager, Campaign Analytics and Marketing Science, you'll orchestrate the creation of reports, analyses, extracts, and datamarts seamlessly integrated into Power BI. This pivotal role centers on data processing within cloud environments like Snowflake, Azure, and AWS, with a keen eye on ensuring Quality Assurance across Power BI and marketing platforms. Alongside overseeing work processes such as automating ad hoc procedures and managing ETL steps, you'll play a crucial role in nurturing talent through training, code reviews, and feedback sessions to enhance the team's skills and deliverables. Leveraging your expertise in data engineering, leadership, and project management, you'll drive data-driven decision-making to support our business objectives effectively.

KEY OUTCOMES \& RESPONSIBILITIES

Key Outcome: IMPROVED ORGANIZATION \& PRODUCTIVITY

Effective data management fuels organization, productivity, and automation. Enabling internal consumers access to trusted data for running queries, developing strategic insights, and delivering standardized outputs. Adding value to our external customers and improving the bottom line.

Key Responsibilities:

• Collaborates with their Director and other Managers in the Analytics organization, taking the lead on projects with both internal and external stakeholders to capture requirements, architect, scope, standardize, and document Butler/Till’s data frameworks.
• Architects and writes scripts for the creation, support, and automation of standardized, scalable, and client specific data marts.
• Observes and voices opportunities where work with other departments would create solutions to improve agency efficiency.
• Works closely with B/T’s Analysts, Media, and Account teams to understand our clients’ data needs and the standardization of campaign/ad naming conventions across clients.
• Maintains documentation on existing data policies, data dictionaries, metadata and ETL processes and creates proof of concept (POC) designs for strategic initiatives.

Key Outcome: INCREASED RELIABILITY

Data Engineering minimizes potential errors by establishing processes and policies for usage and building trust in the data being used to make decisions across the organization. With reliable, up-to-date data, our teams can respond more efficiently to market changes and customer needs.

Key Responsibilities:

• Designs automated QA processes of data, acting as a 1st line of defense of data integrity.
• Partners with Analytics for resolving tickets and processing files.

• Designs and maintains data flows in 3rd party applications that monitor data inconsistencies and deficits and builds automated alerts to the team for corrective action.

• Act as a subject matter expert with respect to B/T’s data deliverables as well as advise Campaign Analytics and Marketing Science with utilization strategies of data from our marketing platforms (Google, Facebook, etc.).
• Provides guidance and training to Data Engineers on QA best practices with live code reviews.

Key Outcome: REDUCED RISK

Effective data engineering protects our enterprise from data losses, thefts, and breaches with authentication and encryption tools. Strong data security ensures that vital company information is backed up and retrievable should the primary source become unavailable. Also, security becomes more important if data contains personally identifiable information that must be carefully managed to comply with consumer protection laws.

Key Responsibilities:

• The Manager of Data Engineer is familiar with data collection policies, both nationally and internationally (i.e. CCPA (California Consumer Privacy Act), GDPR).
• Recommends policies and standards for all supported data processes.
• Provides directions on which data, processes, and database code to troubleshoot for security concerns and designs policies, code, and processes to close security gaps.

Key Outcome: SCALABILITY

Data management best practices allow organizations to effectively scale their usage of data with repeatable processes to keep data and metadata up to date. When processes are easy to repeat, organizations save time, money, and gain efficiency.

Key Responsibilities:

• Subject matter expertise on the available data for analytics, analyses, and modeling, working closely with Campaign Analytics and Marketing Science Leadership to create strategic data marts that are easily repeatable for new and existing initiatives.
• Expertise in no/low code solutions (i.e. Microsoft Power Automate, Excel), SQL, and Python to support scalable, full life cycle solutions to meet business needs.
• Engages with vendors and internal stakeholders to explore opportunities to enhance the existing tech stack. Creates well-documented requirements for internal or external stakeholders.
• Orchestrates tests for new software functionality (internal or external) and works with their Director to organize, document and communicate agency-wide recommendations for future-proofing B/T’s offering.
• Works with internal stakeholders to determine current and future needs and brings them to the Data Engineering team for future projects.

Key Outcome: ENGAGE, RETAIN, AND ENABLE PERFORMANCE OF TALENT

Key Responsibilities:

• Contribute and proactively manage talent plans. Assess, hire, on-board, and grow role-appropriate talent

• Manage a team; set clear, outcome-based performance goals. Establish and maintain development plans for each.

• Provide effective feedback that enables employees to improve and work toward goals, while seeking feedback from team to enable inclusion and continuous improvement

• Remove barriers to enable team outcomes

• Provide opportunities for growth and development, while mentoring and inspiring employees to unlock their full potential

Other Responsibilities:

• Additional accountabilities and tasks may be assigned by leader/management, to contribute to overall team and agency success.

QUALIFICATIONS

• REQUIRED QUALIFICATIONS

o Bachelor's degree in Computer Science, Information Technology, or related field

o 8\+ years of experience in data engineering, marketing science or related roles

o Detail-oriented with strong organizational, communication, computer, and office procedure skills.

o Strong proficiency in SQL, Python, and data modeling

o Proficient in Git and/or version control software (e.g., GitHub, GitLab, BitBucket).

o Demonstratable experience working directly in data discovery, analytics, and BI software (e.g., Tableau, Qlik, PowerBI).

o Experience with cloud platforms (e.g., AWS, Azure, GCP)

o Extensive experience working with Snowflake with admin-level permissions.

o Passion for problem-solving and providing workable solutions.

o Strong analytical and reasoning skills with an ability to visualize processes and outcomes.

o Ability to understand and anticipate risks/dependencies across deliverables.

o Excellent leadership, communication, and problem-solving skills

• PREFERRED –

o Master's degree in Computer Science, Information Technology, or related field

o Experience managing and leading a team of data engineers

o Experience working in an agile team environment and using project management software (e.g., Jira, Wrike, Asana)

o Familiarity with SaaS systems (i.e., Datorama, Ascend).

o Certifications in relevant technologies (e.g., AWS Certified Big Data - Specialty)

o Knowledge of machine learning and advanced analytics techniques

o Experience with data visualization tools (e.g., Tableau, Power BI)

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

TRAVEL REQUIREMENTS

• All employees, regardless of role or geographic location, are required to attend in person for onboarding during their first week of employment and annually for the Shareholder’s Summit held in June. Additional expected travel will include quarterly leadership development training and key/critical meetings \& events.

• development training, key/critical meetings \& events, and regular visitation to the Agency headquarters.

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.