Capitole is one of the best IT consulting companies and the place you want to be.
Why?
People in the center.
We believe in a different model, more human, with the employee in the center of our company ? Interesting projects.
Cutting-edge technologies.
Agile methologies Happiness and low turnover rate €1200 per year training budget ? Flexible working hours More than 900 skilled professionals, from more than 27 nationalities Tailored career path Monthly follow-ups.
360º continuous evaluation Private health insurance Flexible retribution program ???? Wellhub: access to fitness, wellness, and mental health support Processing of the work permit for you to come to Spain with your family Technological communities Lots of amazing events We are looking for a Data Analyst to join the team of an important multinational client in the automotive sector .
Key responsabilities Design, develop, and optimize relational and dimensional data models for analysis and reporting, following best practices.
Write, optimize, and maintain advanced SQL queries for data extraction, transformation, and analysis.
Implement and manage robust data models in Power BI, ensuring efficient design and smooth user experience.
Diagnose and resolve performance issues related to data loading and processing in Power BI, Power Query, and SQL queries.
Analyze and translate business requirements into clear and effective technical solutions.
Implement data validation and cleaning processes to ensure data quality and integrity.
Collaborate with cross-functional teams to align technical solutions with business goals.
Document processes, models, and queries using tools like JIRA and Confluence.
Experience Minimum 5 years of experience in similar technical roles, with a proven track record in data analysis and reporting.
Advanced SQL: Expertise in creating and optimizing complex queries, subqueries, joins (INNER, LEFT, RIGHT), indexing, and data partitioning.
Proven experience with Power BI , including Power Query and DAX.
Strong knowledge of data modeling: designing relational (OLTP) and analytical (OLAP) schemas.
Solid understanding of Data Warehousing and integrating data from multiple sources.
Familiarity with large datasets and database management systems (e.g., SQL Server, PostgreSQL, MySQL).
Experience with project management and documentation tools such as JIRA and Confluence .
Modality: full-remote.
Schedule: Flexible, Friday intensive.
English: C1.
Want to know more?
Click here ? and find out See what people say about us ???? Glassdoor Reviews Feel free to send us your profile, we are excited to meet you The employee will adhere to information security policies: -Will have access to confidential information related to Capitole and the project they are working on.
-Must comply with the security policies and internal policies of the company and the client.
-Must sign an NDA.