Business Technical Architect

Incedo Inc.; Pittsburgh (Allegheny County); On-site; USD 150,000 - 210,000; Full time

Job summary

Incedo Inc. seeks a senior data professional to own investment data analysis, architecture, and governance. You will shape data models and APIs, reconcile complex data requirements, and guide cross-functional teams from concept to funded implementation.

You will work with security master, market data, performance and risk data, ensuring data quality and consistent definitions across platforms. A hybrid collaboration approach with PMs, risk, and engineering is expected.

Qualifications

• Advanced SQL skills with complex query optimization.
• Experience designing data models and target-state architectures for financial data.
• Strong communication between PMs, risk, and engineering teams.

Responsibilities

• Analyze and reconcile investment data directly (SQL against Oracle, Hadoop/PySpark) to answer business questions.
• Design target-state data models, integration patterns, and data-serving designs (GraphQL/API layers).
• Translate ambiguous needs into clear problem statements, backlogs, and outcomes for stakeholders.
• Lead design reviews with engineering and platform teams; justify trade-offs in modeling and storage.
• Own data domains: security master, market data, performance, risk, and ESG/alternative data.
• Govern data as a product with quality SLAs, lineage, and shared definitions.
• Evaluate market data vendors for coverage, cost, and redundancy.

Skills

SQL expertise

Data modeling

Data architecture

Stakeholder communication

Hybrid collaboration

Financial data domain knowledge

Tools

Oracle

Hadoop

PySpark

GraphQL

Hive

Job description

We're hiring someone who can drive investment data from every angle — the analysis, the architecture, the business conversation, and the technical one. Not a pure strategist who hands off, and not a pure engineer who waits for requirements. You'll go from a portfolio manager's messy question to a query, to a data model, to a target-state design, to the discussion that gets it funded and built.

You'll own how investment data — reference, market, portfolio, performance, risk, and alternative data — is analyzed, modeled, architected, governed, and delivered to the people who make investment decisions.

What You'll Do

• Analyze the data yourself — profile, query, and reconcile investment data directly (SQL against Oracle, distributed processing on Hadoop/PySpark) to answer business questions and pressure-test assumptions before they become designs.
• Design the architecture — target-state data models, integration patterns, and data-serving designs (including GraphQL and other API layers) that balance performance, cost, and maintainability.
• Drive the business discussion — turn ambiguous needs from PMs, research, risk, and client reporting into a clear problem statement, prioritized backlog, and outcomes stakeholders care about.
• Drive the technical discussion — lead design reviews with engineering and platform teams; make and defend trade-offs on modeling, storage, processing, and distribution.
• Own the data domains — security master and reference data, market/pricing data, holdings and transactions, benchmarks, performance and attribution, risk, and ESG/alternative data.
• Govern data as a product — ownership, quality SLAs, lineage, and shared definitions so a "position" or an "AUM" number means the same thing everywhere.
• Rationalize vendors and platforms — evaluate market data and platform vendors (Bloomberg, LSEG/Refinitiv, FactSet, MSCI, ICE, Aladdin/other OMS) against coverage, cost, and redundancy.

Required Skills & Experience

• 7-12 years across investment management, financial services data, or related consulting, with real exposure to the buy-side investment lifecycle.
• SQL — advanced query writing and performance tuning.
• Hadoop — working knowledge of the big-data ecosystem (HDFS, Hive, etc.).
• PySpark — building and optimizing distributed data processing.
• GraphQL — designing and exposing data through GraphQL / API-based serving layers.
• Working fluency in investment data domains (security master, benchmark files, performance return streams, and how they connect).
• Proven ability as a genuine hybrid — trusted by business stakeholders and respected by engineers.
• Data modeling and architecture experience — able to design a target state, not just critique one.
• Strong written and verbal communication; comfortable moving between a PM, a CDO, and a data engineer in the same afternoon.