Job Description
Location: Shorewood Hills, WI
Salary: $75.00 USD Hourly - $80.00 USD Hourly
Description: Position Overview We are seeking a highly experienced Senior Data Engineer with deep expertise in Power BI, Snowflake, SQL, and enterprise business intelligence solutions. The ideal candidate will possess strong investment management domain knowledge and a proven track record of designing, developing, and optimizing scalable analytics and reporting solutions used by investment, risk, performance, and operations teams.
This role requires advanced Power BI development, semantic and dimensional modeling expertise, Snowflake data engineering experience, and the ability to collaborate directly with business stakeholders to deliver data-driven insights.
Key Responsibilities - Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models.
- Translate complex business requirements into scalable analytical solutions.
- Develop advanced DAX calculations, business logic, hierarchies, and dimensional models.
- Create and optimize complex Snowflake SQL queries supporting large analytical datasets.
- Work extensively with investment-related data including portfolios, positions, transactions, benchmarks, performance, exposures, and risk metrics.
- Optimize reporting solutions for performance, scalability, maintainability, and usability.
- Troubleshoot reporting, refresh, data quality, and semantic model issues.
- Build testing, reconciliation, monitoring, and data quality controls.
- Support source control, CI/CD pipelines, and automated deployments.
- Establish Power BI development standards and reporting best practices.
- Create technical documentation, business logic documentation, and operational procedures.
- Partner with both technical teams and business stakeholders to deliver reporting solutions.
Required Qualifications Experience - 7+ years of Business Intelligence, Data Engineering, or Analytics solution development experience.
- 5+ years of hands-on Power BI development in enterprise production environments.
- Extensive experience building reporting solutions using large and complex datasets.
Power BI Expertise
- Semantic Modeling
- Advanced DAX Development
- Performance Optimization
- Power BI Security
- Data Refresh Strategies
- Power BI Service Administration
Data Engineering & Database Skills
- Expert-level SQL development skills.
- Strong hands-on Snowflake experience.
- Experience building and supporting enterprise analytical solutions.
Data Modeling
- Fact & Dimension Modeling
- Dimensional Modeling
- Hierarchies
- Slowly Changing Dimensions (SCD)
- Reusable Business Calculations
Domain Expertise
- Asset Management
- Investment Management
- Institutional Investing
- Financial Services Analytics
Investment Data Experience
- Portfolio & Position Reporting
- Investment Transactions
- Securities & Benchmarks
- Portfolio Exposures
- Performance Analytics
- Risk Analytics
Stakeholder Engagement
- Experience working directly with:
- Portfolio Managers
- Investment Analysts
- Risk Teams
- Performance Teams
- Investment Operations Teams
Communication
- Strong verbal and written communication skills.
- Ability to explain technical concepts to non-technical stakeholders.
Preferred Qualifications - Experience implementing automated testing frameworks.
- Data quality monitoring and reconciliation experience.
- Source control and CI/CD implementation experience.
- Microsoft PL-300 Certification.
- CFA, CAIA, or related investment industry certifications.
Technical Environment Primary Technologies
- Microsoft Power BI
- DAX
- Snowflake
- Advanced SQL
- Power BI Service
Data Architecture
- Enterprise Semantic Models
- Dimensional Data Modeling
- Fact & Dimension Tables
- Slowly Changing Dimensions (SCD)
- Financial Data Reconciliation
- Data Quality Controls
- Large-Scale Analytical Datasets
DevOps & Best Practices
- CI/CD
- Source Control
- Automated Deployments
- Testing & Monitoring
- Performance Tuning
Ideal Candidate Profile The ideal candidate will be a:
- Advanced Power BI Development
- Complex DAX Calculations
- Snowflake Data Engineering
- SQL Performance Optimization
- Investment & Portfolio Analytics
- Enterprise Reporting Solutions
- Stakeholder-Facing Analytics
Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact: This job and many more are available through The Judge Group. Please apply with us today!
Job Tags
Hourly pay