Home
Jobs
Tryfacta, Inc.
Business Intelligence Analyst

Business Intelligence Analyst

On site

Sacramento county, United states

Freelance

30-09-2025

Share this job:

Score my CV

Skills

Communication Python PowerShell Jira SQL Change Management Data collection Attention to detail Training Database Management power bi SQL Server Process Improvement Project Management Power Automate Microsoft Forms

Job Specifications

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.

About the Company

Tryfacta Inc. is a dynamic, woman-owned small business at the forefront of technology and digital transformation. Founded in 1996, Tryfacta has evolved from a staffing industry leader to a comprehensive IT consulting powerhouse, focusing on Healthcare Staffing and Operations, Cloud migrations, and other IT and Non-IT Professional Services. As an SBA 8(a) and Women-Owned Small Business (WOSB), Tryfacta brings diversity and innovation to the federal contracting space. The company's expertise spans advanced consulting, cybersec... Know more