21 Nov
|
Cyient
|
Montreal
Key Responsibilities
• Design, develop, and maintain advanced Power BI dashboards and reports for business and operational performance monitoring.
• Develop complex DAX measures, calculated columns, and time intelligence calculations.
• Build optimized data models using Star Schema, relationships, and appropriate modelling techniques.
• Connect Power BI to multiple data sources, including SQL databases, Databricks, Data Lakes, APIs, and Excel files.
• Collaborate on Development of predictive analytics and Data Science Innovation leveraging AI/ML
• Write and optimize complex SQL queries, views, and stored procedures to support reporting requirements.
• Implement Power Query (M) transformations for data cleansing, preparation, and integration.
• Optimize Power BI report performance, data models, and refresh processes.
• Implement Power BI deployment best practices.
• Develop automated data refresh and reporting solutions, including incremental refresh where appropriate.
• Troubleshoot data discrepancies, performance issues, and dashboard defects.
• Work closely with business stakeholders to understand requirements, define KPIs, and translate business needs into technical solutions.
• Maintain documentation, development standards, and dashboard governance practices.
Qualification:
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 3-5 years of experience in Power BI development and business intelligence.
• Strong hands-on experience developing complex enterprise-level Power BI dashboards and reporting solutions.
• Advanced expertise in DAX, SQL, Power Query, and data modelling.
• Experience working with large datasets and optimizing Power BI performance.
• Experience integrating Power BI with enterprise data platforms such as SQL Server and Databricks.
• Solid analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Ability to independently manage requirements, development, testing, deployment, and production support. Preferred
Experience:
• Experience connecting Power BI directly to Databricks and Lakehouse platforms.
• Knowledge of Python and data engineering concepts.
• Experience with enterprise dashboard governance and reporting standardization.
• Exposure to predictive analytics and AI-enabled reporting capabilities.
• Experience working in Agile/Scrum development environments.
📌 Data Scientist (Montreal)
🏢 Cyient
📍 Montreal