Senior Power BI Developer

Senior Power BI Developer - PROCOM KW is currently searching for a Senior Power BI Developer to join our established client, an innovator shaping their industry. If you have a strong desire to learn and understand internal business functions, are an analytical thinker and passionate about diving into data, unravelling the complexities and building powerful business intelligence solutions, this is a great opportunity for you.

Senior Power BI Developer Job Details

The Senior Power BI Developer will work with the Data and Analytics team. The chosen candidate will have 5+ years working experience with Power BI. They will be a highly motivated and experienced BI professional that will participate and contribute to all areas of advanced BI & analytics. The Senior Power BI Developer is expected to be an expert in BI analytics and able to scope, analyze, develop, automate, enhance, and validate BI reporting, analytics, and dashboard solutions in a timely and creative manner.

Senior Power BI Developer Responsibilities

• Design, build and deploy powerful BI solutions as per business requirements.
• Conduct requirements analysis and translate data into informative reports, dashboards and KPI’s.
• Connect to data sources, import data, and transform data for Business Intelligence.
• Work with database schemas and referential integrity.
• Performance tuning and indexing with help from DBA.
• Implement row level security on data and application of security layer models in Power BI.
• Create DAX queries in Power BI desktop.
• Responsible for design methodology and project documentation.
• Create and maintain ETL processes.
• Support and enhance existing reports and dashboards based on evolving business needs.
• Maintain and develop new approaches to automate internal and external data retrieval, client reporting and operational process. Interface with cross-functional teams to build centralized/custom data analytics tools to enhance the business process.
• Own and develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects. Create exploratory data analysis, reports, dashboards to surface data for different stakeholders.
• All other duties as required

Senior Power BI Developer Must Have Skills

• 5+ years of Power BI skills
• 10+ Years of BI development and report management experience
• Advanced knowledge of T-SQL (Microsoft SQL Server databases / Microsoft Azure SQL databases)
• Ability to write stored procedures, views, and SQL functions
• Experience reading and writing entity relationship diagrams
• Understand how to use query plans for performance optimization.
• Knowledge and experience in prototyping, designing, and requirement analysis.
• Experience with Common Data Service (CDS)
• Knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.
• Experience slicing and pivoting SSAS OLAP cubes, Azure Active Directory, OAuth and RLS (row level security).
• Advanced knowledge of Microsoft Power BI development, publishing, and scheduling reports
• Proficiency in DAX queries in Power BI desktop.
• Intermediate to advanced knowledge of SSRS/RDL development and management for creating paginated reports in Power BI.
• Intermediate knowledge of Power Automate, Dynamics CRM, and Office 365
• Familiarity with JavaScript, CSS, and other JavaScript libraries
• Excellent organization, planning, and prioritizing skills with a proactive approach to resolving issues
• Effectively communicate highly technical information to function, technical team members and management

Senior Power BI Developer Start Date

Immediate

Senior Power BI Developer Location

Mississauga is preferred, Kitchener/Waterloo region is an option with some travel to other office locations from time to time – possession of a valid driver’s license and own transportation is required.