Mako Financial Technologies

Business Intelligence Analyst

• 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

Business Intelligence Manager