Data Operations Specialist

<p><b>Group Company:</b> 2X Philippines</p> <p class="Designation"><b>Designation:</b> Data Operations Specialist</p> <p class="Office Location"><b>Office Location:</b> Ortigas East Pasig (Office)</p><p></p><p></p> <p style="margin-top:14pt;margin-bottom:14pt;background-size:initial;"><b>Position description:</b> <span style="font-family:'Times New Roman';font-size:11pt;"><span style="font-family:Calibri;font-size:14px;">The Data Operations Specialist serves as a crucial link between marketing data sources and the analytics solutions that depend on them. The role requires the ability to understand different data structures and design reliable data ingestion, transformation, modelling and storage solutions that turn raw marketing data into trusted, reusable data products for analysts and business stakeholders.</span><br /></span><span style="font-family:Calibri;font-size:14px;">The role also requires hands-on experience working with cloud data warehouses, APIs, Python and modern transformation frameworks such as dbt or Dataform. Exposure to building AI-enabled data or analytics solutions is an advantage.</span></p><p class="MsoNormal" style="margin-top:14pt;margin-bottom:14pt;background-size:initial;"></p><p></p><p class="Primary Responsibilities"><b>Primary Responsibilities:</b></p><ul><li>Design, develop, and support reliable data pipelines, warehouses, data models, and reusable data products to support marketing performance analysis and reporting.</li><li>Build and maintain data ingestion from marketing, CRM, advertising and other business systems using managed connectors where appropriate.</li><li>Develop custom API-based data extraction when managed connectors are unavailable or insufficient, including authentication, pagination, incremental extraction, error handling and loading data into the cloud data warehouse.</li><li>Develop and maintain modular SQL transformation workflows using dbt, Dataform, or equivalent transformation frameworks.</li><li>Use Python for API integration, data processing, validation, automation and reusable data-engineering workflows</li><li>Translate business and reporting requirements into scalable technical designs and reusable data models.</li><li>Design and maintain dimensional models, facts, dimensions and analytical data marts.</li><li>Implement data-quality checks, testing, documentation and monitoring to ensure production data products remain reliable.</li><li>Use Git and code-review practices to manage changes to production data transformations and engineering workflows. </li></ul><p><span style="font-weight:bolder;">Required Qualifications:</span></p><ul><li><span style="text-indent:-18pt;font-family:Calibri;color:rgb(0,0,0);font-size:11pt;">3+ years </span><span style="text-indent:-18pt;font-family:Calibri;color:rgb(0,0,0);font-size:11pt;">of experience in analytics engineering, data engineering, data operations, or a related hands-on data role.</span></li><li><span style="text-indent:-18pt;font-family:Calibri;font-size:11pt;">Bachelor’s degree in Information Technology, Engineering, Data Analytics, or a related discipline/ equivalent practical experience.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Advanced SQL skills to build and optimize reusable transformations, facts, dimensions, and analytical data models.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Strong hands-on Python skills for data integration, API interaction, data processing, validation, and automation.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Hands-on experience extracting and processing data from REST APIs, including authentication, pagination, JSON responses, and error handling.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Hands-on experience with dbt, Dataform, or an equivalent SQL-based transformation framework, including modular modelling, dependency management, testing, and version-controlled development.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Hands-on experience with GCP and BigQuery, including working with cloud-based datasets, transformations, and analytical data models.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Experience with managed ingestion tools such as Stitch, Fivetran, or equivalent for extracting and loading data from source systems.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Experience working with marketing, CRM, and marketing-automation platforms such as Salesforce, HubSpot, Marketo, Pardot, or equivalent, with an understanding of their underlying data structures.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Strong knowledge of schema design and dimensional data modelling.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Working knowledge of Git and code-review workflows for managing changes to production data solutions.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Strong understanding of data-quality, testing, documentation, monitoring, and other modern data-engineering practices required to maintain reliable production data products.</span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Proven experience translating business and reporting requirements into scalable technical data solutions. </span></li><li><span style="font-family:Calibri;font-size:11pt;text-indent:-18pt;">Strong command of English and comfortable participating in client-facing meetings with US stakeholders.</span></li><li>Excellent writing, communication and presentation skills. </li><li>Amenable to Hybrid set-up and US shift schedule.</li></ul><p></p>