Remote Senior Power BI & Snowflake Engineer (Investment)

Stockell Consulting; United States; Remote; USD 97,000 - 138,000; Part time

Benefits offered by this job

Health insurance

401(k)

Job summary

Stockell Consulting is seeking a senior Power BI engineer to design, build, and support analytics for investment, risk, performance, and operations teams. Workloads involve enterprise Power BI with semantic models, advanced DAX, and production reporting on Snowflake with large financial datasets.

Ideal candidates have years of experience building Power BI for portfolio managers, with direct investment management expertise. This role requires U.S.

Qualifications

• 7+ years developing enterprise BI or analytical solutions.
• 5+ years of advanced, hands-on Power BI in production environments.
• Expert-level Power BI semantic modeling, DAX, performance optimization, security, refresh strategies and Power BI Service.
• Expert-level SQL and significant hands-on Snowflake experience on analytical workloads.
• Direct experience in asset management, investment management, institutional investment or closely related financial services.
• Strong understanding of investment data: portfolios, positions, transactions, securities, benchmarks, exposures, performance and risk.
• Experience working directly with portfolio managers, analysts, risk, performance or investment operations staff.
• Clear written and verbal communication across technical and investment audiences.

Responsibilities

• Design, develop and maintain Power BI reports, dashboards and semantic models that support investment and business decisions.
• Partner with investment, risk, performance and operations teams to turn complex requirements into scalable analytical solutions.
• Build advanced DAX, dimensional models, calculations, hierarchies and reusable business logic.
• Write and optimize Snowflake SQL across portfolio, position, transaction, security, benchmark, performance and risk datasets.
• Tune Power BI solutions for performance, scalability, usability and maintainability.
• Troubleshoot complex reporting, data, semantic-model, refresh and performance issues.
• Build testing, reconciliation, monitoring and data-quality controls that keep reporting accurate.
• Support source control, automated deployment and CI/CD for BI solutions.
• Set and promote Power BI development, visualization and reporting standards.
• Document business logic, data models, technical designs and operating procedures.

Skills

Power BI

DAX

SQL

Snowflake

Investment data

Communication

Job description

Stockell Consulting is seeking a senior Power BI engineer to design, build, and support analytics for investment, risk, performance, and operations teams. Workloads involve enterprise Power BI with semantic models, advanced DAX, and production reporting on Snowflake with large financial datasets.

Ideal candidates have years of experience building Power BI for portfolio managers, with direct investment management expertise. This role requires U.S.