Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr. Business Analyst - Data Modeling & BI (Snowflake)

E-Solutions

Role: Sr. Business Analyst - Data Modeling & BI (Snowflake)

Location: Oaks, PA Day 1 (Hybrid 3 days onsite a week)

Duration: 1 Year Contract



Overview:
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 Snowflake
  • 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 .
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Sr. Business Analyst - Data Modeling & BI (Snowflake) in Oaks, PA vacancy
  •  ...Sr. Business Analyst – Data Modeling & BI (Snowflake) Location: Oaks, PA Day 1 (Hybrid 3 days onsite a week) Duration: 1 Year Overview: We are seeking a Business Analyst with strong expertise in data modeling for Business Intelligence and Analytics, particularly... 
    Senior
    Business intelligence
    3 days per week
    1 day per week

    E-Solutions

    Mont Clare, PA
    3 days ago
  •  ...Data Analytics and Insights Specialist | Process Improvement Analyst 3 ProSidian is a Management and Operations...  ...| Compliance | Business Process | IT Effectiveness...  .... Develop forecasting models to support decision-making...  ...R, Python, SPSS) and BI dashboards.... 
    Business intelligence
    Full time
    Contract work
    Part time
    For contractors
    Work at office
    Flexible hours

    ProSidian Consulting

    Norristown, PA
    3 days ago
  •  ...Business Insights Analyst This is a hybrid role based out of Malvern, PA (3 days...  ...is focused on leveraging data and business knowledge to uncover...  ...Advanced Analytics and Modeling Utilize predictive modeling...  .... Collaborate with the BI team to establish and maintain... 
    Business intelligence
    Work at office

    CubeSmart Self Storage

    Malvern, PA
    9 hours ago
  •  ...The Senior Data Analyst demonstrates analytical thinking...  ...creative problem solving for business questions across the...  ...from developing new BI solutions, leading AI-...  ...multiple sources (Snowflake, Web (API), etc.)....  ...Build and maintain dbt models in Snowflake to support... 
    Senior
    Business intelligence
    Fixed term contract

    Suvoda

    Conshohocken, PA
    2 days ago
  •  ...Contract Performance Data Analyst | Process Improvement Analyst 2 ProSidian is a Management...  ...Solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering...  .... Skills Required ~ Excel & BI tools, Contract management platforms (e.... 
    Business intelligence
    Full time
    Contract work
    Part time
    Work at office

    ProSidian Consulting

    Norristown, PA
    2 days ago
  •  ...Marketing Business Analyst Apply ( locations Malvern, PA time type...  ...Analyst will support data‑driven marketing decisions by...  ...dashboards and visualizations using BI tools (e.g., Tableau)a plus...  ...implemented a hybrid working model for the majority of our crew... 
    Business intelligence
    Full time

    Vanguard

    Malvern, PA
    3 days ago
  •  ...BI Analyst (Data Analyst) Malvern, PA – Hybrid Responsibilities Collect, clean, and...  ...Management, Data Governance) to understand business needs and deliver tailored solutions....  ...of statistical methods and data modeling techniques. Excellent communication... 
    Business intelligence

    RIT Solutions

    Malvern, PA
    8 days ago
  •  ...Business System Analysis (Senior Specialist) Location: Oaks, PA (...  ...POSITION OVERVIEW: Business Analyst - We are currently seeking a Business...  ...with Dev team, QA team, Data Analyst, and Data architects....  ...with Agile fast paced weekly/ bi-weekly iterations projects ~... 
    Business intelligence

    My3Tech Inc

    Mont Clare, PA
    3 days ago
  • A financial technology firm is seeking an experienced Business Analyst to analyze and document business requirements. The role entails collaboration...  ...in financial services. Proficiency in Agile methodologies and data analysis is crucial, along with strong communication skills.... 

    Compunnel, Inc.

    Oaks, PA
    4 days ago
  •  ...technology solutions company based in Wayne, PA, is seeking a Business Analyst specialized in Finance and Asset Management. The ideal...  ...business consultancy, requirements engineering, and process modeling. Responsibilities include facilitating business requirements,... 

    CNCSINFOTECH LLC

    Wayne, PA
    13 hours ago
  •  ...seeking an experienced Power BI Developer for a hybrid role. The...  ...8 years of experience in BI/Data Analytics, including 5 years specifically...  ...include designing data models, developing DAX calculations,...  .... Strong collaboration with business stakeholders and technical solution... 
    Senior
    Business intelligence

    NTT DATA, Inc.

    Oaks, PA
    1 day ago
  •  ...BI Developer Location: Blue Bell, PA Duration: Long...  ...years of IT experience with Business Intelligence, Data Mining, ETL, BI Reporting...  ...Qlikview & Qliksense data models by bringing data from different...  ...worked on star schema and snowflake schema concepts. Helped... 
    Senior
    Business intelligence
    Long term contract

    InterSources

    Blue Bell, PA
    3 days ago
  •  ...ROLE SENIOR DATA ENGINEER INDUSTRY...  ...individual to serve as a Sr. Data Engineer...  ...with commercial business leaders. This person...  ...Familiarity with various BI solutions (Power BI...  ...solutions (Snowflake) ~3+ years of experience...  ...with data modeling and data warehousing... 
    Senior
    Business intelligence
    Contract work
    Immediate start
    Remote work

    3B Staffing LLC

    Malvern, PA
    3 days ago
  •  ...Job Title: (Senior Power BI Developer) About Kyyba: Founded...  ...recruiting services, enabling businesses to effectively respond to...  ...DAX and Power queries, semantic model design, Power BI report, and dashboard...  ...strong expertise in semantic data modeling, advanced DAX... 
    Senior
    Business intelligence
    Visa sponsorship
    Work visa

    Kyyba

    Oaks, PA
    13 hours ago
  • Business Analyst ( Finance / Asset Management ) We provide creative and technology services and...  ...) stakeholders Translate business models into data models and vice versa Create information...  ...-ground in Information Management, BI and Data Management Knowledge of, and... 
    Business intelligence

    CNCSINFOTECH LLC

    Wayne, PA
    4 days ago
  •  ...partners to understand business needs, structures requests...  ..., and support s data-driven decision making....  ...~ Mentor s junior analysts and provide s guidance...  ...years' work experience in BI, analytics, data science...  ...implemented a hybrid working model for the majority of our... 
    Business intelligence
    Work experience placement

    Vanguard Group, Inc.

    Malvern, PA
    1 day ago
  • $85.16k - $131.91k

     ...Senior IT Data Analytics Visualization Analyst Location: Radnor, PA (Hybrid) Schedule: Full-Time, Day...  ...individual helps bring clarity to complex business challenges while elevating how data...  ...tools: Tableau, QlikView, Power BI etc. Familiarity working with Agile... 
    Senior
    Business intelligence
    Full time

    Main Line Health

    Radnor, PA
    8 hours ago
  • The Judge Group in Wayne, Pennsylvania, is seeking motivated students for a paid Business Analyst Summer Internship lasting approximately 8-10 weeks. Interns will engage in data analysis, documentation, and process evaluation while working closely with experienced professionals... 
    Internship
    Summer internship

    The Judge Group

    Wayne, PA
    3 days ago
  •  ...Data Analyst Role: Data Analyst with Guidewire and P&C Insurance Locations...  ...Work with business stakeholders and IT teams to...  ...understanding for the data warehouse model / optimal ways to use it....  ...for Data Warehousing, ETL, and BI Architectures. Candidate is... 
    Business intelligence
    Full time

    Keylent Inc

    Conshohocken, PA
    3 days ago
  • $120k - $150k

     ...oriented and dependable Data Operations Consultant...  ...work with engineering and business teams to implement...  ...department. Mentor analysts on technical and business...  .... Knowledge of data modeling, lineage, and governance...  ...workflows. Knowledge of BI tools such as Tableau.... 
    Business intelligence

    Piper Companies

    Wayne, PA
    13 hours ago
  • $72.9k - $131.6k

     ...Analyst, Data Analytics We are excited to bring on an Analyst, Data...  ...reporting solutions that drive business decisions and inform leadership...  ...and development, and data modeling. ~3+ years of experience in...  ...or similar tools (e.g. Power BI, Qlik, MicroStrategy, or similar... 
    Business intelligence
    Work experience placement

    Lincoln Financial Services

    Radnor, PA
    4 days ago
  •  ...We are hiring a Senior Data Analyst for our Internal Audit Analytics &...  ...clearly communicating insights to business and audit stakeholders....  ...logic Experience using Power BI or Tableau to clearly...  ...implemented a hybrid working model for the majority of our crew... 
    Senior
    Work at office

    Vanguard Group, Inc.

    Malvern, PA
    3 days ago
  •  ...marketing campaigns through advanced analytics, predictive modeling, and data science techniques. The ideal candidate will have a strong foundation...  ..., and data science. They will excel at addressing complex business questions using compelling analytical strategies and... 
    Senior
    Work experience placement

    Vanguard Group, Inc.

    Malvern, PA
    1 day ago
  • Power BI Developer (Hybrid) Location: Oaks, PA, U.S. Responsibilities...  ...Design scalable semantic data models using Power BI datasets and...  ..., Synapse, Databricks, Snowflake, or other enterprise platforms...  ...enterprise reports. Translate business requirements into technical BI... 
    Business intelligence

    NTT DATA, Inc.

    Oaks, PA
    1 day ago
  • $57.3k - $132.71k

     ...detail-oriented and strategic  Decision Model Business Analyst  to join our team. The ideal candidate...  ...needs and technology solutions, driving data-informed decision-making, and...  ...business intelligence platforms (e.g. Power BI, Azure DevOp) is a plus. ~ Experience... 
    Business intelligence
    Work at office
    Remote work
    Weekend work

    Berkshire Hathaway GUARD Insurance Companies

    Conshohocken, PA
    3 days ago
  •  ...Sr Business Analyst1 Key Responsibilities Act as a primary liaison between business...  ..., and defect triage Assist with data migration, integrations, and reporting requirements...  ...experience as a Business Systems Analyst in Salesforce implementations Strong... 
    Senior

    Jade Global

    North Wales, PA
    3 days ago
  • $96.2k - $151.4k

     ...Job Description The Business Analyst - Automation, Analytics & AI (BA -...  ...with business case preparation, data analysis, dashboard/report...  ...opportunities and recommendations for the Sr BA - AA & AI and AA & AI Lead....  ...with Excel and at least one BI tool; foundational... 
    Business intelligence
    For contractors
    Internship
    Local area
    Relocation
    Visa sponsorship
    Flexible hours
    Shift work

    Merck & Co. , Inc.

    North Wales, PA
    1 day ago
  •  ...to receive an alert: Title: Sr. Director Strategic Pricing Requisition...  ..., design value‑based pricing models, and drive data‑driven decision‑making to...  ..., regulatory changes, and business performance Market &...  ...SAP) Proficiency in Excel and BI tools; Experience with pricing... 
    Senior
    Business intelligence
    Work experience placement
    Local area
    Flexible hours
    3 days per week

    West Pharmaceutical Services, Inc

    Exton, PA
    3 days ago
  •  ...Senior Business Unit Strategy Analyst Apply ( locations Malvern, PA time type Full time posted...  ...Develops and leads complex business, data, and strategic analyses. Consults...  ...Vanguard has implemented a hybrid working model for the majority of our crew members,... 
    Senior
    Full time
    Work experience placement

    Vanguard

    Malvern, PA
    13 hours ago
  •  ...Req ID: 367798 NTT DATA strives to hire exceptional...  ...seeking a Power BI Developer (hybrid) to join...  ...scalable semantic data models using Power BI datasets...  ..., Synapse, Databricks, Snowflake, or other enterprise platforms...  ...reports. Translate business requirements into... 
    Business intelligence
    Work at office
    Remote work
    Flexible hours

    The Nippon Telegraph and Telephone Corporation (NTT)

    Oaks, PA
    a month ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr. Business Analyst - Data Modeling & BI (Snowflake). Be the first to apply!