Senior Analyst

At Campbell Ewald, we believe the things that make us different, make us better. We focus on creating a culture of belonging with a commitment to learning, growth and anti-racism. We're a diverse bunch of thinkers and makers-curious, fun, passionate, and obsessed with helping our clients, ourselves and each other thrive. But don't just take our word for it. We were named one of the Ad Age Best Places to Work for 2021. And while we appreciate the industry nod, what's more important is that we're impacting culture. Sound interesting? We hope you'll join us!

Campbell Ewald is looking for an energetic and experienced Senior Analyst to join our fun and expanding Analytics group. As part of the Analytics group, you will have the opportunity to help define and develop cloud-based data solutions and infrastructure for the agency. The successful candidate will be integral in driving the data technology roadmap delivery, and ensuring business data is seamlessly managed and secured within the enterprise. The candidate will have a mix of technical background and strong business acumen that will enable them to draw meaningful business conclusions and insights from a wide variety of data sources and structures.

Key Responsibilities :

• Assist in the definition of CE's data architectural strategy, data roadmap, operational plan, and life cycle management, to enable the organization to achieve its business strategy and financial performance targets, in addition to ensuring consistency of the enterprise data architecture.
• Assist in the data engineering and integration process to create data pipelines and model new data sets into data warehousing systems.
• Develop architecture supporting end-to-end data integration process using ETL and ELT, for structured and un-structured data.
• Write complex SQL queries for purposes of analyzing data and evaluating how information needs would be translated into backend database structures.
• Design and recommend business intelligence and data visualization solutions aimed at providing clients clear actionable insights, in a simple yet effective way.
• Collaborate with cross-functional teams to create and implement data strategies, design, and build robust data flows and develop conceptual data models.
• Assist in the technical implementation of tag management solutions to ensure all functions of tagging, troubleshooting, QA and maintenance are performed accurately.
• Work closely with team members to identify any gaps in data capture, and proactively recommend and implement data enhancements.
• Partner with team leads to implement and maintain best practices around data strategy and analytics.

Qualifications :

Interpersonal Skills :

At Campbell Ewald we believe in pay equity. The salary for this position is up to $80,000. Where an employee or prospective employee is paid within this range will depend on several factors including current / former employees in the position, market considerations, budgetary considerations, background, relevant experience and qualifications and location.

We encourage all interested candidates to apply and note that many historically excluded and underrepresented candidates often do not apply unless they feel they meet all requirements of a job completely. Please note that we encourage all to apply as we value a diverse workplace inclusive of those with differing backgrounds, life skills and experiences.

Research show that women and underrepresented groups only apply to jobs only if they feel they meet 100% of the qualifications. Campbell Ewald encourages you to break that statistic and apply. No one ever meets all of the qualifications. We look forward to your application.

Campbell Ewald is making space for your voice, that is why we made the commitment to Dear Black Talent. Check out the website at DearBlackTalent.com.

Benefits

We focus on supporting you in a variety of ways

It is the policy of Campbell Ewald, a division of the Interpublic Group, to provide equal employment opportunities to all employees and applicants for employment with regard to race, religion, national origin, sex, age, sexual orientation, veteran status or disability or any other basis prohibited by applicable federal, state, or local law.

redacted] We will never require an applicant to provide sensitive personally identifiable information in order to conduct an interview - if an applicant is asked to upload an image of their driver's license or passport, a social security number, credit card or banking information, it is a scam.

If you have provided personal information in connection with a fake job offer or interview and you are concerned, we suggest that you take appropriate action and contact local law enforcement in your area. Please also reach out to us by sending an email to

Salary : $80,000