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

Fortify Building Solutions

District Sales Manager Job at Fortify Building Solutions

 ...DescriptionCornerstone Building Brands has an opportunity for a District Sales Manager to support and grow our Metallic Building Systems brand...  ...in order to search for a job opening or to submit an online application, please contact Human Resources at (***) ***-**** or HRCompliance... 

St. Croix Chippewa Indians of Wisconsin

Coffee Shop Barista Job at St. Croix Chippewa Indians of Wisconsin

 ...Coffee Shop BaristaThis position is a hands-on, customer-facing role responsible for delivering an exceptional coffee and guest service...  .... With a strong service mindset and attention to detail, the barista plays a critical role in the preparation and presentation to customers... 

Department of Consumer Affairs

Mediator Job at Department of Consumer Affairs

 ...Analyst I is responsible for performing a variety of less complex analytical assignments for the Enforcement Division's Intake and Mediation Center. The Analyst I reviews incoming consumer complaints, gathers evidence from the parties, analyzes contractor law, conducts... 

Brightview Senior Living

LPN/RN - Senior Living Nurse Job at Brightview Senior Living

Brightview Senior Living is seeking a compassionate LPN/RN to provide high-quality clinical care and support to residents in our vibrant senior living community. In this role, youll deliver medications and treatments, complete assessments, document care, and collaborate... 

Fortified Risk Group

Elite Executive Protection Specialist Job at Fortified Risk Group

 ...A security services provider based in Tennessee seeks an Executive Protection Agent responsible for ensuring client safety and conducting threat assessments. Candidates must have at least 5 years in law enforcement or military and possess relevant certifications. The...