Portfolio Administrator- Data Integrity and Investment Operations

Portfolio Administrator- Data Integrity and Investment Operations Scottsdale, AZ Job Details Full-time 22 hours ago Benefits Profit sharing Disability insurance Health insurance Dental insurance 401(k) Paid time off 401(k) matching Opportunities for advancement Qualifications Investment Financial data reconciliation Computer Science Process optimization Bachelor's degree in finance Process improvement Data reporting Mid-level Finance Outlier detection Bachelor's degree Data classification Data quality monitoring Accounting CRM system proficiency Data validation Bachelor's degree in computer science Master data management Account opening Trade settlement Excel data analysis

Full Job Description 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