Marketing Data and BI Analyst

Opportunity Overview The Journey & Touchpoint Analytics Team within the department is responsible for defining and implementing an approach to collecting behavior/interaction data, developing comprehensive reporting across journeys and touchpoints, and enabling self-service by other stakeholders. Journey & Touchpoint Analytics supports the Experience, Brand & Marketing division's measurement, analytics, data and reporting needs for paid, owned, earned and shared channels and numerous campaigns and projects. Analysts on the team are responsible for consulting with the marketing strategists, copywriters, channel managers and leadership to: Understand their business objectives, strategies, business questions and coach them on measures of success/KPIs Define measurement plans, data requirements, benchmarks and forecasts, and utilize analytics tool suite to meet their needs Deliver reports, research, analysis or custom insights and present findings to teams Advise teams on how they might apply learnings to their channels, campaigns, projects to optimize the client experience and improve business results Responsibility Summary/Job Description Design, create and deliver project team and management-level reports and visualizations Perform analysis to transform data into actionable insights and inform decision-making and present findings to project team stakeholders and leaders Develop and deliver measurement plans and supporting deliverables to enable teams to measure performance of projects, channels and campaigns Consult on data and tagging requirements and best practices to ensure alignment and consistency with marketing's measurement framework Support IT projects related to development of new digital marketing prototypes, including data requirements, design, user acceptance testing, implementation and verification Coordinate analytics platform training with vendors and project teams Onboard data from marketing tools to support recurring dashboards Query data from internal databases (currently Oracle, eventually Snowflake) to support outreach and reporting needs. Project Details Journey & Touchpoint Analytics supports the Experience, Brand & Marketing division's measurement, analytics, data and reporting needs to measure and optimize the experience of potential clients, current clients and the branch teams who serve them. Experience Measures is a fast-growing team with high visibility across platform. Given the critical need for data and insights to deliver measurable business outcomes for our clients and the firm, this role will directly enable the measurement of our many websites and digital touchpoints. This role will support the migration to Google Analytics 4 and will be involved with a number of other technologies, including Salesforce Marketing Cloud, Marketing Cloud Intelligence (FKA Datorama), Tableau, Snowflake, Oracle, etc. Client is in the midst of a firm transformation to becoming a purpose-driven organization. We're partnering with our clients and colleagues to create positive impact on everyone's lives - bettering our communities and society. Client is at the leading edge of this transformation, championing better tools, data and insights to measure and enhance the experience of our clients and branch teams. This role will directly contribute to enhancing Clients’ web analytics capabilities across multiple digital properties. Team Details The Team has 6 full-time associates, two full-time contractors and a team leader. We also lead a matrixed analytics team, through which two additional analysts, a data scientist and 3 partner vendors work as a part of our team. We focus on behavioral data in digital tools and help make the experience our clients have and the experience our branches have serving them the best it can be. We work alongside two sister teams that focus on first-party research, including surveys and focus groups. Client is headquartered in St. Louis, but our team works from all around the country. We work flexibly to support work/life balance. Position Requirements Required Qualifications Understanding of digital marketing campaigns, channels and best practices for measuring individual and omni-channel performance and principles of multi-touch attribution Advanced experience with Excel to blend/transform multiple data sets into interactive reports Experience querying data from databases such as Oracle SQL or Snowflake databases Experience with BI visualization tools such as: Tableau, Power BI, Salesforce Marketing Cloud Intelligence (formerly Datorama). Experience analyzing and delivering marketing campaigns or channels analysis, presenting to internal business receivers and influencing business decisions Self-starter with interest and ability to quickly learn new analytics and MarTech platforms and identify creative solutions to connect data across sources Ability to deliver results in fast-paced environment with varying scope and deadlines Bachelor's Degree required with an emphasis in finance, business, economics, data science, math, analytics or marketing preferred. Relevant work experience will be considered. 3-5 years of relevant work experience Preferred Qualifications Experience with Salesforce products and reporting In particular, Marketing Intelligence Cloud (FKA Datorama), Tableau and Marketing Cloud products. Proficiency interacting with various database and file storage systems (DB2, IDMS, Oracle, Snowflake) Experience with data manipulation languages such as SQL, Impala, PL/SQL, Hive, Pig, XML Experience with statistical tools such as SAS, SPSS, R, or Python preferred. Clicktale/Contentsquare or similar tool experience Knowledge of marketing technology stack and best practices for integrating tools and data #J-18808-Ljbffr