Overview
Skills
Job Details
Design, develop, and enhance Business Intelligence reports, dashboards, and applications using Microsoft Power BI and Power Apps to support operational analytics.
Collaborate with Investment Office business users to elicit, document, and validate reporting requirements, ensuring alignment with business metrics.
Design and implement ETL processes and data warehouse solutions using Oracle Data Integrator (ODI) or similar tools to ensure robust data integration.
Create intuitive visualizations, predictive analytics, and report meta-models (conformed dimensions, hierarchies, security rules, data dictionary) to deliver actionable insights.
Troubleshoot and resolve issues related to BI tools, data integration, and ETL pipelines, optimizing performance and reliability.
Expertise in advanced data integration, dashboarding, and operational analytics.
5+ years of hands-on experience in Business Intelligence development and data analytics.
3+ years of expertise in Power BI for developing dashboards, reports, and advanced visualizations.
3+ years ETL development using Oracle Data Integrator, Informatica, for data warehouse solutions.
Demonstrated experience leading 2+ BI/analytics projects, including one with a $1M+ budget.
Proficiency in report meta-modeling, including conformed dimensions, hierarchies, security rules, and data dictionary creation.
Advanced skills in complex SQL development, query optimization, and performance tuning for Oracle and SQL Server databases.
Strong understanding of data warehousing, data modeling, and ETL pipeline design.
Familiarity with Power Apps for building business applications integrated with BI solutions.
Domain experience in financial services, pension systems, or investment management.
Familiar Azure Data Services (Azure Data Factory, Synapse Analytics) for cloud-based analytics.
Exposure to predictive analytics, machine learning, or statistical modeling in BI contexts.
Knowledge of data governance, compliance, or security standards in regulated industries.