Data Analyst

Swbc Peo•Boerne, TX

About The Position

The Data Analyst owns the underlying data: what is in the database, whether it is sound, and what it can and cannot answer. The role pairs directly with the Business Analyst. The Business Analyst frames questions and interprets answers, while the Data Analyst locates the data, assesses whether it can support a question, writes queries, and is accountable for the completeness of the results. Deep knowledge of emergency services operations is useful but not expected; analytical interpretation sits with the Business and Deployment Analysts. The two roles are designed to work as a pair, and candidates strong in both areas may be considered for either role. The ideal candidate is fluent in SQL, learns unfamiliar schemas quickly, and is rigorous about data integrity. The role also configures client organizations and user access in the database, verifies configuration changes before results are released, and documents work so queries, transformations, and setups can be reproduced. Minimal travel may be required. The role includes cross-training and assisting Business and Deployment Analysts, along with other duties as assigned. The position involves extended computer use and occasional standing, walking, reaching, stooping, kneeling, crouching, crawling, and lifting or moving up to 25 pounds. The office is located in a residential complex outside Boerne. Familial obligations may affect the office environment, and the employee must be able to work effectively without direct supervision. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Requirements

Author SQL independently, including joins, aggregation, subqueries, and window functions.
Read a database schema and locate the data behind a plain-language request.
Assess whether a dataset is complete and internally consistent, and describe its limitations clearly.
Be highly detail oriented and able to identify anomalies and inconsistencies in large, complex datasets.
Exercise care when working in a live production database, including verifying scope before making a change.
Have strong Excel skills, including pivot tables and formula-based analysis.
Be proficient with Microsoft Office Suite (Word, Excel, and PowerPoint) and Apple productivity applications (Pages, Numbers, and Keynote).
Communicate effectively verbally and in writing.
Prioritize and manage time effectively.
Demonstrate professionalism and build rapport as a knowledgeable and helpful resource, both inside and outside the company.
Maintain confidentiality and handle highly sensitive information with discretion.
Hold relevant training certificates or equivalent professional experience.
Work effectively without direct supervision.

Nice To Haves

Experience with MSSQL and PostgreSQL, including CTEs, window functions, and query performance.
Experience configuring or administering a multi-tenant application database.
Familiarity with CAD systems and AVL/GPS data.
Exposure to ETL pipeline development or data warehouse design.
Experience with GIS or spatial data tools such as PostGIS, QGIS, or ArcGIS.
Familiarity with EMS, fire, or 911 communications operations.
Two or more years of experience in data analysis, reporting, or a related quantitative role.
A degree in data science, statistics, mathematics, computer science, or a related field.
Deep knowledge of emergency services operations.

Responsibilities

Write SQL to retrieve data requested by the analytical team.
Extract, join, and shape datasets into the form requested.
Build and maintain recurring data pulls that feed standing reports.
Coordinate with client IT staff and CAD vendors to establish data feeds; ingest and transform CAD, AVL/GPS, and status data into structured form.
Assess data quality and integrity, including record presence, field population, join resolution, time-series gaps, and timestamp order.
Report missing, incomplete, or unreliable data and explain implications for dependent analyses.
Identify implausible values and statistical outliers, and refer them to the Business Analyst to determine whether they are errors, real events, or local practice.
Understand what the database structure can and cannot express, and raise early notice when a question cannot be answered with the data as modeled.
Raise structural gaps and needed schema changes to the developer, then validate delivered changes.
Configure new and existing client organizations in the database, including standards, determinant-to-classification mapping, regions, and unit and deployment assignment, using Business Analyst specifications.
Provision and maintain client user accounts and access.
Verify that configuration changes produce correct output before releasing results.
Document queries, transformations, and configurations so pulls and setups can be reproduced.
Observe all company policies and procedures.
Cross-train and assist Business and Deployment Analysts.
Perform other duties as assigned.
Travel minimally when required.