Insight Global is seeking an experienced Salesforce Marketing Cloud (SFMC) Reporting and Data Expert to join a leading banking client downtown Toronto. The ideal candidate will have deep expertise in creating out-of-the-box reporting using SFMC Data Views and Query Studio. Successful candidate will be responsible for developing and managing custom reporting solutions that meet specific campaign performance and analytic needs. In addition, they will play a key role in facilitating data backfeed, journey historical logs for Customer Journeys and collaborate with internal teams to transform, package, and deliver data in the required formats for integration with external data warehouses.
Key Responsibilities
Reporting & Analytics:
Develop and maintain custom reports using SFMC Data Views to track campaign performance, user behavior, and other key metrics.
Create and optimize SQL queries in Query Studio to accommodate ad hoc reporting requests.
Design and automate regular reporting processes to provide actionable insights into email, SMS, and other multi-channel campaigns.
Collaborate with the marketing team to ensure reporting solutions align with business KPIs and objectives.
Data Transformation & Backfeed:
Lead the effort to build and manage backfeeds for SFMC Journeys, ensuring seamless data transfers out of Marketing Cloud.
Ability to transform raw data from Marketing Cloud into specific requirements for external integrations.
Work closely with data engineering and platform teams to define scope for data exchange and ensure data integrity.
Cross-Functional Collaboration:
Act as the primary point of contact between the marketing, platform, and data teams to scope out and clarify reporting and data requirements.
Ensure data quality, security, and governance in all reporting and integration tasks.
Provide guidance to developers on best practices for data management and reporting within SFMC.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.