Data Automation Engineer

Company Overview

Not specified.

Job Summary

We are seeking a Data Automation Engineer to join our growing team. This role is ideal for a self-starter who thrives in a collaborative environment and is passionate about automation, scripting, and data operations. You will be responsible for developing and maintaining automation scripts, auditing database log tables, researching and developing new data pipeline solutions, and ensuring data consistency and reliability across systems.

Responsibilities

• Automation & Scripting: Design, write, and maintain Bash and Python scripts to automate data workflows and operational processes. Build robust and reusable automation frameworks to reduce manual effort and streamline deployments.
• Database & Audit Table Management: Monitor and manage database audit/log tables for integrity, compliance, and traceability. Implement logging mechanisms for data pipeline transparency and error tracking.
• SQL Development & Optimization: Write and optimize complex SQL queries for data extraction, transformation, and reporting. Perform database health checks and troubleshoot performance issues.
• Data Pipeline Research & Development: Conduct research and proof-of-concepts (PoCs) for new data pipeline technologies and frameworks. Evaluate and integrate new tools or platforms into existing workflows based on team needs.
• Collaboration & Support: Work closely with Data Engineers, Analysts, and DevOps teams to support data delivery and infrastructure. Participate in code reviews, stand-ups, and sprint planning to ensure quality and velocity.
• Fast Turnaround & Problem Solving: Own end-to-end task execution with minimal supervision. Resolve data issues quickly, often under tight deadlines, while maintaining high quality.

Qualifications

• Strong proficiency in Bash scripting and Python for automation.
• Solid SQL skills, with the ability to write and debug complex queries.
• Experience managing and auditing database log tables, history tables, or change data capture (CDC).
• Exposure to modern data pipeline tools such as Airflow, DBT, or custom ETL jobs is a plus.
• Familiarity with Linux environments, version control (e.g., Git), and CI/CD workflows.
• Strong analytical mindset and the ability to conduct independent research.
• Excellent communication skills and a collaborative team player attitude.
• Demonstrated ability to manage multiple priorities and deliver fast, reliable results.
• Experience with cloud platforms like AWS, Google Cloud Platform (GCP), or Microsoft Azure.

Preferred Skills

• Knowledge in SQL, PLSQL, BASH, ELT, DBT, Airflow, Python, and database monitoring.

Experience

Not specified, but relevant experience in data automation and database management is expected.

Environment

Not specified regarding the work setting, location, or any physical/environmental conditions.

Salary

Not specified.

Growth Opportunities

Not specified.

Benefits

Not specified.