Lead Data Architect

Robotics Prcocess Automation, LLC; New York (NY); On-site; USD 100,000 - 150,000; Full time

Job summary

A leading automation company based in New York City is seeking a Data Architect/Data Engineer to design and implement scalable data architectures. The role involves leading ETL processes with tools like DBT and Snowflake, collaborating with stakeholders to translate requirements into actionable solutions, and providing mentorship to data teams. Ideal candidates will have proven leadership experience, strong skills in data modeling, and the ability to work onsite up to 3 days per week.

Qualifications

• Proven experience as a Data Architect, Data Engineer, or similar role with leadership responsibilities.
• Strong proficiency in ETL/ELT design, data modeling, and data integration tools.
• Hands-on experience with Snowflake or comparable cloud data platforms.

Responsibilities

• Design, implement, and maintain scalable data architectures to support analytics.
• Collaborate with business stakeholders to translate requirements into data models.
• Lead ETL/ELT processes using modern tools and frameworks.

Skills

ETL/ELT design

Data modeling

Data integration tools

Communication skills

Analytical skills

Problem-solving skills

Tools

DBT

Fivetran

Azure Data Factory

Snowflake

MuleSoft

Jitterbit

Job description

Responsibilities

• Design, implement, and maintain scalable data architectures to support analytics, reporting, and data integration initiatives.
• Collaborate with business stakeholders to translate requirements into data models and architecture solutions.
• Lead ETL/ELT processes using modern tools and frameworks such as DBT, Fivetran, Azure Data Factory (ADF), and similar platforms.
• Oversee data modeling, data warehousing, and data quality initiatives using Snowflake and other cloud-based technologies.
• Ensure data governance, security, and compliance standards are met across all systems.
• Partner with development teams to integrate data solutions with enterprise systems via MuleSoft, Jitterbit, or similar tools.
• Provide technical leadership, mentorship, and guidance to data engineers and analysts.

Required Skills & Qualifications

• Proven experience as a Data Architect, Data Engineer, or similar role with leadership responsibilities.
• Strong proficiency in ETL/ELT design, data modeling, and data integration tools (DBT, Fivetran, ADF, MuleSoft, etc.).
• Hands‑on experience with Snowflake or comparable cloud data platforms.
• Excellent communication, analytical, and problem‑solving skills.
• Ability to work collaboratively with business stakeholders and translate requirements into actionable solutions.
• Must be based in or near New York City and available to work onsite up to 3 days per week.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.