Lead Data Architect

11/23/2025

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.

Working Hours

40 hours/week

Company Size

11-50 employees

Language

English

Visa Sponsorship

About The Company

North Point Technology, LLC, was founded in 2002 by Lisa W. Lee and Robert P. Lee, with a basic mission to provide the highest-quality service possible in systems integration, automation engineering and industrial controls. The firm also offers proprietary software products, which allow our clients to optimize their industrial automation processes and implement the latest in systems engineering solutions at a fraction of the cost and time. The firm is one of only a few systems integrators in the Northeastern U.S. which holds a Premier level of Certification in Ignition software by Inductive Automation. We employ a staff of highly specialized engineers with expertise in a wide variety of industries and applications. Our business administration and operations staff have executive level experience with Fortune 500 corporations in high tech manufacturing and engineering. We value and promote hard work, ingenuity, creativity, strong client partnerships, and good business ethics. North Point Technology is a business member of the Control Systems Integrators Association (CSIA) internationally, The Alliance for Manufacturing & Technology of the Southern Tier( AM&T), as well as The Greater Binghamton and Greater Syracuse Chambers of Commerce. We offer competitive compensation and benefits, a flexible and varied work environment, with challenging opportunities in the field of industrial automation and control systems engineering. We are growing with new office locations to support a diverse client base. We serve clients across the United States and around the world, including Canada, Europe, the United Kingdom, Australia, China, Central and South America, and the Caribbean. *North Point Technology, LLC is categorized as a Women Owned Business Enterprise(WBE) and a Small Business Enterprise. The company holds WBE Certification with the City of Albany, New York.

About the Role

<h2 data-start="452" data-end="475">About the Role</h2> 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). <h2 data-start="1132" data-end="1155">Responsibilities</h2> <h3 data-start="1157" data-end="1193">Data Architecture & Modeling</h3> <ul data-start="1194" data-end="1402"> <li data-start="1194" data-end="1278"> Design optimal logical and physical data models using ER Studio or similar tools </li> <li data-start="1279" data-end="1348"> Resolve complex performance, capacity, and replication challenges </li> <li data-start="1349" data-end="1402"> Architect and evaluate cloud-based data solutions </li> </ul> <h3 data-start="1404" data-end="1449">Data Lakehouse & Platform Engineering</h3> <ul data-start="1450" data-end="1584"> <li data-start="1450" data-end="1532"> Lead data lakehouse design on AWS Redshift, Oracle Exadata, Apache Iceberg </li> <li data-start="1533" data-end="1584"> Optimize solutions for large-scale data volumes </li> </ul> <h3 data-start="1586" data-end="1624">ETL & Real-Time Data Pipelines</h3> <ul data-start="1625" data-end="1739"> <li data-start="1625" data-end="1686"> Design ETL pipelines across medallion architecture layers </li> <li data-start="1687" data-end="1739"> Design Kafka schemas for real-time data movement </li> </ul> <h3 data-start="1741" data-end="1775">Data Management & Metadata</h3> <ul data-start="1776" data-end="1882"> <li data-start="1776" data-end="1831"> Integrate metadata into the enterprise data catalog </li> <li data-start="1832" data-end="1882"> Collaborate with data management tooling teams </li> </ul> <h3 data-start="1884" data-end="1923">Platform Architecture & Tooling</h3> <ul data-start="1924" data-end="2061"> <li data-start="1924" data-end="1991"> Drive optimal selection and use of data tools (on-prem + cloud) </li> <li data-start="1992" data-end="2061"> Advocate and enforce best practices for enterprise data platforms </li> </ul> <h3 data-start="2063" data-end="2091">Technical Leadership</h3> <ul data-start="2092" data-end="2227"> <li data-start="2092" data-end="2155"> Serve as a SME for data architecture and modeling standards </li> <li data-start="2156" data-end="2227"> Influence engineering teams to adopt proper architectural practices </li> </ul> <h3 data-start="2229" data-end="2257">Data Access Strategy</h3> <ul data-start="2258" data-end="2402"> <li data-start="2258" data-end="2332"> Establish data access patterns for analytics and operational use cases </li> <li data-start="2333" data-end="2402"> Recommend appropriate tools and technologies for data consumption </li> </ul> <h2 data-start="2409" data-end="2431">Required Skills</h2> <ul data-start="2432" data-end="3401"> <li data-start="2432" data-end="2593"> Expert-level knowledge in Data Architecture, Data Modeling, Data Lakehouse, and Data Warehouse methodologies (star, snowflake, normalization/denormalization) </li> <li data-start="2594" data-end="2734"> Strong experience with: <ul data-start="2624" data-end="2734"> <li data-start="2624" data-end="2653"> Oracle (RAC, Exadata) </li> <li data-start="2656" data-end="2674"> SQL Server </li> <li data-start="2677" data-end="2697"> AWS Redshift </li> <li data-start="2700" data-end="2734"> Oracle GoldenGate, AWS DMS </li> </ul> </li> <li data-start="2735" data-end="2783"> Advanced SQL / PL/SQL and performance tuning </li> <li data-start="2784" data-end="2914"> Deep expertise in AWS Data Ecosystem: <ul data-start="2828" data-end="2914"> <li data-start="2828" data-end="2914"> Athena, Iceberg, Lake Formation, Glue, EMR, SageMaker, S3, Airflow, Aurora, Presto </li> </ul> </li> <li data-start="2915" data-end="2955"> Scripting/automation (Shell, Python) </li> <li data-start="2956" data-end="3040"> Strong understanding of Parquet, Avro, JSON, and selecting formats for use cases </li> <li data-start="3041" data-end="3116"> Experience architecting both real-time (Kafka) and batch data pipelines </li> <li data-start="3117" data-end="3184"> Knowledge of metadata management and enterprise data governance </li> <li data-start="3185" data-end="3276"> Ability to create data access roles and secure cloud data assets (Lake Formation, Glue) </li> <li data-start="3277" data-end="3350"> Familiarity with BI/analytics tools (Tableau, ThoughtSpot, SageMaker) </li> <li data-start="3351" data-end="3401"> Financial services experience highly preferred </li> </ul> <h2 data-start="3408" data-end="3439">Preferred Qualifications</h2> <ul data-start="3440" data-end="3605"> <li data-start="3440" data-end="3479"> AWS or relevant cloud certification </li> <li data-start="3480" data-end="3540"> Strong communication and enterprise collaboration skills </li> <li data-start="3541" data-end="3605"> Ability to lead, influence, and guide data engineering teams </li> </ul> <h2 data-start="3612" data-end="3628">Education</h2> <ul data-start="3629" data-end="3765"> <li data-start="3629" data-end="3765"> Bachelor’s degree in Computer Science, Computer Engineering, Information Science, Business Administration, or related field (required) </li> </ul> <h2 data-start="3772" data-end="3789">Experience</h2> <ul data-start="3790" data-end="3907"> <li data-start="3790" data-end="3842"> 10–15+ years of relevant professional experience </li> <li data-start="3843" data-end="3867"> Less than 25% travel </li> <li data-start="3868" data-end="3907"> Hybrid workstyle (St. Petersburg, FL) </li> </ul> <h2 data-start="3914" data-end="3940">Equal Opportunity</h2> This position supports a major financial-services client committed to merit-based hiring, diversity, and an inclusive workplace.<div class="content-conclusion">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.</div>

Key Skills

Data ArchitectureData ModelingData LakehouseData WarehouseOracleSQL ServerAWS RedshiftAWS DMSAdvanced SQLPL/SQLAWS Data EcosystemScriptingKafkaMetadata ManagementData GovernanceBI Tools