About the role

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

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

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