Data Analyst

Job Description

Job Description

The Data Analyst owns the data itself: what is in the database, whether it is sound, and what it can and cannot answer. This role pairs directly with the Business Analyst. Where the Business Analyst frames the question and interprets the answer, the Data Analyst locates the data, judges whether it will support the question, writes the query, and stands behind the completeness of what comes back. Deep knowledge of emergency services operations is useful but not expected, and analytical interpretation sits with the Business and Deployment Analysts. The two roles are designed to work as a pair, and a candidate strong in both directions will be considered for either. The ideal candidate is fluent in SQL, quick to learn an unfamiliar  schema, and rigorous about data integrity.

Essential Responsibilities:

• Write SQL to retrieve the data requested by the analytical team Extract, join, and shape datasets into the form the requester needs Build and maintain recurring data pulls that feed standing reports
• Coordinate with client IT staff and CAD vendors to establish new data feeds, and ingest and transform CAD, AVL/GPS, and status data into structured form
• Own the assessment of data quality and integrity: whether records are present, fields are
• populated, joins resolve, time series are free of gaps, and timestamps are ordered
• Report what is missing, incomplete, or unreliable, and what that means for the analyses depending on it
• Identify implausible values and statistical outliers and refer them to the Business Analyst for a determination as to whether they represent errors, real events, or local practice
• Know what the database structure can and cannot express, and say early when a question cannot be answered with the data as modeled
• Raise structural gaps and needed schema changes to the developer, and validate the result once delivered
• Configure new and existing client organizations in the database, including standards, determinant-to-classification mapping, regions, and unit and deployment assignment, working from specifications provided by the Business Analyst
• Provision and maintain client user accounts and access
• Verify that configuration changes produce correct output before any result is released Document queries, transformations, and configuration so that any pull or setup can be reproduced
• Observe all company policies and procedures

Additional Responsibilities:

• Cross training and assisting Business and Deployment Analyst positions 
• Minimal travel may be required
• Perform other duties as assigned

Minimal 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
• Author SQL independently, including joins, aggregation, subqueries, and window functions Able to read a database schema and locate the data behind a plain-language request
• Able to assess whether a dataset is complete and internally consistent, and to describe its limitations plainly
• Highly detail oriented, with the ability to identify anomalies and inconsistencies within large, complex datasets
• Exercise care when working in a live production database, including verifying scope before making a change
• Strong Excel skills, including pivot tables and formula-based analysis
• 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
• Hold relevant training certificates or equivalent professional experience

Preferred Knowledge, Skills, and Abilities:

• 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 (e.g., PostGIS, QGIS, ArcGIS) Familiarity with EMS, fire, or 911 communications operations
• Possess 2+ years' experience in data analysis, reporting, or a related quantitative role
• Hold a degree in data science, statistics, mathematics, computer science, 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.