IT Business Systems Analyst

Job Title : IT Business Systems Analyst Location: Sacramento, CA. Contract : 12 months Job Description 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.

---

1. Security & Compliance Awareness*

• Understanding of restricted or sensitive data handling (airport security, TSA data)

---

1. 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.