Lead Data Architect at North Point Technology

St. Petersburg, Florida, United States -

Full Time

Start Date

Immediate

Expiry Date

21 Feb, 26

Salary

0.0

Posted On

23 Nov, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Architecture, Data Modeling, Data Lakehouse, Data Warehouse, Oracle, SQL Server, AWS Redshift, AWS DMS, Advanced SQL, PL/SQL, AWS Data Ecosystem, Scripting, Kafka, Metadata Management, Data Governance, BI Tools

Industry

Industrial Automation

Description

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.

Responsibilities

The Lead Data Architect will design and model enterprise data assets across on-prem and cloud environments, ensuring scalable, high-performance data solutions. This role involves partnering with various teams to establish best practices and drive strategic decisions around tooling and platform adoption.