Data Warehouse Analyst - BODS
3M
San Juan City, Philippines
6d ago
source : ictjob.ph

DATA WAREHOUSE ANALYST (BODS)

3M i

s looking for Data Warehouse Analyst (BODS) who will join their growing team in Bonifacio Stopover, BGC, Taguig City .

The Philippines site, located at the Bonifacio Stopover Corporate Center, is the third and final Global Service Center (GSC) of 3M Company , which will bring all the advantages of the GSC model to the Asia Pacific region.

  • It is responsible for optimizing 3M Company's delivery of transactional services in the region, and essentially strengthens 3M Company'
  • s operations around the world, as all three GSCs will work together to bring the highest level of service no matter where they are.

    3M Service Center will partner with the other GSCs to provide around-the-clock global service. It will host activities ranging from, among others, sourcing, IT, Finance, human resources, all of which are IT-enabled.

    3M Global Service Center in the Philippines intends to provide a full range of IT-enabled Business Process Outsourcing IT-

    enabled professional services in Finance, Sourcing, Human Resources, and IT solutions from the Philippines , for 3M Company, such as :

  • Record-to-Report - Processing of Financial Transactions that include Accounts Receivables processing, Payments processing, Fixed Assets and Projects processing, General Ledger and Month end closing activities and Reporting;
  • Source-to-Pay

  • Processing of Sourcing transactions related to Vendor PO and Vendor Invoice Processing;
  • Hire-to-Retire

  • Human resource transaction support services;
  • Master Data

  • Master data management;
  • Global Operations Support

  • SAP Global Operations Support services that include the areas of IT support, SAP Incident and Change Request management; and
  • Business Services

  • Processing of activities related to Customer Service e.g. account management, standard pricing and maintenance, customer data management.
  • 3M Company was incorporated in 1929 under the laws of the State of Delaware, USA to continue its business operations that started as early as 1902 .

    3M's head office is located at St. Paul, Minnesota, USA . 3M is a diversified technology company with global presence over more than 65 countries including 29 international companies with manufacturing operations and 35 companies with laboratories .

    3M Service Center APAC, Inc. was registered with the Securities and Exchange Commission on 08 September 2015. It is wholly-

    owned by 3M Singapore Pte. Ltd.

    JOB OVERVIEW

    The Data Intelligence ETL Developer - SAP BODS is part of the Global Reporting and Analytics Team at the Global Service Center in the Philippines.

    They will be working in close collaboration with the global team in creating data warehouse solutions based on functional designs using an iterative development process.

    The ETL developer should be able to develop and maintain BODS ETL / ELT jobs associated with data movement from various source systems into data warehouses such as HANA and Teradata, and from HANA or Teradata to cloud.

    As Data Warehouse Analyst (BODS) , you are expected to do the following tasks :

  • Analyzes and reviews business requirements and helps create functional design documents
  • Conducts impact analysis on development work
  • Candidate must have the skill to develop, analyze and debug SQL queries and must be proficient in a scripting language
  • Executes testing and validation and cutover activities for developed objects
  • Performs data loading
  • Ensures proper procedures are followed and appropriate documentation is created
  • Experience in ETL integrating BODS with SAP and non-SAP data sources such as SAP ERP, SAP BW
  • Experience in Data modeling and migrating data using the best practices in Oracle / MS SQL / Access
  • QUALIFICATIONS

  • Bachelor's Degree in Computer Science or equivalent combination of education and experience
  • 3+ years of experience in SAP Data Services (BODS)
  • Extensive knowledge with ETL / ELT
  • 2-4 years of knowledge and experience working with data warehousing
  • Must have vast knowledge of database design and modeling in the context of data warehousing
  • Must be skilled in diagnosing complex data warehouse ETL process, business logic failures, and data flows, in order to quickly resolve issues .
  • Minimum 2 years delivering complex data management engagements such as scoping, planning, requirements gathering, design, development, testing, and go live
  • Has knowledge / experience in working with SAP BW / HANA / Teradata / any cloud platform
  • SKILLS

  • Very strong SQL skills
  • Superb trouble-shooting skills and tenacity in problem solving
  • Passionate focus on customer support and the ability to build long term, successful working relationships with Clients
  • Strong knowledge of key application functionality, tables and relationships
  • Excellent interpersonal, presentation and communication skills - verbal & written
  • Attention to detail and the ability to learn quickly
  • Extreme focus on Client satisfaction
  • Demonstrated ability to work independently and as part of a team
  • Ability to work calmly and professionally in high pressure situations
  • The ability to work effectively with remote teams in a virtual environment
  • Willing to work in BGC, Taguig City
  • Amenable to be assigned on regular working hours (9AM - 6PM / 8AM -5PM)
  • 1 FULL TIME position is available
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form