IT Business Systems Analyst
Listed on 2025-12-02
-
IT/Tech
Data Analyst, Data Engineer, Database Administrator, Business Systems/ Tech Analyst
Sacramento, United States | Posted on 10/03/2025
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:
Pivot Tables, 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.
- Scripting / Automation:
Python, Power Shell, or similar for automating data processes. - Project Management
Experience:
Experience with Jira/other ticketing systems for tracking - 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)
- Scripting / Automation:
Python, Power Shell, 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.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).