Data Engineer/Architect

Job Description

About the Role

We are seeking a highly skilled Data Engineer / Data Architect to join our team on a contract basis. This role will focus on building and optimizing custom HubSpot integrations while owning the end-to-end data flow process across our systems. The ideal candidate is both a strategic advisor and a hands-on implementer, with deep experience in designing data architectures that leverage modern cloud platforms (AWS or Azure).

Responsibilities

• Lead the design and implementation of scalable data pipelines (ETL/ELT) across multiple platforms, with a strong emphasis on HubSpot integrations.
• Act as a strategic partner, advising the team on optimal data architectures, software capabilities, and best practices for structuring and managing data.
• Develop and maintain ETL/ELT workflows to ensure accuracy, scalability, and reliability of data flow.
• Collaborate with internal stakeholders to gather integration requirements and design technical solutions aligned with business needs.
• Proactively identify opportunities to improve data processes, governance, and performance.
• Troubleshoot and resolve integration and pipeline issues.

Qualifications

• Proven track record in data architecture and engineering, ideally with HubSpot API/custom integration experience.
• Strong understanding of ETL/ELT pipelines and data warehousing best practices.
• Hands-on experience with AWS, Azure, Snowflake, etc.
• Proficiency in SQL and comfort with scripting languages (e.g., Python).
• Solid grasp of relational data modeling, APIs, and integration design.
• Excellent communication skills with the ability to advise on strategic technical decisions.

Engagement Details

• Contract / freelance role (project-based, flexible hours).
• Remote-friendly.
• Duration and scope to be determined based on project needs.
• Required: U.S. Eastern time zone availability