Discover your 100% YOU with MicroSourcing!
Position: Data Analyst
Location: Philippines
Work setup & shift: Work from Home | Night shift
Why join MicroSourcing
You'll Have
- Competitive Rewards: Enjoy above-market compensation, healthcare coverage on day one, plus one or more dependents, paid time-off with cash conversion, group life insurance, and performance bonuses
- A Collaborative Spirit: Contribute to a positive and engaging work environment by participating in company-sponsored events and activities.
- Work-Life Harmony: Enjoy the balance between work and life that suits you with flexible work arrangements.
- Career Growth: Take advantage of opportunities for continuous learning and career advancement.
- Inclusive Teamwork: Be part of a team that celebrates diversity and fosters an inclusive culture.
Your Role
As a Data Analyst you will:
- Analyze paid advertising performance across platforms including Google Ads, Microsoft Ads, Meta Ads, and StackAdapt using raw and aggregated data.
- Write and maintain advanced SQL queries in Snowflake to extract, transform, and analyze large datasets from multiple marketing and analytics sources.
- Build data models that connect paid media data with website traffic, event-level data, and purchase/conversion data.
- Analyze Google Analytics 4 data, including traffic sources, user behavior, funnels, and event tracking, to support paid media optimization.
- Combine raw event data from Google Ads and GA4 to create end-to-end attribution and performance analysis.
- Develop dashboards, reports, and ad hoc analyses to support marketing and leadership decision-making.
- Identify trends, anomalies, and performance insights related to spend efficiency, ROAS, CPA, and conversion behavior.
- Collaborate closely with paid media, marketing, and analytics stakeholders to define reporting requirements and analytical frameworks.
- Ensure data accuracy, consistency, and documentation across reporting outputs.
What You Need
Non-negotiables
- Relevant Experience: Typically 36 years of experience in a data or marketing analytics role.
- Advanced SQL Expertise: This is the primary technical requirement. Candidates must have hands-on experience querying, cleaning, and structuring raw, unstructured, or semi-structured data.
- Foundational Paid Media Knowledge: A solid understanding of how platforms like Google Ads and Meta Ads function is required to analyze campaign data effectively.
- Web Analytics (GA4): Practical experience analyzing online customer journeys, specifically regarding event-based tracking, traffic acquisition, and conversion paths.
- Data Visualization & Reporting: Proven ability to build models and dashboards using tools such as Looker Studio, Tableau, or Power BI to present decision-ready insights.
- Analytical Reasoning: Strong statistical skills to identify patterns, spot anomalies, and translate raw data into logical business conclusions.
- Advanced Spreadsheet Skills: Proficiency in Excel or Google Sheets for quick data validation, reconciliations, and ad-hoc modeling.
Preferred Skills/expertise
- Secondary Ad Platforms: Familiarity with Microsoft Ads or programmatic platforms such as StackAdapt, MNTN, or AdRoll.
- Industry Background: Prior experience in e-commerce, insurance, or high-performance digital marketing environments.
- Technical Environment: While Snowflake is not a strict requirement, experience with cloud data warehouses and advanced data modeling is a strong plus.
About MicroSourcing
With over 9,000 professionals across 13 delivery centers, MicroSourcing is the pioneer and largest offshore provider of managed services in the Philippines.
Our commitment to 100% YOU
MicroSourcing firmly believes that our company's strength lies in our people's diversity and talent. We are proud to foster an inclusive culture that embraces individuals of all races, genders, ethnicities, abilities, and backgrounds. We provide space for everyone, embracing different perspectives, and making room for opportunities for each individual to thrive.
At MicroSourcing, equality is not merely a slogan it's our commitment. Our way of life. Here, we don't just accept your unique authentic self - we celebrate it, valuing every individual's contribution to our collective success and growth. Join us in celebrating YOU and your 100%!
For more information, visit https://www.microsourcing.com/
