Data Analyst

Summit Financial; Parsippany-Troy Hills (NJ); Presencial; USD 70.000 - 110.000; Jornada completa

Descripción de la vacante

Summit Financial LLC is seeking a hands-on Data Analyst to own data quality, reconciliation and reporting across CRM, portfolio accounting, custodial, fee billing and advisor compensation. The role sits between the enterprise data platform (Microsoft Fabric, Azure SQL, Power BI) and business teams that depend on it.

The analyst builds Power BI dashboards and SQL-based controls on Microsoft Azure and Fabric, supports data integrations and migrations, and uses AI tools daily to validate outputs.

Formación

• Bachelor’s degree or equivalent experience.
• 1–3 years data/operations/reporting in RIA/wealth platform.
• Strong advisor/rep code and fee/revenue attribution knowledge.
• Experience with portfolio accounting and trading data.
• Strong Azure SQL and advanced Excel; handle large datasets.
• Power BI experience and data modeling.
• Experience with AI tools and validating outputs.
• Attention to detail and ability to work independently.

Responsabilidades

• Reconcile client, household, account, advisor and rep-code data across CRM, portfolio accounting, custodial and billing systems.
• Identify and fix duplicate records, orphaned accounts, broken householding, stale dates and attribution mismatches at the source.
• Design data quality rules, exception reports and control dashboards in Power BI and SQL.
• Maintain data definitions, source-of-record standards, data dictionaries, lineage and reference data; support Master Data Management (Purview).
• Write and optimize SQL on Azure SQL, on-prem databases and Fabric.

Conocimientos

SQL (Azure)

Power BI

Data reconciliation

Advanced Excel

AI tooling

Communication

Independent work

Educación

Bachelor’s degree in Finance/Analytics/CS

Herramientas

Azure Fabric

Azure Data Factory

Purview

Salesforce

Descripción del empleo

Summit Financial LLC is a $30 billion Registered Investment Advisory (RIA) firm that has been providing comprehensive financial planning and wealth management services to high-net-worth individuals for over 40 years. Consistently recognized for our expertise, Summit currently ranks in the top 40 of all RIA firms by Barron's & Forbes and is one of the fastest growing RIAs in the country with over 200 advisors across 30 states and headquartered in Parsippany, New Jersey.

Job Summary

Summit Financial is seeking a hands-on Data Analyst to own data quality, reconciliation and reporting across its core wealth-management systems: CRM, portfolio accounting, custodial, fee billing and advisor compensation. The role sits between the enterprise data platform (Microsoft Fabric, Azure SQL, Power BI) and the business teams that depend on it. The analyst builds Power BI dashboards and SQL-based controls on Microsoft Azure and Fabric, supports data integrations and migrations, and uses AI tools such as Claude Code and Copilot daily to work faster while validating every result.

Key Responsibilities

• Reconcile client, household, account, advisor and rep-code data across CRM (Salesforce), portfolio accounting, custodial and billing systems
• Identify and fix duplicate records, orphaned accounts, broken householding, stale effective dates and fee or revenue-attribution mismatches at the source
• Design data quality rules, exception reports and control dashboards in Power BI and SQL
• Maintain business definitions, source-of-record standards, data dictionaries, lineage and reference data; support Master Data Management (Microsoft Purview)
• Write and optimize SQL on Azure SQL, on-premises databases and Microsoft Fabric
• Support Azure Data Factory and Fabric pipelines, advisor onboarding, acquisitions, system integrations and data migrations (field mapping, identifier matching)
• Partner with Finance, Operations, Compliance and Investment Management to turn requirements into durable controls
• Use Claude Code, Copilot and similar AI tools to accelerate SQL, analysis and documentation, owning the output

Required Qualifications

• Bachelor’s degree in Finance, Business, Data Analytics, Information Systems, Computer Science or a related field, or equivalent experience
• 1-3 years working with data, operations, billing or reporting at an RIA, hybrid RIA/broker-dealer or wealth-management platform
• Strong command of advisor and rep codes, householding, custodial identifiers, AUM/AUA logic, advisory fee schedules, billing and revenue attribution
• Working knowledge of portfolio accounting and trading data (positions, transactions, cash, models)
• Strong SQL (Azure SQL, Microsoft Fabric) and advanced Excel; comfort with large, messy datasets and reconciliation logic
• Power BI or comparable BI tool experience (data models, dashboards)
• Current use of AI tools such as Claude Code or Copilot, with the ability to explain how you validate AI-generated output
• Exceptional attention to detail, clear communication with nontechnical stakeholders, and the ability to work independently

Preferred Qualifications

• Python or PySpark for data profiling and automation
• Data governance or MDM tooling (Microsoft Purview); data-quality controls in a production environment
• Salesforce integration; custodial and portfolio platforms such as Schwab, Fidelity, Goldman Sachs, Pershing, SEI or Addepar
• Microsoft PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer) certification