Business Intelligence Manager overseeing data lake and reporting at financial technology firm. Leading efforts to improve data flows and business intelligence reporting for client services.
Responsibilities
Establish and maintain a cloud hosted data lake
Review our ETL services to transfer data from our data sources to the data lake and from the data lake to our Power BI reports and other systems
Manage our API keys, OAuth settings and necessary access to allow for our different services to authenticate with the data lake
Optimize data refreshes to provide timely, accurate and complete data that works within the API parameters of our subscribed services with minimal downtime
Use the source data available in our data lake to normalize, transform and link our data together for the purposes of executing business intelligence calculations and reporting
Write calculations in Power BI to create business intelligence reports to meet Mako’s reporting needs
Establish checks and balances to identify if key data is missing from source systems to facilitate accurate and complete business intelligence reporting
Work with other Mako stakeholders to ensure reporting is accurate and meeting requirements
Create necessary audit support for business intelligence calculations to give users confidence that reporting is accurate, timely and complete
Requirements
Educational background in computer science, data analytics, statistics or similar
2-5 years of experience managing a data lake, data modelling and writing business intelligence calculations
Strong communication skills to translate business needs into technical solutions and vise versa
Provides proactive insights into how to make Mako’s business intelligence services more efficient, intuitive and user-friendly
Willing to proactively research and learn as business intelligence platforms and strategies evolve over time
Experience with a business intelligence platform (Power BI, Tableau or similar) is required
Experience with Excel and/or Google Sheets at an Advanced level is required
Experience with AWS is an asset
Benefits
High-end Mac or PC laptop, and $1000 budget to outfit your home office
Your opportunity to make your own footprint and bring Mako’s business intelligence capabilities to the next level
Equity in a fast-growing start-up
Gold-plated health and wellness benefits
Unlimited vacation policy
Amazing team of intelligent, passionate and friendly individuals who continuously push each other to do better
Business Insights Analyst analyzing TD Insurance claims data, trends, and KPIs for TD Insurance. Delivering actionable reporting and recommendations to operational, actuarial, and executive stakeholders.
Business Insights Analyst II at TD Insurance, part of Canada’s largest financial institutions. Supporting analytics operations and colleagues onsite in Montréal.
Analyste BI chez CAA - Québec, créant rapports et tableaux de bord. Transformant les données en recommandations pour soutenir les décisions et opérations.
Data Analyst delivering financial and business reporting for Torys law firm. Building dashboards, validating data, and providing insights to lawyers and internal stakeholders.
Business Intelligence Specialist leading Power BI dashboards, data visualization, and reporting governance for TD, a global financial institution. Delivering trusted insights across business units.
Senior Fund Analyst overseeing fund accounting, NAV valuation, audits, and financial reporting at Bank of Montreal. Fully remote role supporting accurate regulatory and management reporting.
Business Intelligence Manager leading Power BI and Databricks analytics for Apotex, a Canadian pharmaceutical company. Championing AI use cases, automation, and data - driven decision - making.
Analyste principal(e) migrant et modernisant les rapports Cognos vers Power BI/Fabric chez EDC, organisme canadien de financement du commerce. Conception de rapports, validation des données et soutien au déploiement.
Senior Reporting Analyst modernizing Export Development Canada’s Cognos reporting ecosystem into Power BI/Fabric. Building governed reports and semantic models for trusted business decisions.