Weekday (YC W21)

Data Architect

Weekday (YC W21)

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

CloudETLOraclePySparkPythonSQL

About the role

  • Design and own enterprise data architecture for investment management and asset management platforms, ensuring scalability, performance, and data integrity.
  • Lead data modeling efforts for securities, holdings, trades, positions, pricing, corporate actions, and fund accounting datasets.
  • Architect and develop high-performance Oracle data solutions, including advanced PL/SQL, stored procedures, and optimization strategies.
  • Build and manage data pipelines using Python and PySpark for large-scale batch and analytical processing.
  • Define and enforce data standards, governance, lineage, and quality controls across critical financial datasets.
  • Partner with investment operations, fund accounting, risk, and reporting teams to understand data usage and analytical needs.
  • Support downstream consumers including reporting, regulatory, analytics, and portfolio management systems.
  • Drive modernization initiatives by integrating traditional Oracle platforms with distributed processing and cloud-ready architectures where applicable.
  • Provide technical leadership, mentoring data engineers and reviewing design and implementation best practices.

Requirements

  • 8–20 years of experience as a Data Architect or Oracle Data Engineer, preferably within financial services.
  • Strong hands-on expertise in Oracle databases, PL/SQL, and complex stored procedures.
  • Proven experience with Python and/or PySpark for data engineering and transformation workflows.
  • Deep domain knowledge of Investment Management, Asset Management, Fund Accounting, or related financial data domains.
  • Strong understanding of financial instruments, including securities, trades, holdings, positions, and transactions.
  • Experience designing enterprise-scale data models, ETL/ELT pipelines, and analytical data stores.
  • Ability to work with large, complex, and highly regulated datasets with strict accuracy requirements.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data architectureOracle databasesPL/SQLstored proceduresPythonPySparkdata modelingETLELTdata governance
Soft Skills
technical leadershipmentoringcollaborationcommunication