Technical Business Analyst

Ven Soft LLC; United States; On-site; USD 65,000 - 105,000; Full time

Job summary

Ven Soft LLC is seeking a Business Technology Analyst who can translate Excel data into robust SQL structures and compelling Tableau dashboards.

The role emphasizes end-to-end data modernization, from spreadsheet sources to automated ETL processes, relational databases, and insightful visualizations for business users.

Qualifications

• Experience converting Excel data into SQL databases.
• Proficient in SQL queries, joins, and optimization.
• Hands-on Tableau dashboard development and data visualization.

Responsibilities

• Transform raw Excel data into SQL-based structures and dashboards.
• Build ETL workflows from Excel inputs to relational databases.
• Create and optimize Tableau dashboards with calculations and filters.

Skills

ETL

SQL

Excel

BI Reporting

Tableau

Tools

Tableau

Excel

SQL Databases

Job description

Key Skills: ETL, SQL, Excel, BI Reporting, Tableau

Note: Preference to Permanent Residents of USA

Job Description:

We are seeking a Business Technology Analyst with strong hands‑on experience in transforming business data from Excel into SQL-based structures and Tableau dashboards. This role is ideal for a business‑focused professional who has previously managed end‑to‑end processes of converting raw spreadsheets into automated ETL workflows, relational databases, and insightful visualizations.

Required Skills & Experience:

• Proven experience in converting Excel data into SQL databases and Tableau dashboards.
• Convert Excel (.xlsx) documents into structured SQL tables.
• Strong knowledge of SQL (queries, joins, stored procedures, optimization).
• Hands‑on experience with Tableau (dashboard creation, calculated fields, parameters, filters).
• Familiarity with ETL concepts and tools (manual or automated).
• Ability to work independently as a business user with technical expertise.
• Strong analytical and problem‑solving skills with attention to detail.