Tableau Consultant with SQL and Clickhouse

Title: Tableau Consultant with SQL and Clickhouse Location: Tampa, FL Duration: 12 Months Required Skill Sets for an Expert Tableau Resource An expert Tableau professional should possess a combination of technical, analytical, and business skills. Below is a summary of the key skill sets: Tableau Technical Expertise Advanced Tableau Desktop skills: Proficient in creating complex dashboards, visualizations, and interactive reports. Tableau Server/Online: Experience with publishing, sharing, and managing content on Tableau Server/Online. Data blending and joining: Ability to combine data from multiple sources within Tableau. Calculated fields: Advanced use of calculations, table calculations, and Level of Detail (LOD) expressions. Performance optimization: Techniques for improving dashboard performance and efficiency. Data Skills: · SQL proficiency, Data modeling, and Data connectivity. Analytical & Business Intelligence Skills: Data analysis, Storytelling, Requirements gathering. SQL Expert: · Advanced Query Writing, Data Manipulation, Database Design, and Complex Functions. Performance Tuning & Optimization: · Query Optimization, Database Maintenance, and Troubleshooting. Required Skill Sets for a ClickHouse Beginner ClickHouse is a high-performance columnar database management system often used for analytics and big data workloads. For someone starting with ClickHouse, the following skill sets are recommended: 1. Basic Database Concepts Understanding of RDBMS principles: Familiarity with tables, columns, rows, primary keys, and indexes. SQL Fundamentals: Ability to write basic SQL queries (SELECT, WHERE, GROUP BY, ORDER BY). 1. Getting Started with ClickHouse Installation & Setup: Ability to install ClickHouse on local or cloud environments, and perform initial configuration. ClickHouse Client Tools: Understanding how to use the ClickHouse client, web UI, or command line interface. 1. Data Operations Basic Table Management: Creating, modifying, and dropping tables. Data Ingestion: Loading data into ClickHouse from CSV, TSV, or other simple formats. Simple Queries: Running SELECT statements and filtering data. 1. ClickHouse-Specific Concepts Columnar Storage: Basic understanding of how columnar databases differ from row-based databases. MergeTree Engine: Familiarity with the default storage engine in ClickHouse and its basic configuration. 1. Performance Awareness Basic Indexing: Understanding of primary keys and partitioning in ClickHouse. Simple Performance Tuning: Awareness of how queries and table design can impact performance. 1. Integration Basics Connecting to BI Tools: Connecting ClickHouse to visualization tools (e.g., Tableau, Grafana) or scripting languages (Python, etc.). Data Export: Exporting query results to CSV or other formats. 1. Documentation & Community Using Official Docs: Ability to navigate and use the ClickHouse documentation. Community Resources: Knowing where to find help (forums, GitHub issues, etc.). Job Type: Contract Pay: $50.00 - $55.00 per hour Work Location: In person