Abrdn

BI Developer/Analyst

Learned abrdn data architecture to effectively run SQL queries, power queries, and OLAP queries to collect, prepare, and transform data for client deliverables ad hoc and as a part of streamlined data pipelines.
Automated quality control and data preparation processes using Alteryx and other tools to eliminate recurring manual work for the team.
Built python programs to calculate advanced analytics and parse source data.
Developed process improvement solutions with the long-term goal to outsource or automate repeatable tasks.
Provide subject matter expertise on advanced tools and methods such as Python, Microsoft technology stack, Adobe, Alteryx, Artificial Intelligence, APIs, file transfer and job scheduling, or others.
Resolved complex ad-hoc queries and requests from various stakeholders including investment teams, clients, and others.
Built and supported processes to validate and audit investment performance produced by third-party service providers across Equity, Fixed Income, Multi- Asset, and Alternative asset classes.
Prepare regular reporting cycle client materials, including standardized and custom client deliverables that may require sourcing data from various systems and editing data within Excel and PDF file formats.