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

Postal Job Centers

Operations Clerk (Entry Level) Job at Postal Job Centers

USPS is accepting applications for Postal Clerks nationwide. In this role, you will perform a variety of clerical, retail window customer service, and mail distribution duties to support daily post office operations. No prior experience is required, as comprehensive paid...

Hampton Inn and Suites Columbus Downtown

Housekeepers Job at Hampton Inn and Suites Columbus Downtown

 ...Salary Range: (USD) $16/hr Full time Housekeeper benefit package offered: Benefits begin 30 days after you start Medical Dental...  ...the Housekeeping Supervisor of any malfunction or damage; Clean and sanitize guest rooms, replenish supplies and amenities, inspect... 

CompHealth

Physician (MD/DO) - Physical Medicine in Indianapolis, IN Job at CompHealth

 ...Doctor of Medicine | Physical Medicine Location: Indianapolis, IN Employer: CompHealth Pay: Competitive weekly pay (inquire...  ...or paddle down the Indiana Central Canal, enjoy a professional sporting family, view interesting attractions and unlimited arts, and... 

TTF Search and Staffing

Crisis Psychiatric Nurse Practitioner (PMHNP) Job at TTF Search and Staffing

 ...Minimum 2 years' experience working in an acute psychiatric setting is REQUIRED. Experience with Crisis...  ...s degree from an accredited School of Nursing, with appropriate training as an Advanced Registered Nurse Practitioner * Psychiatric Mental Health Nurse Practitioner... 

J2J Structural Steel, LLC

Structural Steel Erector / Fabricator / Welder Job at J2J Structural Steel, LLC

 ...Job Description Job Description J2J Structural Steel is growing and looking for a skilled Structural Steel Erector / Fabricator / Welder to join our team. We are looking for hardworking, dependable professionals who take pride in their craftsmanship and want to be...