Principal Data Architect

Who Are Massive Rocket? Massive Rocket is a rapidly scaling Braze and Snowflake agency on a mission to transform how digital marketing, product, and engineering teams connect. In just five years, we’ve grown at speed and are now gearing up for our next big milestone: hitting $100M in revenue. We build human experiences at scale, powered by cutting‑edge web, mobile, cloud, data, and AI technologies. If you’re excited by innovation, love solving complex challenges, and want to help shape the future of digital experiences, you’ll feel right at home here.   Every role at Massive Rocket is entrepreneurial. The people who thrive here don’t just focus on their own remit — they understand the goals of the teams around them and actively contribute to the success of their colleagues, customers, and partners. We’re building a culture of ownership, collaboration, and growth, and we’re looking for people who want to make a real impact.   Who Are We Looking to Add to Our Team? We’re looking for an experienced Lead Data Engineer to design and deliver scalable, high-performance data solutions for our clients. You’ll lead data engineering initiatives, build and optimise data pipelines and models, and connect complex data sources to power analytics, customer engagement, and business decisions. Working closely with Data, CRM, and CDP teams, you’ll bring strong technical expertise across modern data platforms, with a focus on Snowflake, SQL, Python, and dbt. You’ll also guide engineering best practices, explore new technologies and AI tools, and help clients get more value from their data infrastructure. What Will You Do? Design, build, and maintain scalable ETL/ELT pipelines across batch and real-time data architectures. Develop and optimise data models, transformations, and workflows using SQL, Python, and dbt. Build and maintain integrations across cloud data platforms, warehouses, and external data sources Improve database performance, data reliability, and cost efficiency through monitoring and optimisation. Implement data quality checks, unit tests, and validation processes to maintain data integrity. Translate customer engagement and CRM data requirements into actionable data models and pipelines that power Braze and other platforms. Work with customer events, user attributes, identity resolution, and data synchronisation to support personalised customer experiences. Collaborate with Data, Analytics, CRM, and CDP teams to align technical solutions with client requirements and business goals. Provide technical leadership, guidance, and best practices to engineers and help drive continuous improvement. Identify opportunities to use AI tools, automation, and emerging technologies to improve engineering productivity and data workflows. Support multiple client engagements, communicate technical recommendations clearly, and adapt to changing priorities. What Makes You a Great Fit 5+ years of experience in data engineering, data platforms, or a similar technical role, with strong ownership of architecture, implementation, and optimisation. 4+ years of hands-on experience with SQL, data modelling, and ETL/ELT processes. 2+ years of experience using Python to build data applications and transformations. Practical experience with dbt and modular data transformation. Experience with cloud platforms such as AWS, Azure, or Google Cloud, and modern data integration tools. Strong understanding of data architecture, pipeline design, database performance, testing, and data quality. Experience translating business and customer engagement requirements into reliable data solutions. Strong communication skills, with the ability to explain complex technical concepts to non-technical stakeholders. Experience working in an agency or consulting environment, managing m