About the position
Campbell Ewald is seeking an experienced Senior Analyst to join their expanding Analytics group. The role involves defining and developing cloud-based data solutions and infrastructure, driving the data technology roadmap delivery, and ensuring seamless management and security of business data. The ideal candidate should have a mix of technical expertise and strong business acumen to draw meaningful insights from various data sources. Key responsibilities include data architecture, engineering and integration, SQL querying, business intelligence and data visualization, and collaboration with cross-functional teams. The candidate should have a bachelor's degree in Computer Science or a related field, along with 5+ years of experience in data engineering solutions development and enterprise architecture.
Responsibilities
- Assist in the definition of CE’s data architectural strategy, data roadmap, operational plan, and life cycle management
- 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
- 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
- Data integration skills in ETL (cloud-based solutions, SSIS, or similar), enterprise data management solutions, report writing, SQL authoring, API protocols, and requirements gathering and documentation
- Extensive data design and architecture experience with a focus on data warehouses, reporting, data lakes, aggregation, and integration such as BigQuery and Domo
- Extensive experience with GCP services
- BI solutions experience in Domo, Tableau, Power BI, Looker Data Studio
- Preferred hands-on software development experience, including but not limited to JavaScript, HTML, C++/C#, CSS, PHP, and Python
- Extensive tag management experience, with Google GTM, Adobe Launch, Tealium iQ and ObservePoint preferred
- Digital analytics experience including site taxonomy, visitor intent, segmentation, website structure, voice of customer, CRM, user behavior, and ROI optimization
- Omnichannel analytics in identifying the user journey to optimize marketing campaigns across social/influence, search, and content media platforms
- Digital platforms including Google’s DV360, CM360, and SA360
- Strong organizational, multi-tasking, and time-management skills
- Proven ability to work creatively and analytically in a problem-solving environment
- Excellent communication skills, and comfortable presenting insights to clients
- Excellent project management skills in communicating, leading, and negotiating simultaneous projects
- Consultative approach in guiding clients towards achieving their growth goals
- Storytelling ability to draw conclusions in communicating “what does this mean / how will this impact my client business”
- Ability to “speak the language” of both technical and business audiences alike
- Adaptable, willing to learn, and eager to share knowledge with other team members
- Superior ability to multitask to meet tight deadlines and operate in a fast-paced working environment
- Ability to allocate time to research and recommend emerging trends
- Team player who is able to communicate with other team members across different offices throughout the country
Requirements
- Bachelor's degree in Computer Science or other technical discipline
- 5+ years of experience in data engineering solutions development, enterprise architecture, and integration with downstream transactional systems
- Data integration skills in ETL, enterprise data management solutions, report writing, SQL authoring, API protocols, and requirements gathering and documentation
- Extensive data design and architecture experience with a focus on data warehouses, reporting, data lakes, aggregation, and integration
- Extensive experience with GCP services
- BI solutions experience in Domo, Tableau, Power BI, Looker Data Studio
- Preferred hands-on software development experience, including JavaScript, HTML, C++/C#, CSS, PHP, and Python
- Extensive tag management experience, with Google GTM, Adobe Launch, Tealium iQ, and ObservePoint preferred
- Prior agency experience preferred
- Digital analytics experience including site taxonomy, visitor intent, segmentation, website structure, voice of customer, CRM, user behavior, and ROI optimization
- Omnichannel analytics in identifying the user journey to optimize marketing campaigns across social/influence, search, and content media platforms
- Digital platforms including Google's DV360, CM360, and SA360
- Strong organizational, multi-tasking, and time-management skills
- Proven ability to work creatively and analytically in a problem-solving environment
- Excellent communication skills, and comfortable presenting insights to clients
- Excellent project management skills in communicating, leading, and negotiating simultaneous projects
- Consultative approach in guiding clients towards achieving their growth goals
- Storytelling ability to draw conclusions in communicating "what does this mean / how will this impact my client business"
- Ability to "speak the language" of both technical and business audiences
- Adaptable, willing to learn, and eager to share knowledge with other team members
- Superior ability to multitask and meet tight deadlines in a fast-paced working environment
- Ability to allocate time to research and recommend emerging trends
- Team player who can communicate effectively with other team members across different offices throughout the country
Benefits
- Extensive health benefits for you, your immediate family, and domestic partner (medical insurance, dental insurance, vision insurance, short-term and long-term disability insurance, life insurance, dependent care FSA, healthcare FSA, and health savings account)
- Flexible paid-time-off policy (Me)TO with no maximum allowance
- Minimum of 12-weeks paid time off for new moms and dads (births, adoptions, or foster parenting)
- Mental health support services including access to Talkspace, meditation and yoga classes, and free professional counseling for you and your immediate family
- Pet health insurance for furry family members
- Employee resource groups (ERGs) for connecting with others who have similar dimensions of diversity and experiences
- Growth Time commitment of nearly 100 hours per year for training and development opportunities
- Empowering environment to unleash your superpowers