BI Analyst - Data Warehousing, SQL & Dashboards

Belcan; Irvine (CA); On-site; USD 95,000 - 120,000; Full time

Job summary

Belcan in Irvine, CA is seeking a Business Intelligence Analyst to support complex BI solutions and data warehousing initiatives. You will collaborate with partners to define data requirements, translate them into data marts, reports, and dashboards drawn from multiple data sources.

Key skills include SQL, SSRS/SSIS, Alteryx, and Power BI; Excel proficiency is a plus. The role emphasizes analytical thinking, problem solving, and teamwork in a fast-paced environment.

Qualifications

• Proficiency writing SQL.
• Technical knowledge of SQL queries, SSRS, SSIS, Alteryx.
• Experience building Reports, Scorecards and Dashboards w/ Power BI.
• Proficient in MS Excel.
• Strong project/time management and teamwork skills.

Responsibilities

• Design and implement BI Data Warehouse.
• Design and implement BI reporting applications.
• Design, implement, and support a platform providing ad-hoc access to large datasets.
• Translate business requirements into specification that will be used to implement required data marts, reports, and dashboards, created from potentially multiple data source.
• Documents data systems, processes, and technical Meta data.
• Strong analytical, problem solving, planning and prioritization skills.

Skills

SQL

Tools

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Alteryx

Power BI

MS Excel

Job description

Belcan in Irvine, CA is seeking a Business Intelligence Analyst to support complex BI solutions and data warehousing initiatives. You will collaborate with partners to define data requirements, translate them into data marts, reports, and dashboards drawn from multiple data sources.

Key skills include SQL, SSRS/SSIS, Alteryx, and Power BI; Excel proficiency is a plus. The role emphasizes analytical thinking, problem solving, and teamwork in a fast-paced environment.