Data Analyst_BGC Taguig_Day Shift

We are urgently hiring for a Data Analyst - Macros and Data Visualization.

Location: BGC Taguig

Work Setup & Shift: Onsite | Day Shift

This role plays a pivotal part in enabling SDR success, improving lead quality, and driving operational excellence through structured data management and performance analytics.

What You'll Need

• 1-3 years of experience in data analytics
• Experience in a B2B environment is preferred.
• Proficiency in CRM platforms (e.g. Salesforce).
• Strong Microsoft Excel skills; experience with macros and data visualization tools (e.g., Tableau, Power BI) is a plus.
• Strong organisational and time management skills.
• Excellent attention to detail and accuracy in data handling.
• Effective communication and collaboration skills across teams.
• An analytical mindset with the ability to interpret data and generate insights.

About The Role A highly organised and analytical professional responsible for designing, maintaining, and optimizing an Excel-based CRM system to support sales development operations and lead management. This role ensures data accuracy, operational efficiency, and performance visibility across the sales development function.

What You'll Do

• CRM Design & Maintenance: Build and scale a custom Excel-based CRM (utilising Macros and Power BI), ensuring stability, usability, and adaptability to team needs.
• SDR Tab Management: Create and manage individual SDR tabs with standardised fields for prospect data, including contact details, provider info, device types, and expiry timelines.
• Data Standardisation & Quality Control: Implement dropdown menus and formatting rules to ensure consistency across disposition, sentiment, and cadence types; regularly audited SDR-entered data for accuracy and completeness.
• Lead Management & Distribution: Maintain master account lists and distribute monthly lead allocations; de-duplicate records across SDR tabs to prevent overlap.
• Cadence & Outreach Structuring: Organise SDR outreach workflows and cadence templates for streamlined engagement.
• Performance Tracking & Reporting: Automate dashboards utilising Power BI and Macros to monitor key SDR metrics (calls, emails, meetings, opportunities); track individual and team performance using status fields and build summary reports for leadership.
• Insights & Analytics: Developed heatmaps and trend reports to identify high-performing activities; supported campaign effectiveness reviews and lead quality assessments.