Lead Software Engineer / Developer (Python / Snowflake)
CoreThe Role
As a Principal Software Engineer, you will be a key technical leader responsible for designing, implementing, and optimizing our Marketing Data Platform. While this is a leadership role, you will be expected to be deeply involved in coding, architectural decisions, and driving technical excellence.
You will take ownership of:
- Hands-on Python & SQL development across Streamlit and Snowflake.
- Designing and implementing high-performance, scalable, and modular enterprise applications.
- Promote code quality, best practices, and coding standards (e.g., design patterns, modular architecture, and maintainable code structures).
- Driving test automation, CI/CD, and continuous delivery across the development lifecycle.
- Working with business stakeholders to translate requirements into robust, scalable technical solutions.
If you're passionate about engineering excellence, hands-on development, and driving innovation in marketing technology, this is the role for you.
What You’ll Do
1. Hands-On Development & Architecture
- Write and optimize production-grade Python & SQL code for Streamlit applications and Snowflake-based data processing pipelines.
- Build integrations with APIs and data flows from various marketing platforms (Meta, Google, etc.), media planning tools, and financial systems.
- Implement efficient, scalable data pipelines in Snowflake, leveraging best-in-class architecture patterns.
- Apply consistent coding standards, software design patterns, and modular architecture principles to improve code maintainability and readability.
2. Code Quality, Standards & DevOps Best Practices
- Define and enforce coding standards, code reviews, and engineering best practices across the team.
- Implement automated testing frameworks and continuous integration/delivery pipelines (CI/CD) for a seamless deployment process.
- Manage version control and release workflows using Git/Bitbucket.
- Own test strategy and test automation, ensuring all software releases are stable and reliable.
3. Building a World-Class Marketing Data Platform
- Architect and develop a scalable, Marketing Data Platform that centralizes marketing, media, and finance data.
- Design real-time data ingestion and processing workflows that integrate seamlessly with marketing platforms and analytics tools.
- Improve system performance, reliability, and data governance to ensure best-in-class operations.
- Ensure enterprise security, compliance, and scalability in platform design.
4. Leadership, Strategy & Team Development
- Be an active mentor and technical leader, upskilling and coaching analysts and developers.
- Foster a culture of engineering excellence, continuous learning, and collaboration.
- Define and communicate a clear technical vision and roadmap, aligning with business needs.
- Work closely with business stakeholders to identify opportunities for platform enhancement and innovation.
- Champion agile methodologies (Scrum, Kanban) and use tools like Jira for effective sprint planning and execution.
Your profile
- 7+ years of hands-on experience in software engineering, data platform development, or related fields.
- Expert in Python & SQL development, with hands-on experience in with Snowflake.
- Experience developing apps (using web application frameworks, e.g. Streamlit, R Shiny, Dash, Flask/Django.
- Deep knowledge of software engineering best practices, including design patterns, modular development, and scalable architectures.
- Experience with CI/CD, test automation, and release management for data platforms.
- Strong expertise in APIs, data pipelines, and cloud-based application architectures.
- Familiarity with Git/Bitbucket for version control and automated deployment workflows.
- Hands-on experience with Jira, Agile methodologies, and project management best practices.
- Proven ability to mentor, inspire, and lead technical teams.
- A passion for solving real business problems through technology.
Nice-to-Have Qualifications:
- Snowflake certification.
- Experience with AWS, GCP, or Azure cloud environments.
- Familiarity with marketing analytics, media planning workflows, or ad-tech platforms.
- Experience with governance, data security, and compliance best practices.
- Understanding of user-centric design and intuitive workflow development.
Why us?
- Hands-on leadership: Drive the technical vision while staying deeply involved in coding and software development.
- Build from the ground up: Shape the future of a next-generation Marketing Data Platform with direct business impact.
- Cutting-edge technology: Work with Snowflake, Python, Streamlit, and cloud-based architectures.
- High-growth, high-impact: Join a team that values innovation, engineering excellence, and solving real-world business problems.
- Flexible and hybrid working within the Republic of Ireland
- 24/7 access to professional development through LinkedIn Learning along with career progression and mentoring
- The opportunity to work across a huge range of clients within so many different categories from sport, retail, food and drink, to alcohol, insurance, banking and so much more
- Lead and shape the future of marketing measurement at a top media agency.
- Work on cutting-edge marketing science problems with real-world business impact.
- Build and deploy scalable data science tools that democratize advanced analytics.
- Collaborate with cross-functional teams of experts in media, marketing, and data science.
- 21 days annual leave plus a day off on your birthday, company closure days at Christmas and early finish on bank holiday Fridays
- A company culture that promotes work-life balance
- Family-focused benefits including paid maternity and paternity leave as well as maternity phase back program, fertility treatment supports and paid pregnancy loss leave
- Access to mental health and well-being programs including paid health insurance for you and your dependents under 18
- Professional financial advice; employer contributory pension and life assurance
- Make a difference by joining our D&I, CSR, Green, Social or Great Place to Work committees; you’ll get an extra days leave for your efforts.
- And lots more …
Salary Range
About us
Core is Ireland's largest marketing communications company with over 400 people working across the key areas of marketing communications - research, data science, strategy, planning, creative development and implementation. We are now a collective of nine practices, working towards a single purpose - to expand the possibilities of what brands can achieve. At Core, we believe that change can move us forward and compel us towards new possibilities. Our wonderful people are at the centre of our success. It is essential that we keep building a high-trust working environment that supports our people and enables them to flourish. There is no magic formula for becoming a great place to work. Instead, it involves working together, through constant change, to match the personal dreams and ambitions of our people with the aspirations of the organisation.
Over the years, we have cemented our position as a great place to work, time and time again. Voted Agency Network of the Year for 2024. This year, we were again voted as one of Irelands Top 10 Best Workplaces by the Great Place to Work Institute for the 16th year consecutively.