Business Solutions Architect

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 month(s)
No Travel Required

Skills

JSON
Problem Solving
Microsoft Azure
Accounting
Business Requirements
Requirements Analysis
Asset Management
Systems Integration
Databricks
Communication Skills
Acceptance Testing
Engineering Design Process
Knowledge of Finance
Software Design Documents
SQL Databases
Snowflake
Investment Strategies
Information Engineering
Operational Databases
SQL Azure
Financial Securities
Azure Data Factory
Systems Implementations

Job Details

Business Solutions Architect – Investment Systems

Location: Minneapolis, MN (On-site)
Type: Contract

Overview

Seeking a Business Solutions Architect with strong investment operations knowledge and technical design skills. This role focuses on translating business requirements into system designs, data mappings, and process flows across investment and accounting systems—primarily PAM, Aladdin, and Bloomberg. Must have deep understanding of CMLs, RMLs, and private securities, along with hands-on experience in Azure data engineering tools.

Key Responsibilities

  • Gather requirements from investment operations and identify data gaps.

  • Design solutions for system synchronization and reconciliation across PAM, Aladdin, and other platforms.

  • Create high-level and detailed design documents, including data mappings and transformation logic.

  • Build starter SQL for Azure SQL/Snowflake to support development teams.

  • Oversee solution implementation; support SIT/UAT cycles.

  • Troubleshoot production data issues and assist with incident resolution.

  • Maintain documentation for system processes and data flows.

Must-Have Skills

  • Deep investment operations knowledge: CMLs, RMLs, private securities, portfolios, data elements.

  • Strong understanding of how these assets are represented in PAM (ABOR) and Aladdin (IBOR).

  • Technical skills: SQL, JSON, Azure Data Factory, Logic Apps, Databricks, Snowflake.

  • Experience designing data mappings, transformations, and system integration flows.

Nice-to-Have

  • Experience with Aladdin Data Cloud.

  • Background in financial services or asset management.

  • Strong documentation and communication skills

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Advantra Consulting Group