Cloud Data Engineer for AI-Ready Analytics

Hamilton Barnes Associates Limited; United States; On-site; USD 140,000 - 155,000; Full time

Job summary

Hamilton Barnes Associates Limited is seeking a Data Engineer to design, build, and maintain a cloud data platform that supports analytics, reporting, automation, and AI-driven applications. The role emphasizes enterprise data architecture, data integration, scalable models, and secure, reliable data workloads.

The candidate will model geospatial data, support RAG and AI workloads, and collaborate with IT, Security, and stakeholders to translate operational needs into scalable data solutions

Qualifications

• Bachelor's degree or equivalent practical experience
• 3–6 years of data engineering experience with enterprise data warehouses and scalable analytical models
• Strong SQL and data modeling principles
• Hands-on with Snowflake/BigQuery/Redshift or similar
• Proficient in Python for data integration and pipelines
• Experience with geospatial data and Azure data services
• Able to own and deliver data solutions in a fast-paced environment
• Excellent communication with stakeholders

Responsibilities

• Design scalable cloud-based data models integrating multiple data sources
• Develop and maintain ingestion, transformation, orchestration, and monitoring processes
• Create and optimize data warehouses, marts, and analytical datasets for analytics and AI workloads
• Model and manage geospatial data and location-based relationships
• Structure data to support RAG, AI search, analytics and ML
• Establish data quality, governance, lineage, and confidentiality standards
• Collaborate with IT, Security, and Infrastructure for access controls and reliability
• Partner with stakeholders to translate requirements into scalable data solutions
• Monitor and optimize data platform performance and cost
• Utilize AI-powered tools to enhance productivity and outcomes

Skills

SQL

Data modeling

Python

Geospatial data

Azure data services

Data integration

Stakeholder communication

Education

Bachelor's degree in CS/IS/Data Eng or related

Tools

Snowflake

BigQuery

Redshift

dbt

Airflow

Azure Data Factory

Dagster

Esri ArcGIS

Job description

Hamilton Barnes Associates Limited is seeking a Data Engineer to design, build, and maintain a cloud data platform that supports analytics, reporting, automation, and AI-driven applications. The role emphasizes enterprise data architecture, data integration, scalable models, and secure, reliable data workloads.

The candidate will model geospatial data, support RAG and AI workloads, and collaborate with IT, Security, and stakeholders to translate operational needs into scalable data solutions