KPI Analyst – Mid-Level

Jobtailor; Deutschland; Remote; EUR 45.000 - 65.000; Vollzeit

Zusammenfassung

Jobtailor is seeking a data analytics professional to extract insights from diverse data sources, build reliable dashboards, and support data-driven decision making.

You will own SQL queries, ETL pipelines, data quality checks, and collaborate with internal clients to translate business needs into data solutions; Python, AWS, and BI tools are valued assets. Experience with Data Warehouse/Lake concepts and NoSQL is beneficial.

Qualifikationen

• Bachelor's degree in a related field.
• 1–2 years of experience in data analytics or BI.
• Strong SQL skills and ability to write complex queries.
• Experience with Tableau/Power BI and data visualization.
• Knowledge of ETL processes or building data pipelines.
• Ability to interpret data and generate business insights.
• Familiarity with LGPD/data protection regulations is a plus.

Aufgaben

• Execute SQL queries to extract, transform, and validate data.
• Assist in building and maintaining data pipelines and ETL processes.
• Support maintenance of databases and Data Warehouse or Data Lake structures.
• Support data quality activities to ensure reliability of analyses.
• Support development and maintenance of dashboards and reports.
• Support KPI formulation, monitoring, and trend analysis.
• Interact with internal clients to gather requirements and translate business needs into data solutions.
• Help document business rules, data dictionaries, and technical specifications.

Kenntnisse

SQL

Data Visualization

ETL Processes

Data Analysis

Python

Data Quality Assurance

NoSQL Databases

Machine Learning Concepts

Agile Methodologies

Ausbildung

Bachelor’s degree in Data Analytics, Business Administration, Statistics, Engineering, Computer Science, or related field

Tools

Tableau

Power BI

Git

AWS

Spark

Jobbeschreibung

• Execute SQL queries to extract, transform, and validate data from various sources.
• Assist in building and maintaining data pipelines and ETL processes.
• Support the maintenance of databases and Data Warehouse or Data Lake structures.
• Support data quality activities to ensure the reliability of analyses.
• Support the development and maintenance of management and operational dashboards and reports.
• Support the formulation, updating, and validation of key performance indicators (KPIs), monitoring performance and trends.
• Conduct basic descriptive analyses and data checks, identifying patterns and anomalies.
• Use visualization, ETL, and analytics tools in accordance with team guidelines.
• Interact with internal clients to gather requirements, translating business needs into data solutions.
• Support the documentation of business rules, data dictionaries, and technical specifications.
• Support data, BI, ML, and AI projects.
• Operate in compliance with information security policies and Brazil’s General Data Protection Law (LGPD).

Requirements

• Bachelor’s degree in Data Analytics, Business Administration, Statistics, Engineering, Computer Science, or a related field.
• At least 1–2 years of experience in data analytics or Business Intelligence (BI).
• Strong knowledge of SQL, including creating complex queries and performing basic optimization.
• Proven experience with data visualization tools such as Tableau, Power BI, or similar platforms.
• Knowledge of ETL processes or experience building and maintaining data pipelines.
• Ability to interpret data, identify patterns, and generate relevant business insights.
• Strong attention to detail and commitment to data quality and accuracy.
• Excellent interpersonal communication skills and the ability to produce clear, concise documentation.
• Willingness and interest in learning new technologies and methodologies.
• Experience with Python for data analysis, data manipulation, and automation.
• Knowledge of Data Warehouse and Data Lake concepts and structures.
• Experience with code version control tools such as Git.
• Experience using Apache NiFi, Apache Airflow, and Spark.
• Familiarity with basic Machine Learning (ML) and Artificial Intelligence (AI) concepts.
• Knowledge of NoSQL databases.
• Experience with cloud platforms such as AWS.
• Certifications in BI, data analytics, or specific tools.
• Experience with Agile methodologies such as Agile/Scrum.

Core Competencies

Proficient in SQL for data extraction and transformation, with experience in data visualization tools like Tableau and Power BI. Strong understanding of ETL processes, data quality assurance, and compliance with data protection regulations.

Highest-signal resume keywords

• SQL Query Optimization
• Data Visualization with Tableau
• ETL Process Development
• Data Warehouse and Data Lake Knowledge
• Python for Data Analysis

Hard Skills

• SQL
• Data Visualization
• ETL Processes
• Data Analysis
• Python
• Data Quality Assurance
• NoSQL Databases
• Machine Learning Concepts
• Apache NiFi
• Apache Airflow

Soft Skills

• Interpersonal Communication
• Attention to Detail
• Documentation Skills
• Problem-Solving
• Willingness to Learn

Certifications & Qualifications

• BI Certification
• Data Analytics Certification

Industry Keywords

• Data Analytics
• Business Intelligence
• Data Quality
• General Data Protection Law (LGPD)
• Agile Methodologies

Tools & Technologies

• Tableau
• Power BI
• Git
• AWS
• Spark