Power BI Developer

About this job

Position type-

Full Time

Shift Time- 12:30pm – 9:30pm (Flexible)

People Manager role: No

Required education and certifications critical for the role-

Bachelor’s degree in computer science, Information Systems, Mathematics, Finance, or related field; or equivalent experience.

Required years of experience – 7-10 years of work experience in relevant field

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are committed to our purpose as one firm, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed.

Role Summary

Power BI Developer – Investments will design, build, and maintain analytics solutions that support investment decision‑making and reporting. The primary focus is on advanced Power BI development (data modeling, DAX, complex dashboards) combined with solid software engineering skills in .NET for data preparation and integration. The role will work with data from Databricks and other investment data sources to deliver secure, scalable, and user‑tailored dashboards and reports for portfolio managers, analysts, and senior stakeholders.

Investment Data Integration & Preparation

• Connect Power BI to Databricks and other investment data sources (e.g., portfolio, benchmark, risk, pricing, market data).
• Develop .NET (C#) components, APIs, and/or batch jobs to ingest, transform, and prepare investment data for BI consumption.
• Implement business rules for performance, risk, exposure, attribution, and other investment metrics in collaboration with investment and risk teams.
• Ensure data quality, lineage, and consistency across datasets and reports.

Power BI Development (Primary Focus)

• Design and build robust Power BI datasets, semantic models, and complex DAX calculations for investment analytics and reporting.
• Develop interactive dashboards and reports for portfolio monitoring, performance & attribution, risk/limits, and management information.
• Optimize models for performance, usability, and scalability; manage refresh strategies, aggregations, and incremental loads where appropriate.
• Apply best practices in visualization to present complex investment data clearly and intuitively to portfolio managers and senior management.

Security, Filtering & Personalization

• Implement row‑level and object‑level security in Power BI to control access by user, desk, fund, strategy, region, or client segment.
• Configure solutions so end users (e.g., portfolio managers, analysts, product, risk) automatically see data relevant to their role and permissions.
• Work with identity/entitlement data to drive dynamic filtering and ensure compliance with internal and regulatory requirements.

Collaboration & Governance

• Partner with investment, risk, performance, and operations teams to understand requirements and translate them into technical solutions.
• Work with data engineers/architects on data models, reference data, and integration patterns (Databricks, data lake, warehouses, etc.).
• Contribute to BI and engineering standards (coding practices, version control, documentation, testing, deployment).
• Provide production support for critical reports and dashboards, including investigation and resolution of data or performance issues.

Continuous Improvement

• Stay current with Power BI, .NET, and Databricks capabilities and how they can be applied to investment analytics.
• Proactively identify opportunities to automate manual reporting processes and improve analytical capabilities for the Investments team.

Required Qualifications & Experience

• Bachelor’s degree in computer science, Information Systems, Mathematics,…