BI Data Analyst: SQL-Driven Insights & Dashboards

Fairweather, LLC; Fremont (CA); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Job summary

SYNNEX Corporation in Fremont, CA is seeking a Business Intelligence Data Analyst to own data extraction, transformation, and validation from multiple sources. You will write and optimize SQL queries to power dashboards, reports, and ad hoc analysis, and design scalable data models to support business domains.

Collaborating with business and technical teams, you will identify data requirements, validate data quality, and build automated reporting pipelines to improve efficiency and reliability.

Qualifications

• BA/BS degree or equivalent practical experience.
• Strong SQL skills with joins, window functions, optimization.
• Experience with large relational datasets and analytics data modeling.
• Excel proficiency and Power BI experience.
• Strong analytical and problem-solving abilities translating business needs into data solutions.
• Familiarity with data warehousing concepts (Databricks/Hive/Snowflake).
• Experience with MS Access is a plus.

Responsibilities

• Own the extraction, transformation, and validation of data from multiple sources to support business analysis and reporting
• Write, optimize, and maintain complex SQL queries to power dashboards, reporting, and ad hoc analysis
• Design and build scalable datasets and data models to support business domain.
• Partner with business and technical teams to define data requirements and translate them into structured data solutions
• Identify data quality issues, implement validation checks, and drive improvements in data integrity and reliability
• Develop automated reporting and data pipelines to improve efficiency and reduce manual processes
• Analyze large datasets to identify trends, patterns, and key business drivers, and translate findings into actionable insights
• Create and maintain documentation for data models, transformations, and reporting logic

Skills

SQL

Data modeling

Excel

Power BI

Analytical skills

Data warehousing

MS Access

Education

BA/BS degree

Tools

Databricks

Hive

Snowflake

Microsoft Access

Job description

SYNNEX Corporation in Fremont, CA is seeking a Business Intelligence Data Analyst to own data extraction, transformation, and validation from multiple sources. You will write and optimize SQL queries to power dashboards, reports, and ad hoc analysis, and design scalable data models to support business domains.

Collaborating with business and technical teams, you will identify data requirements, validate data quality, and build automated reporting pipelines to improve efficiency and reliability.