Junior Business Systems Analyst: Automate & Optimize Ops

OPEN HOUSE TEXAS REALTY & INVESTMENTS LLC; Addison (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

OPEN HOUSE TEXAS REALTY & INVESTMENTS LLC is seeking a hands-on Junior Business Systems Analyst to bridge business operations and technology in Addison, TX. You will analyze workflows, write code (Python/GAS), and build automation tools to improve efficiency.

You’ll own small projects end-to-end, create clear SOPs, perform self-QA for data integrity, and routinely update stakeholders with progress and results.

Qualifications

• 1–3+ years in a technical or operational role (System Engineering, App Development, or tech-focused Business Support).
• Proficiency in Python or Google Apps Script (GAS) for automation.
• Ability to extract and manipulate data (BigQuery experience is a plus).
• Demonstrated ability to leverage AI tools (e.g., ChatGPT, Gemini) to accelerate scripting and problem-solving.
• Ability to dive into messy data or broken workflows and find solutions without needing constant supervision.

Responsibilities

• Act as the primary technical resource for all departments (Acquisition, Make Ready, Admin, etc.).
• Identify manual, repetitive tasks and independently design and build automation tools using Python or Google Apps Script (GAS) to improve efficiency.
• Proactive Reporting: Take full ownership of your projects by providing proactive status updates to the manager and stakeholders. You are expected to report progress and results before being asked.
• SOP Documentation: Ensure long-term consistency by creating and maintaining clear, step-by-step Standard Operating Procedures (SOPs) for every new process or tool developed.
• Data Integrity: Perform "Self-QA" on all data and scripts to ensure error-free execution and maintain a "Single Source of Truth" for company operations.

Skills

Python

Data extraction

Automations

Tools

Google Apps Script

BigQuery

Job description

OPEN HOUSE TEXAS REALTY & INVESTMENTS LLC is seeking a hands-on Junior Business Systems Analyst to bridge business operations and technology in Addison, TX. You will analyze workflows, write code (Python/GAS), and build automation tools to improve efficiency.

You’ll own small projects end-to-end, create clear SOPs, perform self-QA for data integrity, and routinely update stakeholders with progress and results.