Digital Analyst (MCI)

Tru India

2 - 7 years

4 - 9 Lacs

Jalandhar Ludhiana Patiala Amritsar

Posted:2 days ago| Platform:

Apply

Skills Required

PPC Automation Data management Business analytics Analytical Web development Customer retention Data processing Business intelligence SQL

Work Mode

Work from Office

Job Type

Full Time

Job Description

Position Overview:
We are seeking an experienced Digital Analyst with a strong background in Marketing Cloud Intelligence (MCI), BigQuery, Snowflake, etc. The ideal candidate will be responsible for managing and analyzing marketing data, optimizing performance, and developing data-driven strategies to enhance business growth. This role requires expertise in MCI (formerly Datorama) for reporting, visualization, and campaign performance tracking. Responsibilities:

1. Marketing Cloud Intelligence (MCI) & Digital Analytics:

Manage and optimize MCI dashboards to track marketing performance, campaign effectiveness, and business KPIs.
Develop custom data models within MCI to aggregate, clean, and transform marketing data from multiple sources.
Automate data ingestion and transformation pipelines in MCI for seamless reporting.
Perform advanced marketing analytics to identify trends, improve attribution models, and enhance campaign effectiveness.

2. Data Management & Integration:

Develop and maintain data architectures using Snowflake, BigQuery etc.
Extract, process, and analyze large datasets from multiple marketing platforms.
Integrate MCI with Google Analytics, Adobe Analytics, and Google Tag Manager to consolidate reporting and drive actionable insights.
Optimize ETL pipelines to ensure efficient data processing and reporting.

3. Performance Reporting & Business Insights:

Develop custom dashboards in MCI, Looker Studio, and Excel for marketing performance tracking.
Analyze multi-channel marketing campaigns (PPC, social, programmatic) and provide optimization recommendations.
Deliver monthly, quarterly, and ad-hoc reports to key stakeholders on marketing performance and ROI.
Conduct cohort and segmentation analysis to improve customer retention and acquisition strategies.

4. Collaboration & Strategy:

Work closely with marketing, product, and data teams to align data-driven insights with business goals.
Provide recommendations to optimize budget allocation, audience targeting, and media spend efficiency.
Stay updated on MCI enhancements, industry trends, and new analytics tools.

Requirements

Bachelor or Master degree in Data Science, Computer Science, Marketing, Business Analytics, or a related field.
2+ years of experience in digital marketing analytics, business intelligence, and data management.
Proven expertise in MCI (Marketing Cloud Intelligence/Datorama), including dashboard development and data transformations.
Strong hands-on experience with Snowflake, BigQuery, and SQL .
Experience in Adobe Analytics, Google Analytics (GA4) , etc.
Experience in ETL processes, API integrations, and marketing data automation.
Strong analytical, problem-solving, and communication skills.
Ability to work in a fast-paced environment, managing multiple projects and deadlines.