Portfolio Administrator- Data Integrity and Investment Operations

ARQ Wealth Advisors, LLC

Scottsdale, AZ

JOB DETAILS
SKILLS
Analysis Skills, Auditing, Benchmarking, Bookkeeping, Cash Flow, Communication Skills, Computer Science, Customer Experience, Customer Relations, Customer Relationship Management (CRM), Customer Relationship Management (CRM) Systems, Customer Service Operations, Customer/Client Research, Data Analysis, Data Management, Data Quality, Dental Insurance, Detail Oriented, Develop and Maintain Customers, Finance, Financial Planning, Health Insurance, Internal Rate of Return (IRR), Investment Management, Leadership, Microsoft Excel, Multiplatform/Cross-Platform, Performance Analysis, Portfolio Accounting, Pricing, Problem Solving Skills, Process Improvement, Reconciliation, Scalable System Development, Team Player, Wealth Management
LOCATION
Scottsdale, AZ
POSTED
30+ days ago
Benefits:
  • 401(k)
  • 401(k) matching
  • Competitive salary
  • Dental insurance
  • Health insurance
  • Opportunity for advancement
  • Paid time off

ARQ Wealth Advisors is a fast-growing, boutique, independent wealth management firm based in Scottsdale, Arizona, overseeing ~$1.2B in client assets. We provide comprehensive investment management and financial planning with a focus on delivering a high-quality client experience.


The Portfolio Administrator Role


We are seeking an experienced, detail-oriented Portfolio Administrator to join our investment operations team. This role sits at the intersection of data integrity, reporting, and trading support, ensuring that all client and advisor data is accurate, consistent, and reliable.
This is not a basic ops role. We are looking for someone who understands how portfolio data flows through systems, where it breaks, and how to proactively fix issues before they become client-facing. At ARQ, you’ll have the opportunity to build your career at a firm that values your growth, both professionally and financially. 


Responsibilities:


Account Administration
  • Set up and maintain client accounts across custodial platforms
Data Integrity & Reconciliation
  • Audit and maintain portfolio data across systems (Tamarac, CRM, custodians)
  • Identify and resolve discrepancies (pricing, transactions, cash, performance)
  • Build proactive checks and reporting controls
Security Setup & Classification
  • Maintain security master data (asset class, sector, benchmarks)
  • Ensure consistency across reporting, trading, and performance
  • Partner with investment team on proper classification
Trading & Cash Support
  • Support traders with cash raises, flows, and rebalancing
  • Reconcile trades and monitor cash/settlement activity
Performance & Reporting
  • Audit performance and investigate outliers
  • Ensure accurate client reporting (including proper TWR vs IRR usage), including the creation of all client reports on a quarterly basis
  • Maintain clean, presentation-ready outputs
Systems & Process Improvement
  • Improve workflows across Tamarac, CRM, and custodians
  • Build scalable processes to reduce errors and manual work
  • Serve as a resource for data-related issues across the firm

Position Requirements:


Experience:
  • 3–7+ years in investment operations or portfolio administration
  • Strong understanding of portfolio accounting, performance, and data flows
Systems Expertise (Preferred):
  • Envestnet/Tamarac experience (or other data management and reporting systems)
  • PortfolioCenter experience
  • Familiarity with Schwab, Fidelity, and CRM systems

Skills:
  • Strong Excel and data analysis skills
  • High attention to detail; strong problem-solving mindset
  • Ability to build repeatable processes

Professional Attributes:
We are looking for a self-starter with an ownership mentality; your role is to take responsibility for data quality across the firm. You will need to be a highly collaborative person; we are a highly engaged team of 18 professionals, and your daily responsibilities will include interacting with leadership, advisors, traders, client services, and operations. You should be a clear communicator; explaining issues and resolutions succinctly is a big piece of the work you will do.


Education / Credentials (Preferred):
  • Bachelor’s degree in Computer Science, Finance or related field
  • Professional certifications or interest in pursuing designations is a plus
Compensation & Benefits:
  • Competitive salary based on experience
  • 401(k) with match + profit sharing
  • Health, dental, life, and disability insurance
  • PTO and occasional WFH flexibility

About the Company

A

ARQ Wealth Advisors, LLC