Data Visualization Consultant Jobs in California

Job Overview:

Pay Range: $58.50hr - $63.50hr

Requirement/Must Have:

• Strong hands-on expertise with Tableau Desktop, including LOD expressions, parameter actions, dashboard actions, and performance tuning.
• Strong hands-on expertise with Microsoft Power BI, including Power Query (M), DAX, data modeling (star schema, role-playing dimensions), and the Power BI Service.
• Advanced SQL proficiency, with demonstrated experience writing complex analytical queries on Snowflake (preferred).
• Solid understanding of dimensional modeling, ELT/ETL concepts, and modern data warehouse architecture.
• Ability to translate business questions into data models, metrics, and visualizations that are accurate, performant, and easy to interpret.
• Strong data visualization sensibility — knows when to use which chart type, how to design for the audience, and how to avoid common visualization pitfalls.
• Proficiency with version control (Git) and familiarity with collaborative development workflows.
• Excellent written and verbal communication skills, with the ability to work effectively across technical and non-technical audiences.

Responsibilities:

• Design, develop, and publish interactive reports and dashboards in Tableau and Power BI that meet business requirements for accuracy, performance, and usability.
• Build and optimize semantic data models, calculated fields, measures (DAX), and Tableau LOD expressions on top of the organization's Snowflake data warehouse.
• Author efficient SQL queries and views in Snowflake to support reporting needs, including the use of CTEs, window functions, and performance tuning techniques (clustering, query profile analysis, materialized views).
• Partner with data engineers and architects to validate the data model, define metric definitions, and ensure data lineage and quality across reporting layers.
• Gather and document requirements from business stakeholders, translating ambiguous needs into clear specifications, mockups, and delivered analytics solutions.
• Implement row-level security, workspace governance, and certified dataset patterns in Power BI; manage permissions, projects, and data sources in Tableau desktop.
• Establish and follow BI development best practices, including version control, code reviews, naming conventions, documentation, and CI/CD where applicable.
• Monitor dashboard performance and usage, proactively optimizing slow queries, redesigning inefficient visuals, and retiring unused content.
• Support self-service analytics by curating trusted datasets, providing enablement, and mentoring business users on BI tools.

Nice to Have:

• Experience with dbt for data modeling and transformation in Snowflake.
• Familiarity with data analysis, automation, or advanced analytics integration.
• Exceptional analytical skills and attention to detail, with a commitment to delivering high-quality reporting solutions.
• Knowledge of Snowflake-specific features such as Streams, Tasks, Dynamic Tables, Snowpark, and role-based access control.
• Background supporting analytics in semiconductor, manufacturing or supply chain environments.
• Experience working in an Agile/Scrum delivery environment and using tools such as Jira and Confluence.

Qualification And Education:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field — or equivalent practical experience.
• 5+ years of professional experience in Business Intelligence, data analytics, or data development roles.
• 3+ years of demonstrable production experience building and supporting reports/dashboards in both Tableau and Power BI.
• 2+ years of experience working with cloud data platforms; direct experience with Snowflake strongly preferred.
• Proven track record of delivering BI solutions to business stakeholders end-to-end, from requirements through production support.
• Tableau and/or Microsoft Power BI certifications (e.g., Tableau Desktop Specialist, Tableau Certified Data Analyst, PL-300) are a plus.
• SnowPro Core or other Snowflake certifications are a plus.