Full-Stack Developer

Position Description: The Full-Stack Developer builds and maintains Victor, the analytical platform behind nearly every finding Brandt VX delivers: the engine, the dashboards, and the data pipelines the analysts work in every day. This role owns the full development life cycle from conception through deployment, across both the front end and the back end. The work sits close to its users, since all three analyst roles are in the product daily and what they cannot do today becomes the backlog. Victor is built deliberately without frameworks, transpilers, or bundlers, so the ideal candidate is comfortable working directly against the platform and writing code meant to be read and maintained for years. Essential Responsibilities • Design client-side and server-side architecture • Build and maintain the Victor front end, including dashboards, reporting views, and mapping • Develop and maintain the PostgreSQL database, including schema, functions, views, and access control • Implement schema changes raised by the analytical team, and confirm the result with the Data Analyst before release • Build internal tooling that removes manual database work, including configuration interfaces for client setup • Write effective APIs • Create security and data protection settings, including multi-tenant access controls • Test software to ensure responsiveness and efficiency • Troubleshoot, debug, and upgrade software • Build features and applications with a responsive design • Write technical documentation • Work with the Business, Data, and Deployment Analysts to improve the product they use daily • Observe all company policies and procedures Additional Responsibilities • Cross training and assisting Business, Data, and Deployment Analyst positions • Minimal travel may be required • Perform other duties as assigned Minimum Knowledge, Skills, and Abilities • Demonstrate a high degree of professionalism to engender respect and build rapport as a knowledgeable and helpful resource both in and outside the company • Commit to maintain confidentiality and handle highly sensitive information with discretion • Perform detailed work accurately and within agreed upon deadlines • Proficient with HTML5, CSS3, ECMAScript, PHP, and SQL • Able to work without frameworks, transpilers, or bundlers, writing standards-based code directly against the platform • Knowledgeable of Microsoft Office Suite (Word, Excel, and PowerPoint) and Apple productivity applications (Pages, Numbers, and Keynote) • Hold relevant training certificates or equivalent professional experience • Make use of strong organizational, project management, and interpersonal skills • Communicate effectively, verbally and in writing • Prioritize and manage time effectively • Hold or acquire the Project Management Institute (PMI) Agile Certified Practitioner (PMI-ACP) certification within the first year of employment Preferred Knowledge, Skills, and Abilities • Experience with PostgreSQL, including functions, views, triggers, and row-level security; familiarity with Microsoft SQL Server • Experience with Sass and standards-based CSS architecture • Experience with charting or mapping libraries (e.g. Highcharts, Mapbox GL JS) • Familiarity with JSON-RPC or other structured HTTP API designs • Knowledge of multiple back-end languages (e.g. Python, Node.js) • Experience administrating Linux servers and packages (e.g. Apache) • Knowledgeable of 9-1-1 services (Police, Fire, EMS) • Possess 3+ years' experience as a Full-Stack Developer • Hold a degree in Information Technology or a related field Physical Demands • Sitting in front of a computer for extended periods of time • Occasionally stand, walk, reach with hands and arms, stoop, kneel, crouch, or crawl, and lift/ move 25 pounds. • Must be able to see objects in presence of glare or bright lighting (e.g., computer screen) Work Environment • Office is located in residential complex outside Boerne • Familial obligations may impact office environment • Must be able to work effectively without direct supervision The purpose of this job description is to communicate the general requirements, essential functions and duties of this position. It cannot capture all of the anticipated needs and demands, which may change over time as business needs dictate. Therefore, the Company reserves the right to change them at any time. All employees will perform any other related duties as assigned. The duties, mental functions, physical demands, and work environment factors described above are representative of those that must be met by and employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.