Automation Engineer

Tremco CPG Inc.; Clearwater (FL); On-site; USD 100,000 - 160,000; Full time

Job summary

Tremco CPG Inc. seeks an Automation Engineer to design and build company-owned internal software, data pipelines, and integrations that replace Excel as the operational backbone.

The role involves translating business needs into clear functional specifications and selecting tools and architectures to deliver scalable solutions. You will develop robust, efficient systems with validation, testing, and end-to-end delivery, shipping improvements quickly and iterating based on feedback.

Qualifications

• Proficiency in at least one backend language (Python, TS/Node.js, or C#/.NET).
• Ability to build automation/services that handle data and API integrations.
• Strong SQL and relational fundamentals (design, joins, aggregations).
• Experience building and consuming REST APIs and working in production environments.
• Solid software engineering fundamentals: data structures, OOP, readable code, debugging, and code review practices.

Responsibilities

• Design and build internal software, data pipelines, and integrations to replace Excel as an operational backbone.
• Translate business needs into clear functional and technical specs.
• Select tools/architectures for scalable, maintainable solutions.
• Develop robust, reliable systems with validation and testing.
• Drive delivery, shipping improvements and iterating on feedback.
• Replace manual workflows with production software.

Skills

Python

TypeScript/Node.js

C#/.NET

SQL

REST APIs

Git

Education

Computer Science/Engineering degree

Tools

Docker

Airflow

Dagster

Prefect

FastAPI

PostgreSQL

Job description

Job Description

• D esign and build company-owned internal software, data pipelines, and integrations to replace Excel as an operational backbone
• Translate ambiguous business needs into clear functional and technical specifications
• Select appropriate tools, technologies, and architectures to deliver scalable and maintainable solutions
• Develop robust, efficient, and reliable systems, ensuring accuracy and correctness through validation and testing
• Drive execution and delivery, shipping improvements quickly and iterating based on feedback and results
• Replace manual workflows with production software

GENERAL PURPOSE OF THE JOB:

The Automation Engineer leads end-to-end project delivery, including requirements gathering, system architecture, prototyping, production deployment, and ongoing iteration.

Essential Duties And Responsibilities

• D esign and build company-owned internal software, data pipelines, and integrations to replace Excel as an operational backbone
• Translate ambiguous business needs into clear functional and technical specifications
• Select appropriate tools, technologies, and architectures to deliver scalable and maintainable solutions
• Develop robust, efficient, and reliable systems, ensuring accuracy and correctness through validation and testing
• Drive execution and delivery, shipping improvements quickly and iterating based on feedback and results
• Replace manual workflows with production software

• Translate informal processes into clear data models, services, and user-facing tools.
• Build internal web apps, APIs, and automation services that users adopt.
  • Build data pipelines and system integrations
• Ingest data from files, forms, SaaS tools, and internal databases.
• Implement ETL/ELT pipelines with validation, lineage, and monitoring.
• Integrate systems via REST APIs, webhooks, queues, and scheduled jobs.
  • Create durable data foundations
• Design relational schemas, enforce constraints, manage migrations.
• Build “single source of truth” datasets for analytics + operations.
  • Operationalize ML
• Use pre-trained models (LLMs / vision / classical ML) for classification, extraction, routing , forecasting, etc.
• When needed: fine-tune/train on company data, evaluate properly, deploy with monitoring.

EDUCATION:

Computer Science, Computer Engineering, Data Science, AI/ML

Experience

• Proficiency in at least one backend language: e.g. Python, TypeScript/Node.js, or C#/.NET
• Ability to build automation/services that handle data, integrate APIs, and run reliably in production.
• Strong SQL and relational fundamentals (schema design basics, joins/aggregations, constraints, query debugging; Postgres/MySQL/SQL Server).
• Ability to build and consume REST APIs (HTTP basics, auth patterns, pagination, error handling).
• Solid software engineering fundamentals:
• data structures + OOP
• readable, maintainable code
• debugging and refactoring
• Git workflow experience (branches, pull requests, code review habits).
• Clear technical communication: can write clean documentation

Other Skills And Abilities

• Framework experience: FastAPI / Flask / Django, ASP.NET Core, NestJS / Express
• Data pipeline orchestration tooling: Airflow / Dagster / Prefect
• Docker experience and basic CI/CD (GitHub Actions, Azure DevOps, or similar)
• Cloud exposure (AWS / Azure / GCP): managed databases, object storage, message queues
• Building SaaS integrations using REST APIs / webhooks

The salary range for applicants in this position generally ranges between $100,000 and $160,000. This range is an estimate, based on potential employee qualifications, operations, needs, and other considerations permitted by law.

Tremco offers a variety of benefits to its employees, including but not limited to: health insurance, paid time off, 401(k) with company match, Company Pension Plan, and continuing education.

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.