JUNIOR IT SQL-BI CONSULTANT

Are you curious and ready to accept a new challenge in your career? Are you eager to join a dynamic company and bring innovation through your work and skills? Prometeia offers you opportunities for growth and training in a Group with over professionals working for more than 500 clients in 20 countries around the world.
Among the European leaders in Wealth Management solutions, Prometeia is looking for a IT Consultant to join the Delivery IT team in its Bologna office.
PROFILE Candidates will join technical consulting teams in the Italian and international banking sector.
They will be mainly involved in data management aspects (database design and integration in software solution), with particular attention to aspects of normalization, data retention and performance, Tabular cube management, ETL logic implementation and integration to relational and non-relational databases, all in the context of software delivery projects oriented to distributed computing of large volumes of both on-premises and cloud data.
Ideal candidates are new graduates in Computer Engineering, Computer Science, Physics, Mathematics, or high school graduates in the technical-industrial field with a focus on computer science.
TECHNICAL SKILLS The following skills are considered a requirement.
knowledge of Microsoft Windows operating systems (at least Client) ability to autonomously navigate and use the features offered by operating systems (no administrative skills required) knowledge of SQL ability to read an ER (Entity Relationship) diagram and understand its semantics, read queries and correct them (both on static and dynamic SQL) knowledge of MS SQL Server and its main functions (backup, restore, list tables and their structure, use of SQL clients) knowledge of the English language ability to read and understand a technical document and read/write technical emails to the working group teamwork aptitude problem-solving aptitude The following skills are considered a plus.
knowledge of MS SQL Server Analysis Services and its main functions (cube creation, data queries with DAX language, scripting) knowledge of MS SQL Server Reporting Services and its main functions (report creation, administration and use of reporting web services) knowledge of Microsoft Power BI and its main functions (report creation) knowledge of PostgreSQL and its main functions (backup, restore, list tables and their structure, use of SQL clients) knowledge of Oracle and its main functions (backup, restore, list tables and their structure, use of SQL clients) knowledge of MS PowerShell ability to write simple scripts based on that command shell knowledge of object-oriented software development knowledge of object-oriented programming principles o prior experience can help understand the configuration and setup of projects managed by the team knowledge of managing cloud computing systems (preferably MS Azure) LOCATION Milano Precotto WHAT WE OFFER.
COMPENSATION, WELFARE & BENEFIT Our history, as well as the future, is based on the value of our people.
The biggest investment at Prometeia is in our people, and it concerns every aspect of professional life.
We call it 'Total Compensation' and is made up of Compensation - consisting of a fixed and a variable component -, an important Welfare Plan, active since - we have been among the first to introduce it in Italy - and Benefits, which include all the initiatives undertaken for the well-being of our people.
REMOTE WORKING Flexibility is an intrinsic value of the way we work.
At Prometeia, smart working is an organizational method based on trust, which results in benefits in terms of work/life balance, impact on the environment and optimization of company results, through autonomy and empowerment of people.
PEOPLE PROGRAM Our evaluation system is based on the full enhancement of people and their continuous dialogue as a stimulus for regular, mutual professional and personal growth.
Transparent discussions between managers and team members are set up within the projects, where reciprocal and timely feedback is exchanged.
The process is fully digitalized and aimed at continuously improving the development trajectory of the individual and the company.
TRAINING Prometeia means ongoing training.
We provide an average of 11 days of training per year to our people, in person and online.
Particular attention is paid to younger colleagues, who are the protagonists of dedicated growth programs, and to the continuous sharing and internal transfer of know-how and skills.
On-the-job training is also important, through immediate and direct confrontation with the market.
WIN/WIN POLICY If you are one of our employees, and you recommend a person who is later recruited, you are entitled to a financial bonus! This is an important opportunity to contribute to the growth of Prometeia as a whole, by attracting acknowledged market professionals and new tech talents.
PHYGITAL MANAGEMENT Through the dedicated app Pr(Home)teia, we have completely digitalized and integrated the management of our physical and virtual environments.
Access to the office, smart working, workstations, meeting rooms, car pooling...
everything is just a click away.
COMMUNITY Our Community is extremely diverse, as are the skills of the people who are part of it and who share its values, and the individuals and organizations that are directly or indirectly involved in our activities.
Clients, People of the Group, Alumni, Institutions, Academia, non-profit entities with which we actively collaborate, are stakeholders representing a great value for us, in terms of trust and collaboration.
DIVERSITY We promote and respect equal opportunities and consider differences as a value.
Diversity & Inclusion are fundamental values.
from the selection phase to everyday life, also through dedicated training moments to develop individual sensitivities and unicities.
IMPACT We responsibly take an active role towards the environment, the territories and the communities in which we operate.
Our Headquarter in Bologna has obtained the Leed Gold Certification, one of the highest awards that recognizes the performance of the building in terms of energy and water savings, reduction of CO2 emissions, improvement of the ecological quality of the interior, materials and resources used.
In the Sustainability Report we report the results achieved within the 17 Sustainable Development Goals (SDGs) of the Agenda that, drafted by the United Nations in , we have been supporting since .