BI Analyst

OverviewTundra Technical Solutions provided pay range. This range is provided by Tundra Technical Solutions. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Base pay rangeCA$40.00/hr - CA$45.00/hrDirect message the job poster from Tundra Technical SolutionsPlease note, this is an opportunity for an extendable, 12 month contract.Job SummaryIn this role, the successful candidate will serve as an operational data subject matter expert (SME) within the organization in topics ranging from PSP, Pharmacy, finance and visualization and data presentation best practices. This role specializes in collecting, organizing and analyzing data from various resources and translating it into compelling reports and presentations for internal and external clients.Role and ResponsibilitiesDevelop reports, dashboards and self-serve data products using Power BI and Excel.Evaluate source data and build views required for high performing reporting and analytics.Practical knowledge of programming software and languages used for report building and data analysis. PBIX, RDL, DAX, and SQL are mandatory. Knowledge and experience with Python is helpful.Collaborate regularly with various cross functional departments and stakeholders to understand their business reporting needs and requirementsGenerate analytical insights that drive the performance of a large-scale programsSupport the team with mining data, data insights, data availability through producing reports and dashboardsAssist in identifying opportunities in the business and works to produce impactful analysisExamine reporting relationships to increase end-user productivity, availability, and accuracyWorking with the technical team to establish protocols to extract data in a standardized process from a variety of data sourcesAnalyzing large amounts of data to provide concise, targeted reports for internal and external clientsAble to work independently and with team to gather requirements and provide process recommendation to stakeholdersIdentify areas of opportunity to make a difference through the use of dataQualificationsPreferred qualifications and education requirements: Degree in Computer Science, Data Science or Business is an asset.3-5 years of working experience navigating relational databases via SQL and NoSQL architecturesStrong knowledge of PBIX and DAX is requiredAbility to write high performance SQL queries, including concepts like subqueries, common table expressions, and window functionsAbility to work in a fast-paced environment and manage multiple projects through effective prioritizationStrong problem-solving skills and demonstrated ability to be highly creative in formulating solutionsKnowledge of data visualization and building dashboards in Power BI is a strong assetKnowledge of Data Lakehouse setup on Databricks is a strong assetDetailsSeniority level: AssociateEmployment type: ContractJob function: AnalystIndustries: Business Consulting and ServicesReferrals increase your chances of interviewing at Tundra Technical Solutions by 2x.Get notified about new Business Intelligence Analyst jobs in Toronto, Ontario, Canada.Other related roles: Data Analyst, Business Process Reengineering; Business Analyst-Azure data/ datawarehouse; Business Analyst, Client Data Technology - Toronto, ON; Business Sytem Analyst - Basel, US Regulatory Reporting Big Data, Data Lake; Technical Business Analyst (Python and Tableau development); Toronto, Ontario, Canada CA$55.00-CA$65.00 2 hours ago; Business Analyst (Data Conversion & Reconciliation) - Consultant; Business Systems Analyst (Data Analyst) (contract); Senior Business Analyst - Insurance (Fully Remote); Business Analyst (Intermediate) 8733-0611 #J-18808-Ljbffr