> Markdown version of [/jobs/ext/4732259-junior-data-automation-engineer](https://www.wearedevelopers.com/jobs/ext/4732259-junior-data-automation-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Junior Data & Automation Engineer - **Company:** PIGMENT, LLC - **Location:** Paris, TX, United States - **Experience:** Starter - **Contract:** Internship / Graduate position - **Skills:** Sql Data Warehouse, Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Automation of Tests, BigQuery, Business Systems, Software as a Service, Cloud Computing, Code Review, Databases, Continuous Integration, Data Architecture, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, Database Queries, Dimensional Modeling, Document-Oriented Databases, Human Resources Information System (HRIS), Github, Python (Programming Language), Netsuite, Open Source Technology, Raw Data, Salesforce.Com, SQL Databases, Systems Integration, Unstructured Data, Google Cloud, Data Ingestion, Delivery Pipeline, Large Language Models, Git, Google Cloud Functions, Terraform, Software Version Control, Data Pipelines - **Published:** November 15, 2026 - **Apply:** https://www.careerbuilder.com/job-details/junior-data-automation-engineer-paris-tx--0b83ac7d-843f-4409-94e8-0a4561129afb ## About the Role Automation Engineering, Artificial Intelligence (AI), Business Plan, Finance, Artificial Intelligence (AI) Agents, Strategic Planning, Business Performance Management, Software as a Service (SaaS), Financial Planning, Funding, The ideal candidate will possess most or all of the following qualifications. Hands-on experience through personal projects (share your GitHub account!), particularly contributions to open source initiatives, will be valued equally to professional and academic experience for this role. * Up to 3 years of relevant experience in data engineering, including apprenticeships, internships, and/or demonstrable personal projects * Strong SQL skills and understanding of data modeling concepts (e.g. layered or dimensional models) * Solid coding skills in Python * Understanding of ELT/ETL patterns, pipeline design, and data quality testing * Knowledge of version control systems (Git) and CI/CD concepts * Practical experience with a public cloud provider and a cloud data warehouse * Attention to detail and analytical problem-solving skills, with the ability to identify edge cases * Good understanding of AI and LLM principles, along with practical use of AI tools in your work * Excellent communication skills in both French and English, written and verbal Soft skills * Problem-solving mindset with critical thinking about business processes * Strong communication abilities - translating technical concepts to non-technical audiences and active listening skills for accurately capturing business requirements * A natural curiosity, eagerness to learn, and comfort asking questions early rather than staying blocked are an absolute must * Bonus points: Basic project management capabilities - tracking tasks, managing timelines, and reporting progress Nice to have * Hands-on experience with dbt, Airflow, or Terraform * Exposure to ingestion and reverse ETL tools * Hands-on experience building LLM-powered pipelines or applications ## Description As a Junior Data and Automations Engineer, you will contribute to the continued development of Pigment's data platform: ingestion pipelines, dbt models, orchestration, data quality, and the underlying cloud infrastructure. You will also build and maintain the data pipelines, automations, and AI projects that support our G&A (Finance, People, IT) and GTM (Sales, Customer Success, Partnerships) teams., You will work closely with senior engineers, starting with well-scoped tasks and progressively taking ownership of small projects end to end, from requirements gathering to production monitoring. This role involves collaborating with a wide range of internal stakeholders and requires excellent communication skills in English (primarily) and French, verbal and written. Tech environment Our core stack relies on Google Cloud Platform, maintained with Terraform, with components including BigQuery, Cloud Run, and Cloud Composer (Airflow), as well as dbt, Fivetran, Hightouch, Elementary for data observability, and Python for integrations and automations. Our pipelines connect business systems such as Salesforce, NetSuite, our HRIS, Gong, or Slack, and feed Pigment applications used by our own business teams. We also build LLM-powered pipelines and use AI tools in our daily engineering work. You will have the opportunity to learn and grow your skills across these technologies while making a meaningful impact on Pigment's operational efficiency. Key Responsibilities Under the supervision of the Data & Automations team's more senior members, you will participate in addressing the following topics. Data Platform & Infrastructure: * Develop and maintain ingestion pipelines from APIs, databases, and SaaS tools, using Fivetran, Airflow, and Python * Build and maintain dbt models that turn raw data into clean, documented, and tested datasets * Contribute to the evolution of our orchestration, CI/CD, and infrastructure-as-code setup * Help improve data quality, observability, and alerting across the platform G&A and GTM Data Pipelines & Automations: * Build pipelines and integrations that sync data between business systems (CRM, ERP, HRIS) through our data warehouse, including reverse ETL with Hightouch * Develop Python-based automations that remove manual work for teams such as Finance, People, IT, and Customer Success * Prepare reliable datasets for reporting and for the Pigment applications used by business teams AI Projects: * Contribute to AI-powered solutions, such as LLM pipelines that extract, classify, and enrich unstructured data (call transcripts, messages, tickets) * Build the data foundations these projects rely on: AI-ready datasets, usage and observability data, evaluation data * Apply data architecture principles that make our data reliable, well-documented, and safely accessible for AI use cases (context, retrieval, access scoping) Monitoring & Support: * Monitor pipelines and automations, troubleshoot incidents, and fix root causes * Document data models, pipelines, and processes for both technical and business readers Collaboration & Learning: * Work with stakeholders - as diverse as Finance, People, Sales, and Product - to understand requirements and translate them into data solutions * Participate in code reviews and knowledge sharing sessions * Continuously expand your knowledge of data engineering, automation, and AI best practices What you'll do Under the supervision of the Business Automation team's more senior members, you will participate in addressing the following topics. Automation Development: * Develop and maintain Python-based automations and solutions to streamline enterprise processes * Implement integrations between various systems and applications using APIs and other connection methods * Assist in maintaining CI/CD pipelines for automation projects Data Integration & Transformation: * Support the implementation of data pipelines that integrate data from various sources, including APIs, external databases, and third-party services * Assist in transforming raw data into clean and ready-to-use models using SQL and dbt * Collaborate on data quality monitoring and improvement initiatives Monitoring and Support: * Help implement monitoring for automation workflows and data pipelines * Troubleshoot and resolve issues with existing automation solutions * Assist in documentation of systems, processes, and workflows Collaboration & Learning: * Work collaboratively with team members and stakeholders - as diverse as HR, Sales and Product Engineering - to understand requirements and implement effective solutions * Continuously expand knowledge of data engineering and automation best practices * Participate in code reviews and knowledge sharing sessions Who you are * Technical skills