| Immediate need - Datawarehouse Analyst - St Louis, MO (Day1-Onsite) at Remote, Remote, USA |
| Email: [email protected] |
| From: Suchith, ITB [email protected] Reply to: [email protected] Hello Associates, Hope you are doing great today!!! Position: Datawarehouse Analyst Location: St LOUIS, MO ( Day1-Onsite ) Duration: Long term contract JOB DESCRIPTION: SQL server knowledge, SAP Finance & US Tax knowledge is a must. Microsoft Business intelligence, SSIS (SQL Server Integration Service), SSRS (SQL server reporting service), SQL Server & SAP DART is mandatory Fixing the issues on DART/SSIS/SSRS/SQL Server is mandatory. Knowledge to create SQL table (stage and facts) every month on SQL Server to compare the transactional data and data for Recon, Non-Recon and Trail Balance files from SAP-DART. Knowledge to work on GL Close, SAP DART extracts and views. Knowledge to work on profit centers or GL accounts and update in master tables. Knowledge to work on GL account balance mismatches and issue resolution. Knowledge to work on Transaction Data (TD) Extracts for the company codes. Knowledge to work on Master Data (MD) extract Monthly/Yearly Trail balance data extracts to be performed at company code level Audit requests for the previous years to be generated and synchronized. Working on tickets and open tickets to solve the issues related to server configurations and SQL server and secure share drives any other issues. Ticketing tool is Service Now. As a part of year end on DART side, update Profit centers/GL accounts as well to perform the extractions and schedule views communicate with relevant stake holders and work with TDWH team. Work with the tax team on the PC Hierarchy list and perform all the processes for whatever periods the new Profit Centers/GL Accounts were added and check if there are any back postings or layering that needs to be completed. Perform TDWH yearend activities on the flat files (zipping and password protecting the files, Should be able to document the data on DVDs/flash drives to meet customer compliance requirements. Partner closely with internal customers and other technology personnel to define objectives & scope. Build relationships and collaborate cross-functionally to lead project delivery. Manage project deliverables and milestones within approved timelines. Manage and coordinate day-to-day operations and work with offshore team. Identify project issues and facilitate resolution coordinating with relevant teams to resolve issues. Conduct risk management and scenario planning Document decisions and action items of team meetings Warmest Regards, Suchith kumar IT Recruiter ITBrainiac Inc. Princeton Forrestal Village 116 Village Blvd, Suite 200 Princeton, NJ 08540 Direct: # 609 357 9406 EXT*: 101 Email: [email protected] www.itbrainiac.com Keywords: information technology Maryland Missouri New Jersey |
| [email protected] View all |
| Fri Jul 28 18:46:00 UTC 2023 |