Lead Data Architect

About the Role

North Point Technology is supporting a major financial services organization in hiring a Lead Data Architect to join their Enterprise Data & Analytics Architecture team. This role designs and models enterprise data assets across both on-prem and cloud environments, ensuring scalable, high-performance data solutions.

You will partner with Data Engineering, Enterprise Data Management, and Architecture teams to establish best practices, define data access patterns, and drive strategic decisions around tooling and platform adoption.

This position follows a hybrid schedule with 2–3 in-office days per week (approx. 10-12 days per month).

Responsibilities

Data Architecture & Modeling

• Design optimal logical and physical data models using ER Studio or similar tools

• Resolve complex performance, capacity, and replication challenges

• Architect and evaluate cloud-based data solutions

Data Lakehouse & Platform Engineering

• Lead data lakehouse design on AWS Redshift, Oracle Exadata, Apache Iceberg

• Optimize solutions for large-scale data volumes

ETL & Real-Time Data Pipelines

• Design ETL pipelines across medallion architecture layers

• Design Kafka schemas for real-time data movement

Data Management & Metadata

• Integrate metadata into the enterprise data catalog

• Collaborate with data management tooling teams

Platform Architecture & Tooling

• Drive optimal selection and use of data tools (on-prem + cloud)

• Advocate and enforce best practices for enterprise data platforms

Technical Leadership

• Serve as a SME for data architecture and modeling standards

• Influence engineering teams to adopt proper architectural practices

Data Access Strategy

• Establish data access patterns for analytics and operational use cases

• Recommend appropriate tools and technologies for data consumption

Required Skills

• Expert-level knowledge in Data Architecture, Data Modeling, Data Lakehouse, and Data Warehouse methodologies (star, snowflake, normalization/denormalization)

• Strong experience with:

  • Oracle (RAC, Exadata)

  • SQL Server

  • AWS Redshift

  • Oracle GoldenGate, AWS DMS

• Advanced SQL / PL/SQL and performance tuning

• Deep expertise in AWS Data Ecosystem:

  • Athena, Iceberg, Lake Formation, Glue, EMR, SageMaker, S3, Airflow, Aurora, Presto

• Scripting/automation (Shell, Python)

• Strong understanding of Parquet, Avro, JSON, and selecting formats for use cases

• Experience architecting both real-time (Kafka) and batch data pipelines

• Knowledge of metadata management and enterprise data governance

• Ability to create data access roles and secure cloud data assets (Lake Formation, Glue)

• Familiarity with BI/analytics tools (Tableau, ThoughtSpot, SageMaker)

• Financial services experience highly preferred

Preferred Qualifications

• AWS or relevant cloud certification

• Strong communication and enterprise collaboration skills

• Ability to lead, influence, and guide data engineering teams

Education

• Bachelor’s degree in Computer Science, Computer Engineering, Information Science, Business Administration, or related field (required)

Experience

• 10–15+ years of relevant professional experience

• Less than 25% travel

• Hybrid workstyle (St. Petersburg, FL)

Equal Opportunity

This position supports a major financial-services client committed to merit-based hiring, diversity, and an inclusive workplace.

North Point Technology is THE BEST place to work for curious-minded engineers motivated to support our country’s most crucial missions!  We focus on long term projects, leveraging the latest technology in support of innovative solutions to solve our customer’s most difficult problems.

At North Point Technology, EMPLOYEES come first!  We value our employees by providing excellent compensation, benefits, and a flexible work-life balance. We strive for a close-knit and open atmosphere where the owners are always directly available to our team members. 

Come join us! Apply with North Point Technology today! 

For positions requiring a federal security clearance, your clearance level must be clearly identified on your resume.