Responsibilities

• Partner with managers and internal and external stakeholders to capture requirements and architect, standardize, scope, and document Butler/Till data frameworks.
• Design, build, and automate scalable, standardized, and client-specific data marts to support consistent reporting and analytics delivery.
• Collaborate cross-functionally to develop data solutions that streamline workflows and improve operational efficiency.
• Work closely with Analytics, Media, and Account teams to understand client data needs and drive standardized campaign and ad naming conventions.
• Maintain comprehensive documentation for data policies, data dictionaries, metadata, and ETL processes to ensure transparency, consistency, and continuity.
• Serve as the first line of defense for data integrity by executing and continuously improving quality assurance and validation processes.
• Partner with Analytics teams to resolve data-related tickets, troubleshoot issues, and ensure timely, accurate file processing.
• Maintain and optimize third-party monitoring tools that detect data inconsistencies, gaps, and failures, triggering rapid corrective action.
• Act as a subject matter expert on Butler/Till data marts and key marketing platforms (e.g., Google, Meta), ensuring data is correctly interpreted and applied across Campaign Analytics and Marketing Science.
• Mentor junior Analytics Data Engineers on QA standards and best practices through structured code reviews and ongoing technical guidance.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, Statistics, Mathematics, Finance, or Economics.
• 2-5+ years of data engineering experience.
• Advanced proficiency in SQL with strong understanding of database schemas and analytics data marts.
• Experience designing and maintaining ETL/ELT pipelines and data workflows.
• Experience with data discovery, analytics, and BI tools (e.g., Power BI, Tableau, Qlik).
• Proficiency with Git and version control platforms (e.g., GitHub, GitLab, Bitbucket).
• 2+ years of experience or intermediate proficiency in Python or similar languages.
• Experience working with normalized and denormalized data structures.
• Detail-oriented with strong organizational, communication, and technical skills.
• Strong analytical and reasoning skills with the ability to visualize processes and outcomes.

Preferred

• Experience working with Snowflake, including administrative permissions.
• Experience in agile environments and project management tools (e.g., Jira, Wrike, Asana, Confluence).
• Familiarity with SaaS analytics platforms and cloud environments (Azure, AWS).
• Familiarity with data security, access controls, and governance practices.
• Experience optimizing performance and cost in cloud data platforms.

Benefits

• ESOP (employee stock ownership plan) included in total compensation.
• Annual bonus, in addition to a full benefits package, and paid time off benefits, including 100% paid parental leave.