Job Description

Position: Data & Business Intelligence Analyst

Location: Sacramento County, CA

Type: [Contract / Full-Time]

Work Mode: Onsite (with possible limited remote flexibility after Probation period)

Key Skills & Expertise:

Technical & Software Skills

• Database Management: SQL Server (relationships, indexes, keys, backend data operations), Microsoft Access migration/modernization.
• Data Integration: APIs, automated data feeds, cleaning/normalization of large datasets.
• Business Intelligence & Reporting: Power BI (dashboards, KPIs, automation), TIC (Toad Intelligence Central), Advanced Excel (PivotTables, Macros, DB connections).
• Forms & Data Collection Tools: Microsoft Forms, Power Apps, Adobe Forms, integration with SQL/Power BI.
• Process Automation: Power Automate or similar workflow automation tools.

Analytical & Project Skills

• Requirements gathering & functional documentation.
• Business process improvement & automation.
• Dashboard design, KPIs, metrics development.
• Troubleshooting data/system performance issues.

Communication & Collaboration Skills

• Work across multiple departments (Ops, IT, Finance, TSA, Vendors, etc.).
• Translate technical solutions into user-friendly explanations.
• Coordinate with consultants/vendors for implementations.

Security & Compliance

• Knowledge of sensitive/restricted data handling (airport/TSA-related).

Additional Desirable Skills

• Scripting (Python, PowerShell) for automation.
• Project management (Jira/ticketing tools).
• Change management & training end users.
• Strong attention to detail across multiple dashboards/reports.

Job Tags

Similar Jobs