Senior Data Engineer / Power BI Developer

PURVIEW

Washington (District of Columbia)

Remote

USD 150,000 - 195,000

Full time

19 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

PURVIEW is seeking a Senior Data Engineer – Power BI / Snowflake to design and deliver enterprise-grade analytics for investment management. You will work with portfolios, positions, transactions, and risk data to build scalable dashboards and semantic models.

The role requires 7+ years of BI and analytics experience, strong Power BI, SQL, and Snowflake skills, and prior asset management domain knowledge. This is a remote contract engagement with potential extension.

Qualifications

  • 7+ years in BI, data engineering, or analytics.
  • 5+ years of hands-on Power BI development.
  • Asset/investment management experience required.
  • Snowflake and SQL proficiency for enterprise workloads.

Responsibilities

  • Design, develop, and maintain enterprise Power BI dashboards and semantic models.
  • Create advanced DAX calculations, measures, hierarchies, and reusable logic.
  • Build, optimize, and maintain SQL queries in Snowflake.
  • Develop dimensional data models with fact tables and dimensions.
  • Work with portfolios, positions, transactions, securities, and risk data.
  • Collaborate with investment teams to translate requirements into analytics.
  • Optimize reports and Snowflake queries for performance and scalability.
  • Troubleshoot data refresh, modeling, and performance issues.
  • Implement data validation, testing, and quality controls.
  • Support CI/CD, source control, and deployment processes.

Skills

Power BI
SQL
Snowflake
DAX
Semantic modeling
Data analytics
Stakeholder management

Tools

Git
CI/CD
Power BI Service
Power Query
RLS

Job description

Senior Data Engineer – Power BI / Snowflake (Investment Management)

Location: Remote

Duration: 6 Months (Extension Possible)

Experience: 7+ Years

Employment Type: Contract

Job Overview

We are seeking a highly experienced Senior Data Engineer / Power BI Developer with strong expertise in Power BI, Snowflake, SQL, and investment management data.

The ideal candidate will have extensive experience designing and developing enterprise-grade Power BI dashboards, reports, and semantic models, along with advanced DAX and SQL skills. Candidates must have direct experience working within asset management, institutional investment, or financial services environments.

The selected consultant will collaborate with investment, risk, performance, and operations teams to build scalable analytical solutions supporting critical business and investment decisions.

Key Responsibilities
  • Design, develop, and maintain enterprise-level Power BI dashboards, reports, and semantic models.
  • Develop advanced DAX calculations, measures, hierarchies, and reusable business logic.
  • Build, optimize, and maintain complex SQL queries in Snowflake.
  • Develop dimensional data models, including fact tables, dimensions, hierarchies, and slowly changing dimensions (SCD).
  • Work with investment-related datasets, including portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
  • Collaborate with portfolio managers, investment analysts, risk professionals, and business stakeholders to translate requirements into analytical solutions.
  • Optimize Power BI reports, semantic models, and Snowflake queries for performance and scalability.
  • Troubleshoot reporting, data refresh, semantic modeling, and performance-related issues.
  • Implement data validation, reconciliation, testing, and data quality controls.
  • Support source control, automated deployments, and CI/CD processes for BI solutions.
  • Establish Power BI development standards, visualization best practices, and technical documentation.
Required Skills & Qualifications
  • 7+ years of experience in Business Intelligence, Data Engineering, or Analytics.
  • 5+ years of hands-on experience developing enterprise Power BI solutions.
  • Expert-level knowledge of Power BI, including:
    • Power BI Desktop and Power BI Service
    • Advanced DAX and Power Query
    • Semantic modeling and data modeling
    • Performance optimization
    • Row-Level Security (RLS)
    • Data refresh strategies and workspace management
  • Strong SQL development and query optimization skills.
  • Significant hands-on experience with Snowflake.
  • Strong understanding of dimensional modeling, star schemas, fact tables, dimensions, and slowly changing dimensions.
  • Mandatory experience in Asset Management, Investment Management, Institutional Investment, or Financial Services.
  • Strong understanding of investment data, including portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
  • Experience working with portfolio managers, investment analysts, risk teams, or investment operations.
  • Excellent analytical, problem-solving, communication, and stakeholder management skills.
Preferred Qualifications
  • Experience with BI automation, automated testing, data reconciliation, and data quality frameworks.
  • Experience with Git, source control, and CI/CD deployment practices.
  • Microsoft PL-300 Power BI Data Analyst Associate Certification.
  • CFA, CAIA, or other relevant investment industry certifications.
Additional Information
  • Initial 6-month contract with potential extension.
  • Candidates should have strong hands‑on development experience and the ability to work independently in an enterprise investment analytics environment.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SENIOR DATA ENGINEER
SENIOR DATA ENGINEER

PURVIEW • Washington

Remote
USD 150,000 - 190,000
Senior Power BI & Snowflake Engineer — Investment Data
Senior Power BI & Snowflake Engineer — Investment Data

Stockell Consulting • United States

Remote
USD 97,000 - 138,000
Health insurance
401(k)
Senior Data Engineer — Power BI + Snowflake (Remote, 6mo)
Senior Data Engineer — Power BI + Snowflake (Remote, 6mo)

PURVIEW • Washington

Remote
USD 150,000 - 195,000
Data Engineer
Data Engineer

Sharp Decisions • United States

Remote
USD 120,000 - 160,000
Senior Snowflake Data Warehouse Engineer / Data Engineer
Senior Snowflake Data Warehouse Engineer / Data Engineer

Robotic Process Automation LLC • Madison (WI)

On-site
USD 89,000 - 126,000
Senior Data Analyst
Senior Data Analyst

Kake Group • United States

Remote
USD 120,000 - 160,000
Senior Snowflake Data Warehouse Engineer / Data Engineer
Senior Snowflake Data Warehouse Engineer / Data Engineer

Robotics Technologies LLC • Madison (WI)

On-site
USD 89,000 - 126,000
Senior Snowflake Data Warehouse Engineer / Data Engineer
Senior Snowflake Data Warehouse Engineer / Data Engineer

Ethereum Technologies LLC • Madison (WI)

On-site
USD 89,000 - 126,000
Senior Snowflake Data Warehouse Engineer / Data Engineer
Senior Snowflake Data Warehouse Engineer / Data Engineer

Valiant Technologies LLC • Madison (WI)

On-site
USD 89,000 - 126,000
Senior Snowflake Data Warehouse Engineer / Data Engineer
Senior Snowflake Data Warehouse Engineer / Data Engineer

Quantum Technologies LLC • Madison (WI)

On-site
USD 89,000 - 126,000