Education and Experience
- 7+ years of experience developing enterprise business intelligence or analytical solutions.
- 5+ years of advanced hands-on Power BI experience in production environments.
- Expert-level experience with Power BI semantic modeling, DAX, performance optimization, security, refresh strategies, and Power BI Service.
Knowledge, Skills and Abilities
- Expert-level SQL skills and significant hands-on Snowflake experience supporting analytical workloads.
- Strong experience with dimensional modeling, including fact tables, dimensions, hierarchies, and slowly changing dimensions.
- Direct experience in asset management, investment management, institutional investment, or closely related financial services industry.
- Strong understanding of investment data including portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
Job Responsibilities
- Develop advanced, dimensional models, calculations, hierarchies, and reusable business logic.
- Develop and optimize Snowflake SQL supporting portfolio, position, transaction, security, benchmark, performance, and risk datasets.
- Optimize Power BI solutions for performance, scalability, usability, and maintainability.
- Troubleshoot complex reporting, data, semantic model, refresh, and performance issues. Develop testing, reconciliation, monitoring, and data quality controls to ensure reporting accuracy and reliability.
- Support source control, automated deployment, and CI/CD practices for business intelligence solutions.
Rate:
Not specified
Location:
Madison
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Senior