DATA WAREHOUSE ANALYST (BODS)
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;
Processing of Sourcing transactions related to Vendor PO and Vendor Invoice Processing;
Human resource transaction support services;
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
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.
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
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
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