IT Business Systems Analyst

Title: IT Business Systems Analyst

Location: Sacramento, CA, 95837

Technical & Software Skills: 

Database & Data Management
SQL Server* : Ability to manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling backend data operations. Microsoft Access*: Understand legacy Access databases, front-end forms, and back-end updates; ability to migrate Access data to SQL/modern platforms. Data Integration / APIs*: Experience connecting multiple systems via APIs, automated data feeds Data Cleaning & Transformation*: Handling large datasets, removing duplicates, normalizing data, integrating data across multiple systems.  
Business Intelligence & Reporting
Power BI*: Strong skills in building dashboards, KPIs, automated reports, filtering, slicers, drill, and using service accounts/gateways. TIC (Toad Intelligence Central)*:  Experience building scheduled and parameterized reports. Excel / Advanced Excel*: PivotTables, formulas, macros/VBA, connecting to external databases for reporting.  
Forms & Data Collection Tools
Microsoft Forms & Canvas / Power Apps*: Ability to design interactive forms, collect data from multiple users, handle attachments, and integrate with SQL/Power BI. Adobe Forms*: Optional experience, as replacement for Wufoo. Process Automation*: Experience using Power Automate or equivalent to automate data flows from forms to databases or dashboards.  
Analytical & Project Skills
Requirements Gathering & Documentation*: Ability to understand user needs, document workflows, create functional specifications. Business Process Improvement*: Identify inefficiencies in manual processes and design automated, streamlined solutions. Dashboard & Metrics Design*: Translate operational needs into actionable KPIs, metrics, and visualizations. Problem-Solving / Troubleshooting*: Debugging slow or failing systems, tracking down data issues across multiple sources.  
Communication & Collaboration Skills
Work closely with multiple departments: Operations, Accounting, Properties, TSA, Concessions.

Requirements

• Scripting / Automation*: Python, PowerShell, or similar for automating data processes.
  
• Project Management Experience*: Experience with Jira/other ticketing systems for tracking
  
• implementation tasks.
  
• Change Management / Training*: Ability to train staff on new systems and ensure adoption.
  
• Attention to Detail*: Managing multiple reports, dashboards, and manual processes without errors.
  
• CMMS, Airside, IT, and external vendors.
  
• Ability to explain technical solutions in non-technical language to end-users.
  
• Coordinate with external consultants and vendors for system implementation.
  
• Security & Compliance Awareness*
  
• Understanding of restricted or sensitive data handling (airport security, TSA data)
  

Additional Desirable Skills

• Scripting / Automation*: Python, PowerShell, or similar for automating data processes.
  
• Project Management Experience*: Experience with Jira/other ticketing systems for tracking implementation tasks.
  
• Change Management / Training*: Ability to train staff on new systems and ensure adoption.
  
• Attention to Detail*: Managing multiple reports, dashboards, and manual processes without errors.
  

Regards,