Back to search
AMroute LLC Linkedin · Posted 19d ago

Data Architect

Bluffdale

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

Job Title: Data Architect

Location: New York City, NY, onsite (local candidates are a top priority)

Duration 12+ months

40 hours a week

We are seeking a highly experienced Senior Data Architect with strong hands-on expertise in data analytics, Databricks on AWS, PySpark, Python, SQL, and ETL tools such as Informatica. This is a senior leadership role requiring strong technical ownership, proactive risk and issue management, and excellent communication skills.

The ideal candidate will have deep experience designing scalable, secure, and cost-efficient data solutions on AWS, migrating data assets from on-premises platforms to the cloud, and leveraging GenAI-driven automation to accelerate data modernisation initiatives.

Key Responsibilities

Design and implement scalable, secure, and cost-efficient data architecture solutions on AWS.

Lead data migration initiatives from on-premises environments to AWS.

Work hands-on with Databricks on AWS, PySpark, Python, and SQL to build data pipelines and analytical solutions.

Develop data models and deliver data-driven insights to support business decision-making.

Design and build PySpark applications to extract, transform, aggregate, and analyse large datasets.

Support migration of data assets to the cloud using GenAI-enabled automation approaches.

Work with large language models including pretraining, fine-tuning, augmentation, and optimisation use cases where applicable.

Identify, gather, and consolidate data from diverse sources including internal databases, spreadsheets, and enterprise systems.

Apply data quality checks, cleaning processes, and transformations using Python, Pandas, and SQL.

Automate repetitive data preparation and workflow tasks using scalable scripts and code-based practices.

Collaborate with stakeholders to clarify requirements, challenge assumptions, and validate data quality.

Document data workflows, coding standards, analytical methodologies, and best practices.

Proactively identify, communicate, and manage project risks, issues, dependencies, and delivery blockers.

Operate independently with minimal supervision while maintaining strong collaboration with business and technical teams.

Required Skills

15+ years of experience as a Data Architect, Data Engineer, Data Analyst, or related data-focused role.

Hands-on experience with Databricks on AWS.

Strong PySpark, Python, Pandas, SQL, and data analytics experience.

Experience with ETL tools such as Informatica.

Proven experience migrating data from on-premises platforms to AWS.

Experience designing and implementing scalable, secure, and cost-efficient data solutions on AWS.

Strong data modelling and database solution design experience.

Experience developing PySpark applications for extraction, transformation, aggregation, and insight generation.

Experience with GenAI-driven automation for cloud data migration or data modernization.

Exposure to LLM pretraining, fine-tuning, augmentation, and optimization.

Ability to automate data workflows and implement code-based best practices.

Strong documentation, communication, stakeholder engagement, and requirement clarification skills.

Preferred Skills

Experience with Python libraries such as Pandas, Scikit-learn, and Matplotlib.

Experience working with multiple structured and semi-structured data formats.

Strong understanding of data governance, data quality, and reproducibility practices.

Experience in large enterprise data modernization programs.

Bachelor's degree or higher in Computer Science, Data Engineering, Analytics, or a related field.

Behavioral Expectations

Excellent communication skills with the ability to explain analytical findings to technical and non-technical stakeholders.

Proactive approach to risk and issue management.

Strong critical thinking and problem-solving ability.

Ability to question assumptions, assess data quality, and recommend alternative approaches.

Self-directed, resourceful, and comfortable managing priorities independently.

Collaborative mindset with the ability to work closely with cross-functional teams.

Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock more results and save your role and location preferences.

Unlock free search
Want help applying to roles like this? Search Caio for free. If repetitive applications get heavy, Managed Job Search adds supervised execution for $99/month.
View Managed Job Search