Principal Data Architect

Responsibilities

• Data Lakehouse and Warehouse Architecture
• Data Modeling and Design Leadership
• Architecture Standards and Reuse
• Data Access and Consumption Strategy
• Platform and Technology Strategy
• Real-Time and Batch Data Architecture
• Thought Leadership and Innovation
• Governance, Metadata, Lineage, and Data Quality

Requirements

• Deep, hands-on experience in wealth management, asset management, brokerage, private client services, or closely related financial services domains.
• Proven ability to influence senior stakeholders, guide complex architectural decisions, mentor architects or senior engineers, and lead through ambiguity.
• Expert level knowledge of Data Architecture, Data Modeling, Data Lake house and data warehouse design methodologies (star schema, snowflake schema, normalization, denormalization).
• Proficient with database technologies: Oracle (including RAC, Exadata), SQL Server, AWS Redshift, and replication tools like Oracle Golden Gate and AWS DMS.
• Advanced SQL, PL/SQL development, and database performance tuning skills.
• Deep expertise in AWS Data Ecosystem—Athena, Iceberg, Lake Formation, Glue, EMR, Sagemaker, S3, Airflow, Aurora, Presto.
• Skilled in scripting and automation (Shell, Python).
• Data integration architecture: Ability to architect ETL/ELT, streaming, event-driven, API-based, file-based, and replication-based data flows, including data contracts, schema evolution, lineage, quality checks, and operational monitoring.
• Proven experience designing and operationalizing enterprise-scale data lake, Lakehouse, or data marketplace platforms, including governed data onboarding, metadata management, data product publishing.
• Demonstrated ability to assess, structure, and curate enterprise data for AI, advanced analytics, and GenAI use cases, including defining semantic models, ontologies, knowledge graphs.

Qualifications

• Bachelor's degree in Computer Science, MIS, or related field.
• 10+ years of progressive experience in data architecture, data engineering, database architecture, enterprise architecture, or large-scale data platform delivery.

Skills

• Must have deep, hands-on experience in wealth management, asset management, brokerage, private client services, or closely related financial services domains.
• Proven ability to influence senior stakeholders, guide complex architectural decisions, mentor architects or senior engineers, and lead through ambiguity.
• Expert level knowledge of Data Architecture, Data Modeling, Data Lake house and data warehouse design methodologies (star schema, snowflake schema, normalization, denormalization).
• Proficient with database technologies: Oracle (including RAC, Exadata), SQL Server, AWS Redshift, and replication tools like Oracle Golden Gate and AWS DMS.
• Advanced SQL, PL/SQL development, and database performance tuning skills.
• Deep expertise in AWS Data Ecosystem—Athena, Iceberg, Lake Formation, Glue, EMR, Sagemaker, S3, Airflow, Aurora, Presto.
• Skilled in scripting and automation (Shell, Python).
• Data integration architecture: Ability to architect ETL/ELT, streaming, event-driven, API-based, file-based, and replication-based data flows, including data contracts, schema evolution, lineage, quality checks, and operational monitoring.
• Proven experience designing and operationalizing enterprise-scale data lake, Lakehouse, or data marketplace platforms, including governed data onboarding, metadata management, data product publishing.
• Demonstrated ability to assess, structure, and curate enterprise data for AI, advanced analytics, and GenAI use cases, including defining semantic models, ontologies, knowledge graphs.

Benefits

• Total compensation includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions.
• Eligible for a benefits package that may include medical, dental, and vision; life insurance; critical illness insurance and accident insurance; disability benefits; retirement savings; paid time off (including vacation, holidays, and sick leave); and parental leave.

Pay

• The total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions.

Schedule

• This position follows our hybrid-friendly schedule, so you get the best of both worlds – flexibility and collaboration. In office days will be 2-3 per week averaging 10-12 days per month in our St Petersburg, FL Corporate Office.