Supervisor - Ad hoc Analytics

2 days ago

Mandaluyong City, National Capital Region, Philippines Medata Full time $90,000 - $120,000 per year
Job Summary

The Supervisor of Reporting & Data Analytics is responsible for supervising data analysts from the Ad hoc Analytics team. This role involves overseeing all analytics operations to track productivity and ensure quality, mentoring team members, and acting as a strategic consultant for key company initiatives. The Supervisor also plays a crucial role in influencing decision-making across the organization by generating ad hoc reports using SQL and Excel, developing automated MIDAS reports, and managing long-term research-based projects using Excel Dashboards and Power Query, which often support the larger organizational goals.

In terms of client relations, the Supervisor is responsible for managing team members' initiatives on creating slide decks that compare client performance to industry standards. This involves identifying trends and areas for enhancement within the clients' data. Collaboration with Executive Leaders and Corporate Account Executives is carried out to articulate the company's value proposition and competitive advantage.

The role requires a broad understanding of various business aspects, which helps in turning data into useful insights for different groups. The Supervisor will also manage and assign tasks independently via an internal Report Request Queue, each task having a turnaround time set by the business. Adherence of the Supervisor and their team members to these turnaround times and maintenance of the quality standards established by the Analytics leadership are the baseline for performance evaluation. Part of the role is to ensure the accuracy of existing query logic, reporting procedures, and code structures, conduct quality checks, and assist in standardizing queries.

A significant aspect of the role is dedicated to training and documentation, including providing training for Level I and Level II Analysts, maintaining up-to-date training materials, and managing the team's documentation repository.

Primary Duties & Responsibilities

Training and Development:
  • Manage Data Analysts of the Ad hoc Analytics team.
  • Mentor team members in business processes and technical areas as appropriate.
  • Lead training sessions for Level I and Level II Analysts and data outreach projects for business group leadership.
  • Utilize reporting experience to provide directions to Level I and Level II Analysts in weekly stand-up meetings.
  • Maintain training materials up-to-date and manage the team's documentation repository.
  • Develop innovative methods to enhance the presentation of data and advise peers on presentation strategy.

Data Management And Reporting
  • Develop, review, and revise SQL queries using Microsoft SQL Server Management Studio, and translate ad hoc reports into automated solutions using SSRS.
  • Develop reusable stored procedures and maintain a consistent report deployment structure based on departmental standards.
  • Oversee and manage the process of assessing the quality of existing stored procedures and ad hoc reporting logic, ensuring that the functionality of the code aligns with its intended purpose.
  • Generate development standards concerning SQL querying and SQL Server Reporting Services (SSRS).
  • Create, optimize, and maintain reports using advanced Excel functionalities, and design digital dashboards, executive information systems, and reports.
  • Gather, prep, and load data into the warehouse and other repositories for future reporting.

Presentation And Research
  • Develop and deliver client presentations that effectively communicate the value proposition of our data-driven solutions, using data visualization techniques to present complex data in an understandable, compelling format. Present results to key stakeholders and assist in data-driven decision-making.
  • Lead research projects that explore innovative ways to use data for business insights, working closely with different teams to understand their needs and tailor the research accordingly.
  • Leverage cross-business expertise to provide comprehensive data solutions, understanding the unique needs and challenges of different business units and tailoring data analysis and reporting to meet these needs.

Project And Request Management
  • Manage report assignments for the Data Analytics Team through the Report Request Queue, and proactively communicate with team members and requestors regarding field changes, new strategies, or report roadblocks.

Communication And Collaboration
  • Act as a comprehensive advisor to the business regarding analytic capabilities and reporting options.
  • Collaborate with business units to refine requirements for enhancements and new report requests.
  • Contribute to root cause analysis based on workflow issues/inefficiencies, present trends in data, and devise potential solutions.

Qualifications
  • Bachelor's degree in Statistics, Mathematics, Computer Science, or related field. Master's degree is a plus.
  • Experience supervising a team and providing successful results of the services/outcomes measured is preferred or comparable experience.
  • Expertise in SQL and SSRS, including the ability to write complex SELECT statements, expert-level experience with JOINs, WHERE clauses, common syntax, and temporary tables, correct use of conditional filters, nested subqueries, efficient use of indexes, and query optimization.
  • 4 years of experience in SQL Server Reporting Services (SSRS) development and Visual Studio.
  • Quality Assurance (QA) experience is preferred.
  • Experience in data warehousing is preferred.
  • Capable of working with key stakeholders and executive leaders to evaluate potential risks and translate business requirements into layman's terms.
  • Advanced proficiency in Microsoft Excel, including the ability to write complex formulas, use VLOOKUPs, create pivot tables, and create dashboards.
  • Experience in training end users and Data Analyst I & II team members.
  • Ability to communicate ideas in both technical and user-friendly language.
  • Exceptional analytical and problem-solving skills.
  • Leadership and project management skills.
  • Strong written and verbal communication and presentation skills.

  • Expert .NET Developer

    5 days ago

    Quezon City, National Capital Region, Philippines beBeeCrossplatformdeveloper Full time ₱120,000

    Cross-Platform DeveloperWe are seeking a skilled Cross-Platform Developer to join our team on an ad hoc basis. The ideal candidate will have experience in .NET 8 and be familiar with Blazor and Syncfusion components.

  • Google Ads Specialist

    5 days ago

    Mandaluyong City, National Capital Region, Philippines Skyrocket Studios Global Full time

    OverviewGoogle Ads Specialist – remoteResponsibilitiesPlan, launch, and manage end-to-end Google Ads campaigns, including Search, Display, YouTube, Shopping, and Performance Max.Conduct keyword research, audience targeting, and ad copywriting to ensure high-quality, relevant ads.Continuously optimize campaigns for performance, including bid adjustments,...

  • Ad Operations Specialist

    4 weeks ago

    Mandaluyong City, National Capital Region, Philippines ACCPRO International Full time

    We're Hiring: Ad Operations SpecialistMandaluyong City | Remote | Dayshift | FulltimeRESPONSIBILITIES:-Manage and optimize digital marketing campaigns across search, programmatic, display, and social media platforms.-Conduct campaign performance analysis, reporting, and provide actionable recommendations.-Strategize, execute, and optimize PPC and paid social...

  • Ad Operations Specialist

    2 days ago

    Mandaluyong City, National Capital Region, Philippines ACCPRO International Full time $40,000 - $80,000 per year

    We're Hiring: Ad Operations SpecialistMandaluyong City | Remote | Dayshift | FulltimeRESPONSIBILITIES:-Manage and optimize digital marketing campaigns across search, programmatic, display, and social media platforms.-Conduct campaign performance analysis, reporting, and provide actionable recommendations.-Strategize, execute, and optimize PPC and paid social...

  • Ad & Promo Supervisor (PR & Events)

    2 days ago

    Makati City, National Capital Region, Philippines Gentem Consulting Full time ₱900,000 - ₱1,200,000 per year

    Responsibilities:Create copies (e.g. event/promo title, tagline, and catchphrase) for marketing collaterals and advertisements of events, promos, and activities.Development of strategic communication and media plans for launches, events, promos, and activities / Marketing Communications.Creation and submission of press release articles.Monitoring and...

  • Retail Supervisor

    2 days ago

    Mandaluyong City, National Capital Region, Philippines Enabled Full time ₱104,000 - ₱130,878 per year

    JOB SUMMARY:The Sales Specialist (Retail) will lead a team of sales associates to meet company sales objectives. Key responsibilities include ensuring high-quality customer responses, developing sales strategies and forecasts, preparing sales reports and administrative documents, and conducting refresher training for associates. The position also requires...

  • Assistant Supervisor for Operations

    6 days ago

    Quezon City, National Capital Region, Philippines Ipsator Analytics Pvt Ltd Full time

    OverviewAssistant Supervisor for Operations serves as a department's team lead for technical specialists, supporting the primary supervisor with day-to-day management and administrative functions. He/She will report directly to the Quality Assurance Supervisor.ResponsibilitiesEnsure quality & on time delivery of services & treatments to new business and...

  • Sales Supervisor

    2 days ago

    Mandaluyong City, National Capital Region, Philippines Enabled Full time ₱300,000 - ₱400,000 per year

    JOB SUMMARY: The Sales Specialist (Retail) will lead a team of sales associates to meet company sales objectives. Key responsibilities include ensuring high-quality customer responses, developing sales strategies and forecasts, preparing sales reports and administrative documents, and conducting refresher training for associates. The position also requires...

  • Manager, Risk Intelligence and Analytics

    1 week ago

    Quezon City, National Capital Region, Philippines Manulife Insurance Malaysia Full time

    Manager, Risk Intelligence and AnalyticsPostulerLocations: Quezon City, Lapu Lapu CityType: Temps pleinPosted on: HierApplication deadline: 30 août 2025 (Il reste 27 jours pour postuler)Job OverviewThe Manager, Risk Intelligence and Analytics, supporting the Global Wealth and Asset Management (GWAM) Risk function, will be responsible for delivering various...

  • Shared Services Data Analytics Specialist

    3 weeks ago

    Makati City, National Capital Region, Philippines AIA Hong Kong Full time

    At AIA we've started an exciting movement to create a healthier, more sustainable future for everyone.It's about finding new ways to not only better people's lives, but to better the communities and environments we live in. Encompassing our ambition of helping a billion people live Healthier, Longer, Better Lives by 2030.And as part of our marketing,...