This job ad has been posted over 40 days ago...
0
applicants
Data warehouse Analyst
at abhishek.mishrarecruiter in Missouri
Location: St. Louis, MO (Hybrid ? 3 days onsite)
Job Type: Contract
Note ? Look for candidates with SAP DART, GL account, and strong with
DART/SSIS/SSRS/SQL Server.
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 a 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 and any other issues. The
ticketing tool is Service Now.
As a part of year-end on the DART side, update Profit centers/GL accounts
as well to perform the extractions and schedule views communicate with relevant
stakeholders, 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 DVD?s/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 the offshore team.
Identify project issues and facilitate resolution by coordinating with
relevant teams to resolve issues.
Conduct risk management and scenario planning
Document decisions and action items of team meetings
Reference : Data warehouse Analyst jobs
Reference : Data warehouse Analyst jobs
Recent jobs at abhishek.mishrarecruiter
SAP ABAP at abhishek.mishrarecruiter in Michigan
21-04-2024
Azure Devops with Python at abhishek.mishrarecruiter in Washington
27-03-2024
Intune Administrator at abhishek.mishrarecruiter in Missouri
29-02-2024
.Net Full Stack Developer at abhishek.mishrarecruiter in Pennsylvania
26-12-2023
MuleSoft Developer/Lead at abhishek.mishrarecruiter in Florida
26-12-2023
Published at 10-08-2023
Viewed: 59 times
Viewed: 59 times