Mid-Level Data Analyst

Jobtailor; São Paulo; Presencial; BRL 90 000 - 140 000; Tempo integral

Resumo da oferta

Jobtailor in São Paulo, Brazil seeks a data & BI specialist to build and maintain backend databases, develop KPI dashboards, and automate KPI calculations. You will connect Data Lakes to BI tools with SQL/Python, convert Excel rules, and drive data governance. Strong Excel, VBA, and Power Apps skills are required.

The role emphasizes data accuracy, performance monitoring, and collaboration with cross-functional teams to improve business outcomes. Basic English is expected.

Qualificações

• Bachelor’s degree in Engineering, Business Administration, or related field.
• 3 years of experience in data, BI, or analytics roles.
• Ability to create spreadsheets and flowcharts.
• Knowledge of process mapping and data governance.
• Experience with VBA, SQL, and Python programming languages.
• Knowledge of Data Lakes and BI tools; intermediate data structures.
• Knowledge of Power Apps and basic English.

Responsabilidades

• Create, maintain, and manage backend databases for report generation and as a single source of information.
• Build frontend KPI dashboards for various areas of the company.
• Automate calculation of predefined rules using programming languages.
• Connect databases and Data Lakes to BI tools using SQL and Python.
• Convert existing Excel rules and create new rules to automate KPIs.
• Ensure data is accurate and up to date, proposing action plans to improve performance.
• Monitor tools, market trends, and languages and apply them when necessary.
• Develop, maintain, and enhance dashboards, reports, and performance indicators.
• Contribute to data governance, compliance, and information security.
• Map and document business rules, metrics, and processes.
• Develop analytical solutions focused on user experience.
• Monitor data and BI environment performance, proposing architectural improvements.
• Prepare technical documentation, procedures, and training materials.
• Ensure compliance and traceability of corporate figures for management meetings.
• Structure concrete costing for simulators and calculate margins.

Conhecimentos

Analytical Thinking

Problem Solving

Communication

Formação académica

Bachelor’s degree in Engineering, Business Administration, or related field

Ferramentas

SQL

Python

Power Apps

VBA

Data Lakes

Excel

BI Tools

MS Office

Descrição da oferta de emprego

• Create, maintain, and manage backend databases for report generation and as a single source of information
• Build frontend KPI dashboards for various areas of the company
• Manage and prioritize the implementation of improvements to the Reflex award application, developed in Power Apps
• Automate the calculation of predefined rules using programming languages
• Connect databases, including Data Lakes, to BI tools using SQL and Python
• Convert existing Excel rules and create new rules to automate KPIs
• Ensure that data is accurate and up to date, proposing action plans to improve company performance
• Monitor new tools, market trends, and programming languages, applying them when necessary
• Develop, maintain, and enhance dashboards, management reports, and performance indicators
• Contribute to data governance, ensuring compliance, simplicity, best practices, regulatory requirements, and information security
• Map and document business rules, metrics, and processes
• Develop analytical solutions focused on user experience
• Monitor the performance of data and BI environments, proposing improvements to architecture, modeling, and performance
• Prepare technical documentation, procedures, and training materials
• Ensure the compliance and traceability of corporate figures by validating information for management and strategic meetings
• Structure concrete costing for the simulator and calculate concrete margins

Requirements

• Bachelor’s degree in Engineering, Business Administration, or a related field
• 3 years of experience
• Ability to create spreadsheets and flowcharts
• Knowledge of process mapping
• Knowledge of the MS Office suite
• Knowledge of performance and control indicators
• Specific knowledge of the functional area
• Knowledge of VBA, SQL, and Python programming languages
• Knowledge of Data Lakes
• Intermediate proficiency with BI tools
• Intermediate knowledge of data structures
• Knowledge of Power Apps
• Basic English

Core Competencies

Demonstrates expertise in backend database management, KPI dashboard development, and automation using SQL and Python. Proficient in data governance, compliance, and performance monitoring to enhance business processes and decision-making.

Highest-signal resume keywords

• SQL Programming
• Python Programming
• Power Apps DevelopmentData Governance
• Business Process Mapping

Hard Skills

• Database Management
• KPI Dashboard Development
• Automation
• Data Structures
• Excel Rule Conversion
• Performance Indicators
• Flowchart Creation
• VBA Programming
• Data Lakes Knowledge
• BI Tools Proficiency

Soft Skills

• Analytical Thinking
• Problem SolvingCommunication

Industry Keywords

• Data Governance
• Compliance
• Information Security
• Performance MonitoringUser Experience

Tools & Technologies

• MS Office Suite
• Power Apps
• BI Tools