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,