Talent Glide
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. 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, 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.
#J-18808-Ljbffr
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. 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, 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.
#J-18808-Ljbffr