Data Analyst - Local to Sacramento, CA - USC/GC - W2/1099

Title: IT Business Systems Analyst Location: Sacramento, CA, 95837 Type: On-site with up to 2 days remote possible after probationary period. Database & Data ManagementSQL 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 & ReportingPower 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 • : PivotTables, formulas, macros/VBA, connecting to external databases for reporting.Forms & Data Collection ToolsMicrosoft 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 SkillsRequirements 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 SkillsWork closely with multiple departments: Operations, Accounting, Properties, TSA, Concessions. 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. 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. Job Type: Contract Pay: $47.56 - $57.28 per hour Expected hours: 40 per week Work Location: In person