Business Analyst Job at E-Solutions, Mont Clare, PA

  • E-Solutions
  • Mont Clare, PA

Job Description

Sr. Business Analyst – Data Modeling & BI (Snowflake)Location: Oaks, PA Day 1 (Hybrid 3 days onsite a week)Duration: 1 YearOverview: We are seeking a Business 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.Required Qualifications: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 SnowflakeDeep 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.

Job Tags

3 days per week, 1 day per week

Similar Jobs

State Line Propane & Oil

HVAC Installation Technician Job at State Line Propane & Oil

 ...to emergency repair requests Adhere to all safety policies and procedures Qualifications: Previous experience installing boilers, furnaces, split and packaged A/C units, and mini-splits Familiarity with HVAC wiring diagrams Ability to handle physical workload... 

Securitas Security Services USA, Inc.

Security Shift Supervisor Job at Securitas Security Services USA, Inc.

 ...Security Shift Supervisor Wage : $24.00/ hour **4+ years of Security Leadership Experience Required** Job Information...  ...years of security leadership experience Excellent customer service experience Stable work history Able to lead a fast paced... 

Family Style Pub

Outside Sales Representative Bone Hook Brewing Job at Family Style Pub

 ...Marco Island Were looking for a driven, personable Outside Sales Representative to grow our presence across our Southwest Florida...  ...with existing accounts Educate account staff on Bone Hooks beers and brand story Execute sales goals and report on territory... 

Advance Services

Housekeeping Manager Job at Advance Services

 ...Housekeeping Manager Housekeeping Manager for the Casino! Candidates should be bilingual for this position. Looking for a rewarding job with a supportive team? We're hiring a Housekeeping Manager to help create clean, comfortable, and welcoming spaces by preparing... 

Bass Pro Shops

Store Operations & Merchandising Specialist Job at Bass Pro Shops

 ...Bass Pro Shops is seeking a Task Team Outfitter in Missoula, MT. The role emphasizes reducing non-selling tasks for Sales Outfitters to free time for legendary customer service and selling opportunities, with duties peaking around non-peak hours and occasional direct...