Business/Data Analyst Data Modeling & BI (Snowflake)
Jobs via Dice - Oaks
Work at Jobs via Dice
Overview
- View job
Overview
Business/Data Analyst Data Modeling & BI (Snowflake)
Join to apply for the Business/Data Analyst Data Modeling & BI (Snowflake) role at Jobs via Dice
Business/Data Analyst Data Modeling & BI (Snowflake)
6 hours ago Be among the first 25 applicants
Join to apply for the Business/Data Analyst Data Modeling & BI (Snowflake) role at Jobs via Dice
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Coforge, is seeking the following. Apply via Dice today!
Role: Business/Data Analyst Data Modeling & BI (Snowflake)
Location: Oaks, PA
Mode Of Hire: Full Time
Overview:
We are seeking a Business/Data Analyst with strong expertise in data modeling for Business Intelligence and Analytics, particularly in Snowflake, and hands-on experience in the financial services domain, specifically fund accounting and portfolio accounting. The ideal candidate will act as a bridge between business stakeholders, data engineering, and BI/reporting teams to build scalable, analytics-ready data models that support fund-level and portfolio-level insights.
Key Responsibilities:
- Gather and document business requirements related to fund and portfolio performance, NAV calculations, client reporting, and regulatory needs.
- Design conceptual, logical, and physical data models that support analytical workloads in Snowflake.
- Build data models that align with fund/portfolio accounting structures such as securities, transactions, positions, valuations, fees, and reconciliations.
- Collaborate with data engineers and BI developers to implement star/snowflake schemas optimized for financial reporting and KPI dashboards.
- Define data mappings from source systems (e.g., Geneva, Eagle, or other accounting platforms) to Snowflake.
- Maintain data dictionaries, transformation logic, and business glossaries for financial metrics and entities.
- Ensure compatibility with BI tools like Power BI, Tableau, or Looker for downstream reporting.
- Analyze and validate data quality, lineage, and performance in financial reporting pipelines.
- 5+ years of experience in business/data analysis, preferably in financial services or asset management.
- Strong understanding of fund accounting, portfolio accounting, or investment performance analytics.
- 2+ years of experience with Snowflake or similar cloud-based data warehouses.
- Deep understanding of dimensional modeling, including star and snowflake schemas.
- Proficient in SQL and capable of working with large datasets and complex joins.
- Familiarity with BI/reporting tools (Power BI, Tableau, Looker).
- Experience working with accounting platforms such as Geneva, Investran, or similar systems.
Seniority level
Seniority level
Mid-Senior level
Employment type
Employment type
Full-time
Job function
Job function
Information Technology-
Industries
Software Development
Referrals increase your chances of interviewing at Jobs via Dice by 2x
Sign in to set job alerts for Business Data Analyst roles.
Business/Data Analyst Data Modeling & BI (Snowflake)
Philadelphia, PA $60.00-$70.00 2 weeks ago
Senior Data Analyst with Snowflake experience
King of Prussia, PA $100,000.00-$135,000.00 1 week ago
Customer Remediation Data Analyst - Consumer & Business Banking Risk
Horsham, PA $105,400.00-$124,000.00 1 week ago
Senior Business Intelligence Analyst (Energy Markets and Regulation)
Specialist, IT Business Systems Analysis (Philadelphia or Cedar Rapids)
Philadelphia, PA $125,000.00-$138,000.00 1 week ago
Radnor, PA $79,601.00-$145,100.00 2 weeks ago
Radnor, PA $69,000.00-$124,600.00 4 days ago
Bala-Cynwyd, PA $67,000.00-$95,000.00 4 days ago
Philadelphia, PA $62,200.00-$105,800.00 2 weeks ago
Manager, Analytics, Comcast Experience Group
Philadelphia, PA $87,210.00-$125,265.00 3 days ago
Business Analyst, application via RippleMatch
Montgomery County, PA $120,000.00-$125,000.00 2 weeks ago
Senior Applications Business Systems Analyst - Manufacturing/MES
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr