Overview
Skills
Job Details
Job Title - IT Business Systems Analyst
Duration - 11-03-2025 to 05-01-2026
Location - Sacramento, CA (Remote Work) (Local profile only )
Visa -EAD,GC-EAD,TN
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-
through, 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
*2. 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.
3. Communication & Collaboration Skills*
* Work closely with multiple departments: Operations, Accounting, Properties, TSA, Concessions,
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.