Sql programmer Jobs in Lubbock, TX

Major/Essential Functions

• Maintain and interpret analytics for Teaching, Research, and Office space.
• Develop or identifies recommendations to support analytic innovation.
• Conduct GAPS analyses to identify space deficits, surpluses, and strategic opportunities.
• Produce portfolio-level dashboards and deep-dive analyses for colleges, departments, and leadership.

• Develop and evaluate scenario models for new planning questions (e.g., hybrid work impacts, research growth/performance, course delivery changes, teaching format shifts).
• Build sensitivity analyses, program-specific models, and multi-option evaluation frameworks.

• Prepare analytic packets, dashboards, and decision support materials for the Space Advisory Committee (SAC).
• Support the Teaching Space Sub- Committee (TSSC) with long-term teaching space initiatives, classroom utilization, and teaching-space metrics.
• Provide research space analytics, PI/lab metrics, and relevant benchmarking to the Research Space Sub- Committee (RSSC).

• Maintain a comprehensive space metrics framework for teaching, research, and administrative space.
• Quality control utilization, allocation ratios, and surplus/deficit indicators.
• Ensure consistent metric definitions, data lineage, and annual review of standards.

• Maintain the institution’s Space Projection Model that forecasts 1/3/5-year space needs and supported by t the THECB space drivers.
• Monitor data relationships in enrollment, staffing, research funding, instructional demand, and facility lifecycle data.
• Conduct variance analyses and update assumptions quarterly.

• Analyze classroom (110) and Raider Room scheduling, utilization, percent fill, time distribution metrics, and pedagogical fit.
• Identify bottlenecks, peak-time pressure, room-type imbalances, and right-sizing requirements.
• Collaborate with the Registrar and TSSC on scheduling policy/optimization recommendations.
• Support the Space Usage Efficiency score through collaborative efforts both internal and external.

• Develop, maintain, and publish certified datasets for space planning in Fabric.
• Build reports, semantic models, and reusable analytics layers in Fabric and Power BI.
• Ensure proper data security, refresh schedules, and user access.

• Perform ongoing QC of institutional data warehouse space-related tables/views: Internal Space Model, THECB, BANNER import data related to space drivers, and Space Usage Efficiency.
• Run validation logic (schema checks, business-rule violations, missing data scans) and coordinate corrections with business-need-to-know.

• Write SQL queries, develop ETL logic, and maintain integrations supporting the space projection model, metrics framework, dashboards, and committee datasets.
• Support integration across Registrar, HR, Research, Facilities, and Scheduling systems.
• Document SQL assets, schema relationships, and business rules.

Preferred Qualifications

• 3–5+ years of experience in space planning, campus planning, analytics, or related roles
• Proficiency in SQL, Power BI/Fabric, data modeling, and Excel
• Strong analytic, visualization, and communication skills
• Experience with higher-ed space metrics and course-scheduling datasets
• Previous support of committee-based governance
• Familiarity with CAD/BIM data structures (read-only accepted)
• Familiarity with data architecture structures (read-only accepted)
• Experience with Texas Higher Education Coordinating Board reporting or metrics

Knowledge, Skills, and Abilities

• Analytical rigor and quantitative reasoning
• Systems thinking and problem decomposition
• Clear communication and executive ready storytelling
• Stakeholder diplomacy and facilitation
• High attention to detail and data integrity
• Ability to translate metrics into actionable recommendations