Farnell

Farnell, an Avnet company, is a global high-service distributor of technology products, services and solutions for electronic system design, maintenance and repair.

Job Title: Senior Analyst Customer and Marketing Insights

Job Description:

We are seeking an experienced and data-driven Business Analyst with a strong background in Marketing and Customer Analytics to join our team. The ideal candidate will possess a minimum of 4+ years of relevant experience in Customer Analytics, Marketing Analytics, with expertise in Retail, Distribution, B2B, B2C, and Marketplace domains. The role requires deep expertise in SQL query optimization, relational database management systems (RDBMS), and a strong understanding of customer lifecycle analytics, marketing campaign evaluation, and advanced statistical modeling.

Key Responsibilities:

Customer and Marketing Analytics:

• Analyze customer lifecycle metrics, including acquisition, retention, churn, and lifetime value.
• Evaluate key marketing metrics such as CAC , AOV, and Revenue, Orders.
• Perform pre- and post-campaign analysis to assess marketing effectiveness and ROI.
• Develop customer segmentation strategies to optimize email and marketing campaigns.

SQL and Database Expertise:

• Write, optimize, and manage complex SQL queries for data retrieval, transformation, and reporting.
• Perform performance tuning and optimization of database queries and stored procedures.
• Ensure data accuracy, completeness, and consistency across relational database systems (RDBMS).
• Design and maintain data models to support efficient analytics and reporting processes.

Visualization and Dashboarding:

• Develop and maintain dashboards using Power BI, Tableau, or similar visualization tools.
• Transform raw data into actionable visualizations to support strategic decision-making.

Technical Expertise:

• Leverage Python or R for advanced analytics and data processing tasks.
• Perform data transformation using Power Query or similar tools.

Required Qualifications:

• Bachelor’s degree in engineering (IT&CS, AI/ML, Data Sc.), business Analytics, Marketing, Data Science, or a related field.
• 4+ years of relevant experience in Marketing Analytics, Customer Analytics, BI or related fields.
• Expertise in writing and optimizing complex SQL queries for RDBMS.
• Advanced understanding of relational database management and performance tuning.
• Strong experience with customer lifecycle analytics, including segmentation and statistical modeling.
• Hands-on experience with Power BI (visualization, data modeling, and transformation).
• Exceptional communication skills with the ability to present data insights to non-technical stakeholders.

Preferred Qualifications:

• Experience in the Retail, Distribution, B2B, or B2C domains.
• Familiarity with customer and email marketing analytics.
• Experience creating dashboards in Tableau or other visualization platforms.

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills.