Senior Data Analyst | Wealth Management Practice

Algo Soft Solutions LLC

United States

4 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

JIRA Microsoft Azure Cloud Computing Profiling Information Systems Data Discovery Data Integrity Extract Transform Load (ETL) Data Mapping Data Mining Data Profiling Data Vault Modeling

+16 more

Data Warehousing Scrum Methodology Cloud Services Azure Data Lake SQL Databases Azure Data Factory Sql Optimization Snowflake Analytic Functions Information Technology Data Lineage Data Analytics Data Management Azure Synapse Analytics Data Pipelines Databricks

Requirements

We are seeking a highly analytical Senior Data Analyst to lead data discovery, quality profiling, and Source-to-Target Mapping (STTM) for enterprise wealth management data platforms. This role serves as the critical bridge between wealth business teams and engineering developers., * Experience: 5+ years of hands-on experience as a Data Analyst, Data Modeler, or Technical Business Analyst in enterprise data environment initiatives.

Advanced SQL Expertise: Proven mastery in writing complex SQL scripts (multi-table JOINs, CTEs, window functions, subqueries, and analytical functions) for data extraction and profiling.
STTM Documentation: Demonstrated experience creating explicit, comprehensive Source-to-Target Mappings (STTM) for ETL/ELT pipelines, reporting, or data warehouse migrations.
Data Quality & Profiling: Strong background in identifying data anomalies, missingness, structural inconsistencies, and data integrity issues.
Communication Skills: Exceptional verbal and written communication skills with proven experience leading technical specification reviews with software developers and architects.
Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related quantitative field., * Wealth Management Domain Knowledge: Direct experience working with financial, wealth, investment management, brokerage, or banking data domains (e.g., portfolio management, custodial feeds, advisory accounts).
MS Azure Cloud Environment: Exposure to or experience working with cloud data platforms on Microsoft Azure (e.g., Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Storage, or Databricks on Azure).
Modern Data Stacks: Familiarity with modern data modeling concepts (Dimensional, Snowflake, Data Vault) and orchestration workflows.
Agile/Scrum Framework: Experience working in Agile/Scrum delivery models, managing user stories, and utilizing tools like Jira or Azure DevOps.

Core Skills & Competencies