Finsolutia intends to reinforce its Information Technology (IT) team with a Data Analyst (M/F).
We are looking for talented and self-motivated individuals for a broad and interesting role working as part of a team based in Lisbon.
RESPONSIBILITIES
- Design and develop Microsoft Power BI reports and Dashboards (Operational Strategic & Analytical) including data set ingestion and transformation Data Modeling Data Analysis Expressions (DAX) using the appropriate report templates depicting status of key performance indicators (KPIs) and other important business metrics for an organization to make data driven decisions
- Work with cross-functional teams to gather and document reporting requirements to meet business needs
- Build data models technical and functional documentation with business partners
- Review and interpret ongoing business report requirements;
- Writing optimized SQL queries for integration with other applications
- Designing database tables and related objects;
- Transition developed reports and dashboards to interactive/automated dashboards using Power BI
- Use T-SQL to develop and implement procedures and functions;
- Provide support as required to ensure the availability and optimal performance of developed reports and dashboards for both external and internal users
- Design and implement technology best practices guidelines and repeatable processes
- Extract and analyze data using PowerQuery PivotTables MS Excel Power BI and DAX.
- Design develop update and optimize Power BI dashboards reports and scorecards to meet business requirements.
HARD SKILLS
- Understanding of T-SQL programming (Microsoft SQL Server)
- Knowledge of Databricks PySpark / SparkSQL
- Knowledge of data modeling following the best practices
- 2 years of experience in creating reports dashboards using Power BI Desktop and Server and maintaining Power BI dashboards on servers.
- Understanding of tuning of Power BI reports data sets and SQL to deliver maximum report performance.
- Experience with ETL Processes
Experience with Python and C# (nice to have) - Fluent in English
SOFT SKILLS
- Proactivity and constant technological evolution;
- Team work and result oriented;
- Good communication and interpersonal / facilitation skills.
Wed like to inform you that personal data collected here are exclusively destined to the management of the recruitment process in question and will be processed and storage by Finsolutia SA or another Group company in accordance with Personal Data Protection Regulation (EU) 2016/679 of 27 April 2016 during a period of 5 years after which they will be definitively eliminated.
We further inform you that the holder will have free access to its personal data and may request its updating rectification or removal by simply sending the request in writing to:
Bernardo Cabral
Data Protection Officer
Required Experience:
Manager