Data Automation Engineer/ Data Analyst

6 days ago


Manila, National Capital Region, Philippines Outposter Full time

Hybrid - Manila 1-3 Yrs Exp Master Full-time

Job DescriptionDescription

Overview: We are seeking an experienced Data Automation Engineer / Data Analyst with expertise in both PHP and Python for automating data extraction, analysis, reporting, and building effective data pipelines. The ideal candidate will have a strong background in data automation frameworks, API consumption, and creating reports and dashboards. You should also have experience working with relational databases and SQL for both analysis and automation tasks. The role will require collaboration with stakeholders to ensure data reporting is accurate and matches business needs.

Key Responsibilities:

Automation & Scripting:

  • Develop and maintain automation scripts using PHP and Python (both imperative and object-oriented programming).
  • Work with frameworks like Django, Flask, or Laravel for automation or use vanilla code where appropriate.
  • Break down complex automation problems into manageable tasks and efficiently implement solutions.

Data Extraction & API Integration:

  • Consume and interact with various APIs (RESTful, OData) for extracting data.
  • Utilize ETL tools for processing, transforming, and loading data into systems for reporting and analysis.
  • Build and maintain automated data pipelines for real-time or batch data extraction.

Data Analysis & Reporting:

  • Work with Excel and other data analysis tools to clean and prepare data for analysis and reporting.
  • Create accurate and timely reports with the ability to handle revised or updated data points over time.
  • Utilize aggregation, pivot tables, statistical analysis, and scripting to create meaningful insights and models.
  • Collaborate with stakeholders to ensure that reporting aligns with business reality and objectives.
  • Design and create dashboards and reports that are actionable and insightful for business leaders.

Database & SQL:

  • Design and maintain relational database schemas and queries.
  • Use SQL for creating views, materialized views, CTEs, window functions, and ranking functions to support complex reporting requirements.
  • Develop and optimize stored procedures for automated data manipulation tasks.

Web Front-End Development:

  • Build simple CRUD web interfaces (using front-end frameworks like React, Angular, or Vue) for interacting with databases.
  • Develop a Master-Detail interface for data visualization and management, ensuring usability and simplicity.

Collaboration & Stakeholder Engagement:

  • Work closely with cross-functional teams to gather requirements for reports and data needs.
  • Collaborate with business stakeholders to ensure reporting is accurate and aligned with organizational goals.
  • Document and share automation processes, code, and best practices for future reference.

Requirements:

  • Proven experience with PHP and Python in a professional environment.
  • Familiarity with imperative, object-oriented, and functional programming approaches, with a preference for one or more based on project needs.
  • Strong experience with data extraction from APIs (REST, OData) and working with ETL processes.
  • Strong SQL skills and extensive experience working with RDBMS (MySQL, PostgreSQL, or similar).
  • Knowledge of views, materialized views, CTEs, window functions, and stored procedures.
  • Proficient in using Excel and other tools for data analysis and reporting.
  • Experience building dashboards or reports using BI tools like Tableau, Power BI, or similar.
  • Familiarity with front-end frameworks for building simple CRUD applications.
  • Excellent communication and collaboration skills to work with stakeholders and teams across the organization.
  • Knowledge of best practices in automation, data integrity, and reporting.

Preferred Skills:

  • Experience with data visualization tools (Power BI, Tableau, etc.).
  • Experience with Django, Flask, or Laravel frameworks for web or automation tasks.
  • Knowledge of version control tools like Git.
  • Familiarity with cloud-based data storage or processing platforms.

This role is ideal for someone who has a mix of technical expertise in programming, automation, data analysis, and database management, and is passionate about turning complex data into actionable insights. If you're looking for a dynamic, collaborative environment where you can continuously learn and apply your technical skills to real-world problems, we encourage you to apply.

#J-18808-Ljbffr

  • Manila, National Capital Region, Philippines CEIC Data Company Ltd. Full time

    About CEIC Data Company Ltd.We are an international company dedicated to providing high-quality data solutions. Our team is passionate about delivering exceptional results, and we are committed to fostering a collaborative and innovative work environment.In this role, you will have the opportunity to work on various projects, collaborating with...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation Full time

    Role DescriptionThe Senior Data Infrastructure Engineer will be responsible for designing, implementing, and optimizing cloud-based and hybrid data architectures in an industrial environment. This role requires a deep understanding of cloud computing, database administration, and infrastructure automation.The ideal candidate will have extensive experience...

  • Lead Data Engineer

    6 days ago


    Manila, National Capital Region, Philippines Aboitiz Data Innovation (ADI) Full time

    Hybrid - Manila 3-5 Yrs Exp Bachelor Full-timeJob DescriptionAboitiz Data Innovation (ADI) is one of the leading up and coming start-ups in the field of Data Science and Artificial Intelligence. We believe data can drive change for a better world by advancing businesses across industries and communities.We are seeking a highly skilled Lead/Senior Data...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation Full time

    Aboitiz Data Innovation (ADI) is one of the leading up and coming start-ups in the field of Data Science and Artificial Intelligence. We believe data can drive change for a better world by advancing businesses across industries and communities.We are seeking a highly experienced Senior Data Infrastructure Engineer to design, implement, and optimize...


  • Manila, National Capital Region, Philippines CEIC Data Company Ltd. Full time

    Job DescriptionWe are seeking a highly skilled Research Analyst to join our team at CEIC Data Company Ltd. in the Philippines.The successful candidate will be responsible for maintaining and enhancing the quality and coverage of our in-house economic databases.Maintain and enhance the quality and coverage of in-house economic databases.Data mining and...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation (ADI) Full time

    As a Senior Data Engineering Lead at Aboitiz Data Innovation (ADI), you will be responsible for architecting, developing, and optimizing data pipelines and infrastructure.ResponsibilitiesLead cross-functional collaborations to drive data-driven decision-making within the power generation and energy sector.Design and develop real-time and batch data...


  • Manila, National Capital Region, Philippines CEIC Data Company Ltd. Full time

    About This Role:We are seeking a skilled and motivated individual to join our Data Processing and Automations Team as an Associate IT Business Analyst.Main Responsibilities:The successful candidate will be responsible for:Developing and revising documents in MS Excel that incorporate automation specifications.Performing automation testing and identifying...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation Full time

    Responsibilities and DutiesThe Senior Data Infrastructure Engineer will be responsible for designing, implementing, and optimizing cloud-based and hybrid data architectures in an industrial environment. This role requires a deep understanding of cloud computing, database administration, and infrastructure automation.The ideal candidate will have extensive...


  • Manila, National Capital Region, Philippines Outposter Full time

    Job OverviewOutposter is currently seeking an experienced Data Automation Engineer/Data Analyst to automate data extraction, analysis, reporting, and build effective data pipelines. The ideal candidate will have a strong background in data automation frameworks, API consumption, and creating reports and dashboards.The successful candidate will be responsible...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation Full time

    Company OverviewAboitiz Data Innovation is one of the leading up and coming start-ups in the field of Data Science and Artificial Intelligence. We believe data can drive change for a better world by advancing businesses across industries and communities.Our company is committed to innovation and excellence, always pushing the boundaries of what is possible....


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation (ADI) Full time

    Aboitiz Data Innovation (ADI) is a leader in the field of Data Science and Artificial Intelligence, and we are seeking a Head of Data Solutions to join our team.ResponsibilitiesLead technical mentoring programs, providing guidance to junior and mid-level data engineers.Identify and champion emerging technologies to enhance data engineering capabilities and...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation (ADI) Full time

    Aboitiz Data Innovation (ADI) is a leading player in the field of Data Science and Artificial Intelligence.Job OverviewWe are seeking a highly skilled Chief Data Architect to lead the design, development, and optimization of data pipelines and infrastructure supporting analytics, machine learning, and business intelligence initiatives.Key...


  • Manila, National Capital Region, Philippines Aboitiz Data Innovation (ADI) Full time

    We are seeking a Data Infrastructure Manager to oversee the design, development, and optimization of data pipelines and infrastructure at Aboitiz Data Innovation (ADI).Key ResponsibilitiesDesign and implement highly scalable, resilient, and efficient data architectures for on-premise, hybrid, and cloud-based solutions.Develop and maintain high-performance...


  • Manila, National Capital Region, Philippines Socium - Teams Done Differently Full time

    We are looking for an experienced Enterprise Data Automation Engineer to join our team at Socium. As a member of our team, you will design and manage automated tests to ensure the quality and accuracy of data within the EDW.Your primary responsibility will be to collaborate with the onshore Enterprise Data team to determine necessary test cases, automate...


  • Manila, National Capital Region, Philippines CEIC Data Company Ltd. Full time

    Job Title: Associate IT Business AnalystAt CEIC Data Company Ltd., we are seeking a highly motivated and detail-oriented Associate IT Business Analyst to join our Data Processing and Automations Team.You will act as a liaison between economists and developers, ensuring seamless communication and collaboration.Your key responsibilities include analyzing user...

  • Data Analyst

    3 days ago


    Manila, National Capital Region, Philippines Ascendion Full time

    Responsibilities:Gather business requirements and translate them into effective reports and dashboards.Design and build simple yet powerful visualizations to support business operations and projects.Perform data analysis, mining, and ad hoc queries to uncover insights.Develop and maintain complex SQL queries to handle large datasets efficiently.Act as the...


  • Manila, National Capital Region, Philippines CEIC Data Company Ltd. Full time

    Job Title: Associate IT Business AnalystCompany: CEIC DataLocation: Unit 2704 27F One Corporate Centre, Julia Vargas Ave. Ortigas Pasig City, PhilippinesJob Description:As a key member of our Data Processing and Automations Team, you will focus on key processes such as collecting, processing, and publishing data, with a strong emphasis on maintaining its...


  • Manila, National Capital Region, Philippines FIFTH LEG DATA PRODUCTION, INC. Full time

    FIFTH LEG DATA PRODUCTION, INC. is seeking a highly skilled Test Automation Lead to join our QA team.About the RoleThis is a challenging opportunity for a motivated individual to lead our automated testing efforts, ensuring that our software products meet the highest standards of quality.The successful candidate will be responsible for developing and...

  • Data Analyst

    22 hours ago


    Manila, National Capital Region, Philippines KMC Solutions Full time

    We believe that digitalization and automation will drive the next wave of innovation and cost reduction in large scale solar. To fully unlock the potential of this opportunity, Terabase is developing an interconnected software and construction automation platform. We work alongside project developers, owners, and engineering & construction firms to support...


  • Manila, National Capital Region, Philippines Escalent Full time

    Escalar is committed to helping clients understand human and market behaviors through data-driven insights. We seek a seasoned Data Engineer with expertise in alternative data to join our team.In this role, you will work closely with our offshore alternative data team and equity analysts, economists, and strategists. Your primary responsibility will be to...