Microsoft Business Intelligence with SAP Ticketing

1 month ago

St Louis, United States Avance Consulting Full time

Microsoft Business Intelligence with SAP Ticketing

Work location - St. Louis, MO - 63102

 

Below are the details of the job description: Tax Data Warehouse

  • SQL Server

  • Microsoft Business Intelligence (SSIS SQL Server Integration Service & SSRS SQL Server Reporting Service, SQL Server & SAP DART)

  • SAP Ticketing - Based on reports (Quarterly, Monthly, and Yearly)

  • Fixing issues on DART/SSIS/SSRS/SQL Server

Additional Information:

  • As a team, we work on ETL monthly - SQL tasks and generate flat files for validation by the tax team. These files must be updated promptly on the spreadsheet and secure drive.

  • We also perform reconciliations and validations from our end.

  • ETL tasks are performed on Company Codes.

  • We create SQL tables (stage and facts) every month on SQL Server to compare transactional data and data for Recon, Non-Recon, and Trial Balance files from SAP-DART.

  • Any additions of new profit centers or GL accounts require updating the master tables accordingly.

  • Stage and fact loading, reconciliations, and flat file generation are done using stored procedures. This process must be performed for all company codes to ensure reconciliation.

  • During year-end activities, coordination with the tax team on the PC Hierarchy list is necessary, and the processes are repeated for periods when new Profit Centers/GL Accounts were added.

  • Ensuring no GL account balance mismatches is crucial, as the tax team requires accuracy.

  • We also work on SSRS Reports for all company codes.

  • After the GL Close, SAP DaRT extracts and views need to be manually scheduled and monitored. Process dates/times will be updated.

  • Prior to scheduling, coordination and checks with the LAR contact are required.

  • Transaction Data (TD) Extracts are scheduled for the following company codes

  • Master Data (MD) Extract is scheduled for company codes every month and for the remaining company codes during year-end.

  • Trail balance data extracts are performed for company codes.

  • View files are generated on a monthly basis for the following company codes.

  • Audit requests for previous years are handled.

  • Additionally, she takes care of any tickets related to server configurations, SQL server, and secure share drives for North America and Canada, as well as any other foreseen issues.

  • As part of year-end on the DART end, she updates the Profit Centers/GL accounts to perform extractions and schedule views. After completing all the above processes, she informs the NCI Tax team and TDWH team (both of us) that the views are ready, so we can proceed with the work on the TDWH side.

  • She also performs TDWH year-end activities on the flat files, including zipping and password protecting the files and burning them onto DVDs/flash drives to meet Nestle compliance requirements. Three sets of DVDs need to be prepared once all the year-end processes are complete.

  • Business Intelligence Analyst

    2 weeks ago

    St. Louis, United States GardaWorld Security Services Full time

    Job Summary Business Intelligence AnalystPOSITION SUMMARY:The Business Intelligence Analyst is responsible for providing analysis and reporting on a monthly, quarterly, and ad hoc basis to meet the needs of multiple GWSS departments. The position requires a subject-matter expert on effective and efficient information retrieval and delivery to key...

  • Business Intelligence Analyst

    3 weeks ago

    St Louis, Missouri, United States GardaWorld Security Services Full time

    Job Summary Business Intelligence AnalystPOSITION SUMMARY:The Business Intelligence Analyst is responsible for providing analysis and reporting on a monthly, quarterly, and ad hoc basis to meet the needs of multiple GWSS departments. The position requires a subject-matter expert on effective and efficient information retrieval and delivery to key...

  • Business Intelligence Analyst

    2 days ago

    St Louis, Missouri, United States GardaWorld Security Services Full time

    Job Summary Business Intelligence AnalystPOSITION SUMMARY:The Business Intelligence Analyst is responsible for providing analysis and reporting on a monthly, quarterly, and ad hoc basis to meet the needs of multiple GWSS departments. The position requires a subject-matter expert on effective and efficient information retrieval and delivery to key...

  • SAP Business Analyst

    3 weeks ago

    St Louis, United States Collabera Full time

    New Job Opportunity - SAP SD Principal Business Analyst Mission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows organizations to manage customer and product-related data. Moving to Rise is on the horizon this year (cloud service). This person would be aligned to 1-2 big projects a year. Must Haves: ...

  • SAP Business Analyst

    2 days ago

    St Louis, United States Collabera Full time

    New Job Opportunity - SAP SD Principal Business Analyst Mission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows organizations to manage customer and product-related data. Moving to Rise is on the horizon this year (cloud service). This person would be aligned to 1-2 big projects a year. Must Haves: ...

  • SAP Business Analyst

    7 days ago

    St Louis, United States Collabera Full time

    Description Home Search Jobs Job Description SAP Business Analyst Direct Hire: St Louis, Missouri, US Salary: $75.00 Per Hour Job Code: 349417 End Date: 2024-06-14 Days Left: 15 days, 3 hours left Apply New Job Opportunity - SAP SD Principal Business AnalystMission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows...

  • SAP Business Analyst

    2 weeks ago

    St. Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Sales & Distribution modules. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role...

  • SAP Business Analyst

    1 week ago

    St Louis, United States Collabera Full time

    Description Home Search Jobs Job Description SAP Business Analyst Direct Hire: St Louis, Missouri, US Salary: $75.00 Per Hour Job Code: 349417 End Date: 2024-06-14 Days Left: 17 days, 3 hours left Apply New Job Opportunity - SAP SD Principal Business AnalystMission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows...

  • SAP Business Analyst

    1 week ago

    St Louis, United States Collabera Full time

    Description Home Search Jobs Job Description SAP Business Analyst Direct Hire: St Louis, Missouri, US Salary: $75.00 Per Hour Job Code: 349417 End Date: 2024-06-14 Days Left: 18 days, 3 hours left Apply New Job Opportunity - SAP SD Principal Business AnalystMission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows...

  • SAP Business Analyst

    7 days ago

    St Louis, United States Collabera Full time

    Description Home Search Jobs Job Description SAP Business Analyst Direct Hire: St Louis, Missouri, US Salary: $75.00 Per Hour Job Code: 349417 End Date: 2024-06-14 Days Left: 16 days, 3 hours left Apply New Job Opportunity - SAP SD Principal Business AnalystMission: This person is the go-to for all things SAP SD (sales and distribution). SAP SD allows...

  • SAP Business Analyst

    2 weeks ago

    St Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Sales & Distribution modules. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role...

  • SAP Business Analyst

    15 hours ago

    St. Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Sales & Distribution modules. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role...

  • SAP Business Analyst

    22 hours ago

    St Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Sales & Distribution modules. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role...

  • SAP Business Analyst

    2 weeks ago

    St Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Production Planning (PP/QM/TSW) and Safety/Environmental Compliance (EHSM). As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement...

  • SAP Business Analyst

    22 hours ago

    St Louis, United States Envision Full time

    SAP Senior Business Analyst No C2C, No 3rd party candidates. Must be USC or GC and living in St. Louis, MO.Responsible for providing functional support for SAP Production Planning (PP/QM/TSW) and Safety/Environmental Compliance (EHSM). As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement...

  • SAP Sr Business Analyst

    3 weeks ago

    St. Louis, United States Peabody Energy Full time

    About the role: The SAP Senior Business Analyst is responsible for providing functional support for SAP Sales & Distribution modules at Peabody. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role in the areas of SAP Sales & Distribution...

  • SAP Sr Business Analyst

    2 days ago

    St. Louis, United States Peabody Energy Full time

    About the role: The SAP Senior Business Analyst is responsible for providing functional support for SAP Sales & Distribution modules at Peabody. As a member of the team, this person will work closely with end users in the US and Australia on support issues, enhancement requests and projects. This is a global role in the areas of SAP Sales & Distribution...

  • Coordinator, Pricing Strategy

    4 weeks ago

    St Petersburg, United States Rays Baseball Club LLC Full time

    Job Description Job Description The Coordinator, Pricing Strategy & Ticket Operations will partner with the ticket operations & business analytics teams to support pricing and inventory management decisions for all home games. The ideal candidate will serve as a skilled data analyst with experience and/or interest in dynamic ticket pricing for live events....

  • Coordinator, Pricing Strategy

    1 day ago

    St Petersburg, United States Rays Baseball Club LLC Full time

    Job Description Job Description The Coordinator, Pricing Strategy & Ticket Operations will partner with the ticket operations & business analytics teams to support pricing and inventory management decisions for all home games. The ideal candidate will serve as a skilled data analyst with experience and/or interest in dynamic ticket pricing for live events....

  • CAP/SAP Specialist

    3 weeks ago

    St Louis, United States Parsons Company Full time

    In a world of possibilities, pursue one with endless opportunities. Imagine Next! When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next,...