Senior Data Engineer - Marketing Analytics

Apply for this role

Senior Data Engineer - Marketing Analytics

Apply for this role

The Senior Data Engineer - Marketing Analytics is a new role and an integral member of the Connections department with a focus in the agency’s analytics offering.

The primary responsibility of this position will be to manage the agency’s data infrastructure practice spanning data ingestion, sanitation, management, and governance.

Essential Duties & Responsibilities as Senior Data Engineer - Marketing Analytics

  • Manage and optimize the agency’s BigQuery data warehouse on the Google Cloud Platform

  • Build and streamline data ETL processes and operations

  • Clean and organize performance media data sources to provide timely and accurate data for reporting

  • Ensure uptime of data and optimize data availability performance

  • Create database schemas and database architecture

Additional Responsibilities as a Member of the Connections Team

  • Proactively identify and bring new approaches, vendors, and more to help grow and evolve the analytics practice

  • Assist in fostering a data-driven approach in the agency.

  • Model a conscientious, straightforward and dedicated work ethic

  • Passionately uphold the agency brand, culture and values

  • Collaborate among multiple agency teams effectively and efficiently

Communication Skills

  • Demonstrate excellent written, verbal and listening skills

  • Demonstrate outstanding presentation skills in formal and informal settings and is an excellent meeting leader

  • Communicate in a clear, coherent and professional manner

  • Work with internal, cross-departmental teams with self-assuredness as well as sensitivity

  • Maintain a candid professional relationship with other Wray Ward employees

Qualifications

  • A minimum of 3-5 years of working and managing cloud based data warehouses

  • Experience building and maintaining ETL workflows and systems

  • Ability to ingest data from multiple data sources such as APIs, Cloud Storage Buckets, and JSON files

  • Experience preparing data for business intelligence tools such as Tableau and Google Data Studio

  • Proven record of merging multiple data sources to develop single sources of truths for reporting needs

  • Strong organizational skills to effectively manage multiple projects at a time

  • Effective problem-solver and generator of creative, innovative

  • Bachelor’s degree

Our Mission

Day in and day out, we will passionately create the most innovative, engaging and effective work in the home category — we will live it, we will breathe it and we will own it.

Please note: If your browser is experiencing difficulty opening the “Apply for this role” link, please send your resume and other materials directly to careers@wrayward.com.

This job description serves as an overall summary of responsibilities for the position outlined. Please note it is subject to change with specific expectations associated with the position.

Candidates must possess authorization to work in the United States, as it is not the practice of Wray Ward to sponsor individuals for work visas. Wray Ward participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the United States.

Wray Ward is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

Culture Alignment

At Wray Ward, we firmly believe that internal and client relationships are a key to our success. Certain attitudes define how we work and are important in what we seek for our culture and mission. Key Agency attitudes are: