Microsoft Business Intelligence with SAP Ticketing

1 month ago

Saint Louis, United States Avance Consulting Full time
Job DescriptionJob Description

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.

  • Microsoft Business Intelligence with SAP Ticketing

    1 month ago

    St. Louis, United States Avance Consulting Full time

    Microsoft Business Intelligence with SAP TicketingWork location - St. Louis, MO - 63102 Below are the details of the job description: Tax Data WarehouseSQL ServerMicrosoft Business Intelligence (SSIS SQL Server Integration Service & SSRS SQL Server Reporting Service, SQL Server & SAP DART)SAP Ticketing - Based on reports (Quarterly, Monthly, and...

  • 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

    1 week 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

    3 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 Developer II

    1 day ago

    St Louis, United States Medical Transportation Management Inc. Full time

    What Will Your Job Look Like? The Business Intelligence Developer II will define, develop, and deploy complex dashboards, reports, online analytical processing (OLAP), and visualizations to enable metrics-driven decisions. The Business Intelligence Developer II will be able to understand business activities in multiple business/functional areas and be able...

  • SAP Senior Business Analyst

    5 days ago

    Saint Louis, United States The Timberline Group Full time

    Job DescriptionJob DescriptionMust be US Citizen or Green Card holder, no C2C.The SAP Senior Business Analyst is 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,...

  • Senior Business Intelligence Developer

    1 day ago

    St Louis Park, United States Center For Diagnostic Imaging Full time

    RAYUS Radiology, formerly Center for Diagnostic Imaging and Insight Imaging, is looking for a Senior BI Developer to join our team. We are challenging the status quo by shining light on radiology and making it a critical first step in diagnosis and proper treatment. Come join us and shine brighter together! As a Senior BI Developer, This role focuses on the...

  • Managing Partner

    3 weeks ago

    Saint Louis Park, MN, United States SAP Full time

    We help the world run betterOur company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...

  • SAP Business Analyst

    3 weeks ago

    Saint Louis, MO, 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: Bachelor's...

  • Sr Business Intelligence Developer

    2 weeks ago

    Saint Paul, Minnesota, United States Legrand AV, Inc. Full time

    Thank you for your interest in becoming part of the team at LegrandGENERAL PURPOSEThe Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data, enabling our executive-level stakeholders and businesses to make informed decisions. We are currently in search of a highly skilled and experienced Senior Business...

  • Sr Business Intelligence Developer

    2 weeks ago

    Saint Paul, Minnesota, United States Legrand AV, Inc. Full time

    Thank you for your interest in becoming part of the team at LegrandGENERAL PURPOSEThe Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data, enabling our executive-level stakeholders and businesses to make informed decisions. We are currently in search of a highly skilled and experienced Senior Business...

  • Sr Business Intelligence Developer

    1 week ago

    Saint Paul, Minnesota, United States Legrand AV, Inc. Full time

    Thank you for your interest in becoming part of the team at LegrandGENERAL PURPOSEThe Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data, enabling our executive-level stakeholders and businesses to make informed decisions. We are currently in search of a highly skilled and experienced Senior Business...

  • Sr Business Intelligence Developer

    1 week ago

    Saint Paul, Minnesota, United States Legrand AV, Inc. Full time

    Thank you for your interest in becoming part of the team at LegrandGENERAL PURPOSEThe Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data, enabling our executive-level stakeholders and businesses to make informed decisions. We are currently in search of a highly skilled and experienced Senior Business...

  • SAP Business Analyst

    1 week 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

    4 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 BW-GCP/Azure

    2 weeks ago

    Lake Saint Louis, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionClient LocationSt. Louis, MO Open to Remote full time, prefer local candidatesDon't send candidates from California, Seattle, Portland, West coast, Only Send candidate from Central time zone or EST, MSTRequiredSAP BW 5+ years (Business Warehouse)GCP Google Cloud Platform Azure - Validate Azure Lakehouse database views and...

  • Ticketing/Exchange Agent

    1 week ago

    Saint Louis, United States ADTRAV Travel Management Full time

    Job DescriptionJob DescriptionADTRAV Travel Management, founded in 1977, has over four decades of experience in managing corporate, government, vacation, group, meetings, and incentive travel programs across the United States. We have experienced steady growth throughout our history and are currently ranked as one of the top business travel management...

  • SAP Business Analyst

    2 weeks 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

    3 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

    2 weeks 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...