Overview
On Site
0.0
Full Time
Skills
SQL Server
Access databases
Excel
PivotTables
formulas
Job Details
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.
----
4. Security & Compliance Awareness*
* Understanding of restricted or sensitive data handling (airport security, TSA data)
----
5. 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.
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.
----
4. Security & Compliance Awareness*
* Understanding of restricted or sensitive data handling (airport security, TSA data)
----
5. 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.