Data Management & BI Technician

We are looking to bring in a professional for the Data Management & Business Intelligence team to join the development of the corporate data platform, participating in the design, maintenance, and evolution of information integration, exploitation, and analysis processes.

The profile must have solid technical knowledge in data modeling, ETL processes, and OLAP environments, being able to work autonomously in architectures based on Microsoft SQL Server and collaborate closely with business areas in the extraction and exploitation of information.

At UCI, we drive financial solutions to facilitate access to housing for our clients 🏘️.

And today, we want to continue improving with you.

Help us fulfill our clients' vital projects by facilitating home purchases through responsible financing.

• Participate in the construction, exploitation, and use of the information intelligence system based on BI exploitation technologies and systems, which we are implementing.
• Support the evolution of the current reporting system based on Microsoft SQL, VB.NET, and Excel, to this new Reporting system.
• Gather functional requirements and perform their subsequent technical analysis.
• Implement developments of structures and programs in the information system, including modeling and loading processes.
• Visualize KPIs, prepare reports and Dashboards in visual BI tools, such as PowerBI, Excel and/or ad-hoc queries.

Are you passionate about the world of data and do you want to participate in projects with a real impact on the business?
At UCI, we drive financial solutions to facilitate access to housing for people 🏘️
📌 We are looking for professionals with a solid analytical capacity and experience in data management, integration, and exploitation.
📌 We want you to participate in the development and evolution of the corporate data platform, collaborating in the design, maintenance, and continuous improvement of information integration and analysis processes.
📌 You will be part of the Data Management & Business Intelligence team, working closely with different business areas to transform data into valuable information for decision-making.

📌 Mixed working modality combining on-site presence and remote connection 💻 to facilitate your work-life balance.

📌 People matter to us, which is why we have been certified as GPTW for the fourth consecutive year. 💚

📌 Access to your personalized learning space 👩🎓, with resources and content to develop your talent.

📌 Social benefits 🤗:

• 29 working days of vacation.
• Flexible schedule.
• Meal allowance with Restaurant Card.
• Life insurance.
• Special conditions for contracting your mortgage and for your private medical insurance.

• Extensive experience in Microsoft SQL Server.
• Design and optimization of relational databases.
• Logical and physical data modeling.
• Design of analytical structures oriented toward reporting and information exploitation.
• Experience in SQL query optimization and database performance.

• Demonstrable experience in the design, construction, and maintenance of ETL processes.
• Integration of information from multiple source systems.
• Automation, monitoring, and incident resolution in loading processes.

• Solid experience in SQL Server Analysis Services (SSAS).
• Knowledge of DAX and MDX
• Design and maintenance of multidimensional OLAP cubes.
• Definition of dimensions, hierarchies, and measures.
• Optimization of OLAP environment performance.

Essential requirements

Databases and data modeling
Extensive experience in Microsoft SQL Server.
Design and optimization of relational databases.
Logical and physical data modeling.
SQL query optimization and database performance.
ETL and data integration
Experience in the design, construction, and maintenance of ETL processes.
Integration of information from multiple source systems.
Automation and monitoring of loading processes.
OLAP systems and analytical exploitation
Solid experience in SQL Server Analysis Services (SSAS).
Knowledge of DAX and MDX.
Design and maintenance of multidimensional OLAP cubes.
Definition of dimensions, hierarchies, and measures.
Optimization of OLAP environment performance.

Do you think this could be an opportunity tailored to you? Do not hesitate to apply or contact us and we will give you all the information you need.