Lead Data Architect

2 weeks ago

St Petersburg, FL, United States North Point Technology Full time
*This role requires you to live within 25 miles of Tampa, FL. Applications outside this area are automatically rejected. No relocation. No exceptions.
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.

  • Lead Data Architect

    2 weeks ago

    St Petersburg, FL, United States Raymond James Financial Services Full time

    Job Description Summary Determines database structural requirements to support the organization's business needs. Job Description 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....

  • Lead Application Security Architect

    2 weeks ago

    St Petersburg, FL, United States Raymond James Financial Services Full time

    Job Description Summary The Raymond James Enterprise Application Security Architecture team is seeking a Security Architect to strengthen our organization's security posture by focusing on secure design reviews, threat modeling, and vulnerability remediation. This role is integral to ensuring our applications and systems meet the highest security standards....

  • IT Systems Engineer

    4 days ago

    St Petersburg, FL, United States Envera Systems Full time

    About The Organization Envera Systems is a leader in physical security and monitoring solutions, running a 100% cloud-native IT platform. We are scaling our data and analytics practice to better deliver intelligence and insights to both internal operations and customers.Description The IT Systems Engineer - Cloud Data & Analytics will design, build, and...

  • IT Systems Engineer

    1 week ago

    St Petersburg, FL, United States Envera Systems Full time

    About The Organization Envera Systems is a leader in physical security and monitoring solutions, running a 100% cloud-native IT platform. We are scaling our data and analytics practice to better deliver intelligence and insights to both internal operations and customers.Description The IT Systems Engineer - Cloud Data & Analytics will design, build, and...

  • IT Systems Engineer

    1 week ago

    St Petersburg, FL, United States Envera Systems Full time

    About The Organization Envera Systems is a leader in physical security and monitoring solutions, running a 100% cloud-native IT platform. We are scaling our data and analytics practice to better deliver intelligence and insights to both internal operations and customers.Description The IT Systems Engineer - Cloud Data & Analytics will design, build, and...

  • IT Systems Engineer

    6 hours ago

    St Petersburg, FL, United States Envera Systems Full time

    About The Organization Envera Systems is a leader in physical security and monitoring solutions, running a 100% cloud-native IT platform. We are scaling our data and analytics practice to better deliver intelligence and insights to both internal operations and customers.Description The IT Systems Engineer - Cloud Data & Analytics will design, build, and...

  • IT Systems Engineer

    2 weeks ago

    St Petersburg, FL, United States Envera Systems Full time

    Overview Envera Systems is a leader in physical security and monitoring solutions, running a 100% cloud-native IT platform. We are scaling our data and analytics practice to better deliver intelligence and insights to both internal operations and customers. Description The IT Systems Engineer - Cloud Data & Analytics will design, build, and optimize secure...

  • Principal Solutions Architect

    5 days ago

    St Petersburg, FL, United States Publicis Groupe Holdings B.V Full time

    Overview The Principal, Solutions Architect (Technical Integrations), is a critical technical resource throughout the entire client lifecycle, from initial sales engagement to post-sales integration and expansion. Serving as the first technical point of contact for clients, this role ensures a deep understanding of their technical requirements, providing...

  • Principal Solutions Architect

    4 days ago

    St Petersburg, FL, United States Publicis Groupe Holdings B.V Full time

    Overview The Principal, Solutions Architect (Technical Integrations), is a critical technical resource throughout the entire client lifecycle, from initial sales engagement to post-sales integration and expansion. Serving as the first technical point of contact for clients, this role ensures a deep understanding of their technical requirements, providing...

  • Principal Solutions Architect

    3 days ago

    St Petersburg, FL, United States Publicis Groupe Holdings B.V Full time

    Overview The Principal, Solutions Architect (Technical Integrations), is a critical technical resource throughout the entire client lifecycle, from initial sales engagement to post-sales integration and expansion. Serving as the first technical point of contact for clients, this role ensures a deep understanding of their technical requirements, providing...