FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesERPETLSQLVBA
About the role
Key responsibilities & impact- Receive requests for development of BI management dashboards.
- Discuss business model requirements for table and dashboard development with requesting management analysts or service stakeholders.
- Support the selection and construction of databases and associative tables for each dashboard, as well as the design of the data structure to be used.
- Gather and analyze requirements for the dashboards to be developed.
- Present an initial project proposal requesting approval to proceed.
- Inform requesters of any issues that may prevent task execution and work with them to find solutions.
- Develop and maintain systems to automate tasks using SAP Script, BW/BEx Analyzer queries, Power BI, Spotfire, Access, Excel, VBA, among others.
- Prepare and structure databases, including handling large volumes of structured and unstructured data from multiple sources, for calculation of various KPIs.
- Provide support for generating reports from structured data sources.
- Provide support for generating reports from unstructured data sources.
- Provide support for producing analytical reports based on information from the procurement process for goods and services.
- Extract procurement and contracting information using predefined reports in SAP BW and SAP ERP, such as contracts, purchase orders, amendments, etc.
- Participate in meetings to define demand forecasting scope and in meetings presenting results.
- Extract contract and order information using predefined reports in the SAP system.
- Support the preparation of a dossier describing the steps of the report generation process.
- Build and modify dashboards.
- Perform support activities required for market and risk monitoring.
- Critically analyze systems used by the management team and suggest improvements or replacements.
- Implement necessary corrections before and after the development of dashboards and business models.
- Assemble tables, dashboards and presentations with information, indicators, projections and correlations to support analysis and decision-making.
- Perform maintenance or updates on developed dashboards, whether created by the contractor or other parties.
- Update databases to enable subsequent updates of dashboards, tables and reports.
- Provide support, training and assistance to users of dashboards, reports and presentations, when necessary.
- Perform uploads and downloads of dashboard data in internal systems whenever requested.
- Perform other data structuring and reporting activities to support management and procurement routines.
- Attend meetings and deliver presentations about related activities when requested.
- Analyze processes, identify best practices, gaps and improvement opportunities; prepare and update procedures, work instructions, technical notes, standards, documents, step-by-step guides, schedules, flowcharts, diagrams, reports, communications and training materials related to the activity.
- Other related or similar activities.
Requirements
What you’ll need- Advanced knowledge of Microsoft Office suite.
- Knowledge of SAP.
- Knowledge of SAP BW.
- Advanced Excel skills.
- Advanced Power BI skills.
- Advanced knowledge and use of ETL processes.
- Advanced knowledge and use of M and DAX languages.
- Knowledge of SQL and Python.
- Bachelor's degree in International Trade, Business Administration, Engineering, Statistics, Systems Analysis, Computer Science, Computer Engineering, Systems Development or Information Technology Management.
- 4 (four) years of experience performing the duties described above.
Benefits
Comp & perks- Health
- Diversity and Inclusion
- Training and Development
- Wellness Programs
- Opportunities for professional development
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Data AnalysisDashboard DevelopmentReport GenerationData StructuringM LanguageDAX LanguagePythonSAP KnowledgeSQLETL Processes
Soft Skills
Problem SolvingCommunicationCollaborationCritical ThinkingTraining and Support