Business Intelligence Consultant

Belcan; Irvine (CA); In loco; USD 95.000 - 120.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

SQL

Strumenti

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Alteryx

Power BI

MS Excel

Descrizione del lavoro

Job Title : Business Intelligence Analyst

Location : Irvine, CA 92618

Duration : 12+ Months

SUMMARY:

The Business Intelligence Analyst is responsible for supporting complex business intelligence analytical solutions utilized to support the business analytical and reporting needs. This individual will use Data Warehousing concepts to improve Client's MFCD data capabilities. Collaborate with business partners and team members to define data requirements and reporting specifications.

ESSENTIAL FUNCTIONS:

Consistently exhibits behaviour and communication skills that demonstrate commitment to superior customer service, including quality, care, and concern with each internal and external customer. 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.

JOB REQUIREMENTS:

Proficiency writing SQL

Technical knowledge of SQL queries, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Alteryx. Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

Experience building Reports, Scorecards and Dashboards w/ Power BI a plus.

Good project/time management and teamwork skills.

Proficient in the use of MS Excel

Belcan is an equal opportunity employer. Your application and candidacy will not be considered based on race, colour, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.