About this job : BI Analyst
Fed IT, a recruitment firm specializing in recruitment for IT professions,
We operate on two types of recruitment: temporary and permanent.
All our consultants are IT experts who speak your language and evolve in your universe. We cover open positions in IT, development, decision-making, and infrastructure.
We are currently looking for a BI analyst in hybrid mode for one of our clients located north of Montreal.
Your missions
• Add new information in the data warehouse using SSIS ETL and SQL
Stored procedure.
• Prepare data counters in T-SQL
• Increase the volume of information exposed in computer cubes by adding dimensions and facts.
• Extract data on demand (Adhoc Reporting)
• Ensure the validity and integrity of data
• Prepare SSRS/Power BI reports for the company
• Contribute to the migration of multidimensional cubes to the tabular model
• Act as an analyst for ad hoc needs
• Maintenance and improvement of reference solutions
Your profile
• DEC in computer science or any combination of relevant experience and/or studies
• Minimum 3 years of experience in the development of business intelligence solutions
• Have a good command of T-SQL, SSIS, SSAS, SSMS, DAX, MDX
• Be able to understand and write complex SQL queries
• Understand the principles of data modeling
• Communicate effectively in French and English both orally and in writing
• Good analytical and problem-solving skills
• Understanding of business needs and data relationships
• Respect commitments
• Be a team player, have a collaborative spirit