Senior Data Analyst

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

Zusammenfassung

Jobtailor seeks a BI Developer to build Power BI dashboards, consolidate data from multiple sources, and create interactive visuals to track KPIs and results. You will analyze project data, generate insights, and prepare data for AI initiatives.

Responsibilities include designing data environments such as Data Lakes, Data Warehouses, and Data Marts, and implementing ETL/ELT processes while optimizing SQL queries for performance. Collaboration with data teams is essential.

Qualifikationen

• Solid experience with Microsoft Power BI and BI concepts.
• Advanced SQL proficiency and optimization of complex queries.
• Experience with data processing, cleansing, and integration.
• Knowledge of ETL/ELT processes, jobs, and data orchestration.
• Experience with data modeling for Data Warehouses, Lakes, and Marts.
• Strong analytical skills and ability to derive insights from data.
• Familiarity with relational/multidimensional databases.

Aufgaben

• Develop dashboards and management reports in Power BI to track KPIs.
• Analyze project data and portfolios to monitor performance.
• Prepare data environments (Data Lakes/L warehouses) for AI/ML and cognitive solutions.
• Design and structure data environments following best practices.
• Develop and monitor ETL/ELT processes for reliable data availability.
• Perform data cleansing and standardization on large data volumes.
• Develop and optimize SQL queries for performance.
• Map data sources and support architectural evolution for business needs.

Kenntnisse

Power BI expertise

Advanced SQL

Data analysis

Analytical thinking

Data-driven storytelling

Tools

Microsoft Power BI

SQL

ETL/ELT tools

APIs integration

Data Warehouses/Data Lakes/Data Marts

Jobbeschreibung

Develop dashboards and management reporting panels in Microsoft Power BI, consolidating data from multiple sources and creating interactive visualizations to track KPIs and results
Analyze project data and portfolios, generating studies and insights to monitor deliverables, KPIs, and the software factory’s performance
Prepare and structure databases for use by Artificial Intelligence, Machine Learning, and cognitive engine solutions
Design and structure data environments, such as Data Lakes, Data Warehouses, and Data Marts, following industry best practices
Develop, configure, and monitor ETL/ELT processes and jobs, ensuring the continuous and reliable extraction, transformation, and availability of data
Perform data processing, cleansing, and standardization, including large volumes of structured and unstructured data
Develop and optimize SQL queries, conducting performance analysis, tuning, and improvements to complex queries
Map analytical data sources and support the evolution of the architecture and structuring of information for consumption by different business areas and solutions

Requirements

• Solid experience with Microsoft Power BI and Business Intelligence concepts
• Advanced SQL proficiency, including the development and optimization of complex queries
• Experience with data processing, transformation, cleansing, and integration
• Knowledge of ETL/ELT processes, jobs, and data orchestration
• Experience with data modeling and structuring, including Data Warehouses, Data Lakes, and/or Data Marts
• Strong analytical skills, with experience interpreting data and generating business insights
• Knowledge of relational and/or multidimensional databases
• Ability to work with large volumes of structured and unstructured data
• Knowledge of data preparation for AI and Machine Learning initiatives
• Experience integrating APIs and LLMs for the intelligent processing and analysis of documents
• Knowledge of Prompt Engineering
• Experience defining and monitoring accuracy metrics for AI solutions, both by rule and by prompt
• Experience identifying inconsistencies and hallucinations in AI responses, as well as refining prompts and model context
• Experience with AI applications for document analysis, particularly in credit underwriting or similar processes

Core Competencies

Demonstrates expertise in Microsoft Power BI for developing dashboards and management reporting, alongside advanced SQL proficiency for optimizing complex queries. Proficient in data processing, ETL/ELT processes, and preparing data for AI and Machine Learning applications.

Highest-signal resume keywords

• Microsoft Power BI
• Advanced SQL Proficiency
• ETL/ELT Processes
• Data Warehousing
• Data Preparation for AI

Hard Skills

• Data Processing
• Data Cleansing
• Data Transformation
• Data Modeling
• SQL Query Optimization
• Data Lakes
• Data Marts
• APIs Integration
• Prompt Engineering
• Accuracy Metrics Monitoring

Soft Skills

• Analytical Skills

Industry Keywords

• Business Intelligence
• Cognitive Engine Solutions
• Relational Databases
• Multidimensional Databases
• Document Analysis
• Credit Underwriting