Tech Stack
AWSDockerPostgresPythonSQLWordPress
About the role
- Maintain PostgreSQL performance, write and review queries, and triage database issues.
- Build Python scripts for validating, cleaning, and moving data on schedule.
- Stand up and maintain simple ELT pipelines using Airbyte, dbt, or similar tools.
- Develop internal tools and dashboards to reduce manual work and support the team.
- Translate business requirements into clear tickets and documentation for both engineers and non-technical stakeholders.
- Integrate AI helpers into workflows to save time and reduce errors.
- Improve reliability and cost-efficiency of the AWS footprint, using Git and Docker for repeatable processes.
- Respond to ad hoc data questions with quick analysis and summaries.
- Troubleshoot production issues across databases, scripts, and jobs.
- Write and maintain concise, up-to-date documentation.
- Facilitate communication between engineering, the Founder, and customers where technical context is needed.
Requirements
- Authorized to work in the United States
- High School Diploma or Equivalent with IT experience
- Available to work Full-time
- 1–3 years in a technical role (data engineering, data analytics, devops, or a similar role)
- Strong SQL with PostgreSQL, including indexing and query tuning.
- Proficiency in Python for automation and data manipulation.
- Experience with ELT tools such as Airbyte and dbt.
- Clear written and verbal communication skills.
- Ability to learn new tools quickly and work independently.
- Nice to Have: Familiarity with AWS, Git, and Docker.
- Nice to Have: Experience in startups or fast-paced environments.
- Nice to Have: Exposure to project management practices.