Tryfacta, Inc.
Business Intelligence Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Business Intelligence Analyst in Sacramento County, CA, on a contract basis for over 6 months. Key skills include SQL Server, Power BI, data integration, and process automation. Knowledge of sensitive data handling is required.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
October 1, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
Remote
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Sacramento County, CA
-
🧠 - Skills detailed
#Migration #Normalization #SQL (Structured Query Language) #Macros #Python #Security #Automation #Microsoft Access #Data Integration #Microsoft Power BI #SQL Server #Database Management #Power Automate #Compliance #BI (Business Intelligence) #Datasets #Process Automation #Project Management #TOAD (Tool for Oracle Application Developers) #Documentation #Scripting #Jira #Requirements Gathering
Role 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.
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.
