Senior BI CRM Engineer
Job Summary
As a BI Engineer in the MAS Marketing Insights & Data Democratization team, you will design and maintain scalable business intelligence solutions for CRM performance. You will collaborate with cross-functional teams to transform complex CRM data into actionable insights and strategic recommendations. Your role involves developing automated dashboards and ensuring data governance across global CRM analytics platforms.
Responsibilities
- Develop and automate Power BI CRM dashboards
- Maintain global self-service CRM reporting tools
- Ensure CRM data governance and naming conventions
- Integrate AEP and RTCDP data for real-time analytics
- Optimize data pipelines and perform attribution analysis
Required Skills
- SQL (Teradata, Oracle PL/SQL)
- Power BI / Tableau
- Data Warehousing
- Azure Cloud
- Marketing Analytics & CRM Strategy
Job Details
Responsibilities:
- Lead the development and automation of Power BI dashboards for CRM performance, including lifecycle engagement, retention, and conversion metrics.
- Maintain and evolve self-service reporting tools supporting 17 brands across 22 markets for CRM analytics.
- Collaborate with internal stakeholders to define CRM taxonomy, enforce naming conventions, and ensure data governance compliance.
- Integrate data from Adobe Experience Platform (AEP), RTCDP, and CRM systems to support real-time analytics and audience segmentation.
- Support closed-loop attribution analysis for CRM campaigns and customer journey KPIs.
- Partner with MAS Performance Analytics Squads to deliver in-market insights and support brand-level CRM decisions.
- Ensure data quality, integrity, and consistency across reporting layers, including Gold Layer creation for CRM reporting.
- Identify and troubleshoot data-related issues, optimize CRM data pipelines, and support migration efforts (e.g., OnPrem to Azure).
Requirements:
- Bachelor's or Master's degree in Computer Science, Data Analytics, Information Systems, or related field.
- 5 - 7+ years of experience in BI engineering, preferably in marketing analytics, CRM analytics, or customer lifecycle domains.
- Master of Microsoft Excel and various BI (Tableau, PowerBI), and analytical tools.
- Experience and validated mastery of dynamic data warehouse concepts/methodologies.
- At least 5 years experience writing efficient Structured Query Language (SQL) using various SQL-development software packages including Teradata and Oracle PL/SQL.
- Ability to use custom SQL for complex data pulls.
- Familiarity with cloud platforms (Azure preferred) and data governance practices.
- Excellent communication and stakeholder management skills.