Business Intelligence Analyst – Warehousing and Distribution

Jobtailor; Sorocaba; Presencial; BRL 60 000 - 90 000; Tempo integral

Resumo da oferta

Jobtailor in Sorocaba, SP, is seeking a data analyst to generate KPI reports for customer service and supply chain, and to build databases and dashboards. The role includes SQL-based analyses to uncover trends and issues, as well as automations with Python and VBA to boost efficiency.

Collaboration with operations, IT, and data teams is essential, with opportunities to apply generative AI to accelerate work.

Qualificações

• Bachelor's degree completed.
• Experience in data analysis.
• Intermediate SQL for data extraction and analysis.
• Intermediate Python for data processing and analysis in notebooks.
• Experience with Microsoft Access, including integration with Excel and VBA.
• Knowledge of Databricks is a plus.
• Intermediate Power BI for modeling and dashboard creation.
• Intermediate VBA for automating routines in Excel and Access.
• Availability to work in Sorocaba, SP.

Responsabilidades

• Generate and maintain customer service and Supply Chain KPI reports.
• Develop and maintain databases, queries, and processes in Microsoft Access.
• Perform SQL analyses to identify root causes, trends, and opportunities for improvement.
• Create and maintain Power BI dashboards.
• Develop automations using Python and VBA to reduce manual tasks.
• Use generative AI to accelerate analyses, documentation, testing, and prototyping.
• Collaborate with operations, IT, data engineering, and customer service.

Conhecimentos

Data Analysis

SQL

Python

Power BI

VBA

Data Visualization

Data Querying

Database Development

Microsoft Access

Formação académica

Bachelor's degree (completed)

Ferramentas

Microsoft Access

Power BI

Databricks

VBA

Descrição da oferta de emprego

• Generate and maintain customer service and Supply Chain KPI reports
• Develop and maintain databases, queries, and processes in Microsoft Access
• Perform SQL analyses to identify root causes, trends, and opportunities for improvement
• Create and maintain Power BI dashboards
• Develop automations using Python and VBA to reduce manual tasks
• Use generative AI to accelerate analyses, documentation, testing, and prototyping
• Collaborate with operations, IT, data engineering, and customer service

Requirements

• Bachelor's degree (completed)
• Experience in data analysis
• Intermediate SQL for data extraction and analysis
• Intermediate Python for data processing and analysis in notebooks
• Experience with Microsoft Access, including integration with Excel and VBA
• Knowledge of Databricks is a plus
• Intermediate Power BI for modeling and dashboard creation
• Intermediate VBA for automating routines in Excel and Access
• Availability to work in Sorocaba, SP

Core Competencies

Proficient in data analysis and reporting, with strong capabilities in SQL, Python, and Power BI for data processing and visualization. Experienced in developing automations and maintaining databases to enhance operational efficiency.

Highest-signal resume keywords

• Data Analysis
• SQL
• Python
• Power BI
• VBA

ATS Optimization Keywords

Hard Skills

• Data Analysis
• SQL
• Python
• Power BI
• VBA
• Microsoft Access
• Database Development
• Data Querying
• Data VisualizationAutomation

Soft Skills

• Collaboration

Industry Keywords

• Customer Service
• Supply Chain
• KPI Reports
• Data Engineering

Tools & Technologies

• Microsoft Access
• Power BI
• Databricks