Get AI-powered advice on this job and more exclusive features. This range is provided by Ascendion. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay rangeCA$130,000.00/yr - CA$150,000.00/yr Direct message the job poster from Ascendion Talent Specialist ||Anyone can Envision the future,We help them you built it|| Ascendion:-New kind of company for new kind of world||About Ascendion Ascendion is a fullservice digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next. Ascendion | Engineering to elevate life We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us: Build the coolest tech for the world’s leading brands Solve complex problems – and learn new skills Experience the power of transforming digital engineering for Fortune 500 clients Master your craft with leading training programs and hands-on experience Experience a community of change makers! Join a culture of high performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion. About the role Job Title : SQL Power BI French Consultant Location : Remote Required Skills Power BI, Power BI Embedded, SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability. Extensive experience with Power BI development including Power BI embedded skills. Power BI solution design, PBI embedded development skills and Performance optimization skills are required. Proficiency in DAX for developing complex calculations and measures. Strong understanding of Data Warehouse concepts and experience with integration of data warehouse. Solving performance problems, query tuning, and optimization SQL Server on IaaS experience on Azure/ Other public cloud required. Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups Delivering and/or authoring technical training Preferred Skills: Power BI Solution design and embedded development. Data modeling and database design. DAX, Power Query M Language, development and optimization Data connectivity best practices to SQL, Oracle, MySQL, Azure, AWS and other services. Power BI Row Level security along with other Security features. SQL code reviews with ability to dissect query plan, T-SQL code SQL Edition and version differences with discontinued and deprecated features SQL Server Reporting service SQL Server Analysis Service Salary Range:The salary for this position is between $130,000 to $150,000 CAD annually. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate. Benefits:The Company offers the following benefits for this position, subject to applicable eligibility requirements: (medical insurance) (dental insurance) (vision insurance) (401(k) retirement plan) (long-term disability insurance)(shortterm disability insurance) (5 personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State) (1015 days of paid vacation time) (6 paid holidays and 1 floating holiday per calendar year) (Ascendion Learning Management System)This position is eligible for commissions in accordance with the terms of the Company’s plan. Commissions for this position are estimated to be based on individual performance. Additionally, this role is also eligible for a bonus based on the achievement of mutually agreed KRAs. Want to change the world? Let us know Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let’s talk! Seniority levelSeniority level Mid-Senior level Employment typeEmployment type Full-time Job functionJob function Information Technology Industries Technology, Information and Internet Referrals increase your chances of interviewing at Ascendion by 2x Get notified about new Business Intelligence Consultant jobs inCanada . Senior Consultant - Financial & Operational Business Intelligence / Data EngineerSenior Data Management Consultant (Clinical Product and Technology)Cybersecurity Automation Consultant (Remote)Burnaby, British Columbia, Canada 1 day ago Freelance Data Analyst (Python) - AI TutorFreelance Data Analyst (Python) - AI TutorInstructor-Data Analytics and Business Intelligence (Remote)Greater Montreal Metropolitan Area $90,000.00-$182,000.00 4 days ago Data Analyst : A/B-tests and customer onboarding (Remote)Canada CA$102,000.00-CA$167,000.00 3 days ago Business Intelligence Analyst, IgniteTech (Remote) - $60,000/year USDWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.#J-18808-Ljbffr