Our Story So Far:
Since our founding in 2019, Pigment has become one of the fastest-growing SaaS companies in the world today. Our product, a highly efficient Enterprise Performance Management (EPM) platform is helping companies achieve their financial goals by quickly responding to dynamic factors in their respective markets including Tech, Retail, CPG & Financial Services.
In less than 5 years, Pigment has grown to over 400 employees across offices in New York, Toronto, London & Paris and attracted a total of $393M in investment from some of the top Venture Capital firms globally.
We serve companies including Unilever, Deliveroo, Gong and Brex to name a few!
As a Data Engineer, you will play a crucial role in designing, building, and managing the whole infrastructure and systems that collect, store, and process data. You will also work closely with Data Analysts to improve the quality and reliability of our data and the execution of our analytics projects.
Our stack is mainly composed of GCP (Postgres DBs, BigQuery, Cloud Storage, Cloud Functions and Schedulers), Fivetran, dbt and Terraform.
Key Responsibilities:
Data Integration & Transformation:
- Integrate data from a wide variety of sources, including APIs, external databases, and third-party services
- Transform raw data into clean and ready-to-use models for use in Pigment using dbt
Scalability, Reliability, and Security:
- Design scalable data architectures capable of handling increasing data volumes and complexity
- Implement robust backup and recovery strategies leveraging both BigQuery and Cloud Storage
- Implement data security measures to protect sensitive information and ensure compliance with relevant - regulations
Enhanced Data Quality and Data Hygiene:
- Develop and enforce data hygiene standards and processes to ensure clean and accurate data
- Develop and maintain comprehensive documentation for data processes, architectures, and workflows
Alerting and Monitoring:
- Set up automated alerts for data pipeline failures, data quality issues, and performance bottlenecks
- Implement monitoring tools to track data pipeline health and performance metrics
- Proactively address issues before they impact data availability and quality
Improved Collaboration & Support:
- Foster collaboration with Pigment data teams (RevOps, Growth & Product) to unlock synergies on cross-functional projects
- Provide technical support and guidance on best data usage practices within the organization
Performance Tuning:
- Optimize BigQuery queries and manage resources to reduce costs and improve efficiency
- Fine-tune Cloud Functions to ensure efficient execution of data workflows
Who You Are
- 3+ years of proven experience as a Data Engineer, preferably in a tech company
- Strong coding skills in both Python and SQL
- Very experienced with dbt and at least one Cloud provider (ideally Google Cloud Platform)
- Knowledge of scalable data architecture design and implementation
- Curious and eager to learn about various technologies and processes (Cloud Infrastructure, CI/CD, Docker, Terraform …). Existent knowledge on these points is a plus
- Strong analytical and problem-solving skills with high attention to detail
- Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams
- Comfortable working in a fast-paced environment
- Proficiency in English; knowledge of French is a plus
What we offer
- Competitive package
- Equity
- Healthcare
- Along with one company offsite every year, we have brand new offices at the heart of major cities including New York, Toronto, Paris, and London
- High-end equipment (based on stock/availability) to do your work in the best conditions.
- Hybrid remote policy
How we work
- Thrive Together: We can only win as a team. We are all founders and do the right thing for our peers, Pigment customers, partners, and the planet
- Never Settle: We aim to become the best at what we do by delivering with rigor and ambition every day. Delivering means building a passionate Pigment community
- Go for it: We are biased towards action. Every action leads to learning and these learnings get us one step closer to our mission
- Be real, be humble: We are generous with our feedback, open to change our views and we approach it with empathy knowing everyone is trying to do the best for Pigment
Pigment is an equal opportunity employer. We believe diversity is a strength and fosters innovation. We are committed to enabling everyone to feel included and valued at the workplace. All qualified applicants will receive consideration for employment without regard to age, color, family, gender identity, marital status, national origin, physical or mental disability, sex (including pregnancy), sexual orientation, social origin, or any other characteristic protected by applicable laws. We may process your personal data in accordance with our HR Data Protection Notice.
Top Skills
What We Do
In a world moving at an incredibly fast pace, businesses have grown accustomed to change. Transforming their business model, pivoting their strategy, rethinking their go-to-market, the list goes on.
To enable these changes, they have also had to rethink the way they work.
Breaking down silos isn’t a best practice anymore. It’s a given.
And yet, when it comes to planning, little has changed. In fact, planning tools work the exact opposite way, reinforcing data and people silos, and preventing teams from working together toward their common goals.
As a result, planning is usually seen as a dreadful process.
But the truth is, planning drives strategy. It’s high time we serve it with the right tools.
Pigment is the business planning platform for fast-growing companies. Our mission is to help companies make better, faster decisions in a changing world, and drive revenue growth.
At Pigment we believe that:
✅ Real-time data informs better outcomes. Trim your sail, and make the best use of current winds.
✅ Reporting should be accurate, quick, and insightful.
✅ Planning should be simple, smooth, and delightful.
✅ Less time should be spent on data crunching, more time on bringing insights to the business.
✅ Collaboration should be at the heart of any planning process, so your organization works as one.
Book your demo today ? https://www.gopigment.com/contact
We’re hiring! Check out our offers: https://jobs.lever.co/pigment