Software Developer - Data and Automation
Job Description
StraightUp Solar is seeking a Software Developer, Data and Automation to keep mission-critical data pipelines, workflow automations, and custom software running. This hybrid role in St. Louis, Missouri supports integrations and AI-assisted workflows, with the expectation that you are the team’s primary Python and pipeline development resource.
Working on the Strategic Development team alongside the VP (team lead and product manager) and a process improvement specialist/business analyst, you will monitor scheduled systems, troubleshoot failures, and improve performance across code, no-code tools, and low-code workflows.
Role overview
- Serve as the Strategic Development team’s only Python and pipeline developer.
- Work closely with the VP, Strategic Development, providing system health updates and plain-language reporting on issues and risks.
- Execute primary duties during normal Mon-Fri business hours, with rare after-hours needs for upgrades or critical repairs.
- Follow production change approval steps agreed with the team lead, supporting collaboration on higher-stakes updates.
Responsibilities
- Monitor scheduled data pipelines and automations, diagnose failures, fix issues using written procedures, and escalate when a problem is outside your authority.
- Troubleshoot and repair existing software including Python scripts, SQL views and data models, Google Apps Script and JavaScript tools, and Podio workflows (including PHP calculation fields).
- Perform scheduled maintenance to prevent disruption, including expiring credentials and API keys, third-party API changes and deprecations, and software upgrades.
- Support recurring data pulls and recovery procedures, including several that run as Claude skills.
- Audit and modify custom workflows (no-code, low-code, and code) to improve performance, usability, or add functionality.
- Build integrations, data pipelines, and automations connecting CRM, accounting, payroll, field tools, and reporting.
- Write, test, and maintain Claude skills and AI-assisted workflows, including checking AI-generated work before it reaches production.
- Maintain code in version control and follow the team’s branching and review conventions.
- Meet with end users to understand requirements, ask detailed questions, and produce clear written proposals aligned with client and internal needs.
- Help design features with users, write test plans, and train users on released changes.
- Write and update documentation, including written procedures and known-issues guides.
- Participate in team meetings and the backlog and sprint process.
Requirements
- Python and SQL capability: read unfamiliar code, reproduce bugs, and fix them.
- APIs, JSON, JavaScript, and Git working ability.
- Ability to use an AI coding assistant such as Claude with strong judgment, including verifying output and knowing when not to trust it.
- Proven troubleshooting approach: form hypotheses, isolate causes, and document findings.
- Clear communication in writing and speech, including explaining technical failures to non-technical coworkers and writing instructions others can follow.
- Strong organization and time management, including managing urgent breakages while keeping planned work on track.
- Comfort working independently, asking for help early and escalating appropriately.
- Proficiency with Google Workspace.
Technologies
- Python, SQL, Google Apps Script, JavaScript, Podio, PHP, Google Workspace, Git, Claude
- APIs, JSON, Google Cloud, Cloud Run, Cloud Composer, Airflow, BigQuery, PostgreSQL, dbt, Globiflow
- Power BI, Looker Studio
Benefits
- Salary: $90,000 - $105,000 per year
- Remote work flexibility
- $480/month medical insurance stipend (Anthem Health Insurance)
- Company paid life insurance: $50,000
- Wellness Program with Headspace app stipend
- 401k program
- Paid Time Off, holidays, bereavement, paid volunteer time
- Dental, Vision, Short and Long Term Disability, Accident and Critical Illness, Life and Legal (additional insurance options)
- Parental leave
- Employee discount
- Health insurance, health savings account, life insurance, vision insurance
- Employee assistance program
- Flexible schedule
- Retirement plan
Preferred skills
- Experience with Google Cloud: Cloud Run, Cloud Composer or Airflow, BigQuery
- Experience with PostgreSQL or dbt
- Experience with Podio, Podio Workflow Automation (Globiflow), or PHP
- Experience with Power BI or Looker Studio
- Experience with Google Apps Script or other low-code and no-code platforms
- Experience writing Claude skills or other agentic workflows
- Experience supporting non-technical users
- Curiosity and creativity
Working environment and logistics
- Hybrid remote location in St. Louis, MO 63132.
- Third member of the Strategic Development team, alongside the VP (team lead and product manager) and a process improvement specialist/business analyst.
Physical requirements
- Prolonged periods sitting at a desk and working on a computer.
- Ability to lift up to 15 pounds at times.
Company and culture
StraightUp Solar is a values-based B-Corp company committed to a cleaner, safer, and more secure energy future. The company is an Equal Opportunity Employer and encourages applications from veterans, women, persons of color, and members of the LGBTQ community. Core values include Community First, Lead the Solar Tribe, Educate the Solar Lesson, Advocate Always, Respect Each Other and the Environment, and Excellence In All We Do.
Minimum qualifications
- 3 years of minimum experience
- Bachelor’s degree in computer science or a related field (or equivalent hands-on experience)