Senior Data Analyst – Wealth Management Data & STTM

Blackbuck Insights; St. Louis (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Blackbuck Insights in Saint Louis, MO is seeking a Senior Data Analyst for our Wealth Management domain. You will lead data discovery, profiling, and STTM creation for enterprise data platforms, acting as the bridge between business teams and engineering.

You will design SQL-based analyses, document mappings, ensure data quality, and collaborate with ETL developers to translate business rules into technical specs while supporting QA and data governance initiatives.

Qualifications

• 5+ years of hands-on experience as a Data Analyst, Data Modeler, or Technical Business Analyst in enterprise data initiatives.
• Advanced SQL: complex scripts for data extraction and profiling.
• STTM Documentation: explicit STTMs for ETL/ELT pipelines or data migrations.
• Data Quality & Profiling: detect data anomalies and integrity issues.
• Strong communication: translating business logic to engineers and stakeholders.

Responsibilities

• Data Profiling & Pattern Analysis: run SQL across databases, data lakes, and warehouses to analyze distribution and quality.
• Source-to-Target Mapping (STTM): author and maintain mapping documents with rules, data types, keys, and transformations.
• Bridge with developers: walkthroughs of mappings with ETL/engineers to clarify business intent.
• Data Quality & Governance: define validation rules and remediate data gaps across datasets.
• Wealth Management domain mapping: analyze domain data like portfolios, holdings, fees, and trades.

Skills

Advanced SQL

Source-to-Target Mapping

Wealth Management Domain

Jira

Azure DevOps

Data Profiling

Data Pipeline

Relational Modeling

Data Governance

Data Quality

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or related quantitative field

Tools

Jira

Azure DevOps

Azure Synapse Analytics

SQL Server

Job description

Blackbuck Insights in Saint Louis, MO is seeking a Senior Data Analyst for our Wealth Management domain. You will lead data discovery, profiling, and STTM creation for enterprise data platforms, acting as the bridge between business teams and engineering.

You will design SQL-based analyses, document mappings, ensure data quality, and collaborate with ETL developers to translate business rules into technical specs while supporting QA and data governance initiatives.