Business Intelligence Analyst

US CITIZEN ONLY.

Position Summary

We are seeking an experienced Business Intelligence Analyst to design, develop, and support business intelligence solutions that improve data reporting, analysis, and decision-making.

This role will focus on building and maintaining data warehouses, developing reporting applications, and creating solutions that allow business teams to access and analyze large datasets.

The ideal candidate will have strong SQL skills, hands-on experience with SSRS, SSIS, and Alteryx, and a solid understanding of data warehousing, ETL processes, and database management systems.

Key Responsibilities

• Design, develop, implement, and maintain business intelligence data warehouses.

• Build and support BI reporting applications that meet business reporting and analytical needs.

• Develop solutions that allow users to access, analyze, and report on large datasets.

• Work closely with business stakeholders to gather requirements and translate them into technical specifications.

• Develop and maintain data marts, reports, dashboards, and other reporting solutions using multiple data sources.

• Write and optimize SQL queries to extract, manipulate, and analyze data.

• Support ETL processes to ensure accurate and reliable data integration.

• Document data systems, workflows, technical processes, and metadata.

• Identify opportunities to improve data quality, reporting efficiency, and overall BI capabilities.

• Troubleshoot reporting and data-related issues.

• Manage multiple priorities while meeting project deadlines.

• Collaborate with technical teams and business partners to deliver effective reporting solutions.

Required Qualifications

• Strong proficiency in SQL, including writing complex queries.

• Hands-on experience with SQL Server Reporting Services (SSRS).

• Experience with SQL Server Integration Services (SSIS).

• Working knowledge and experience with Alteryx.

• Strong understanding of data warehousing concepts and architecture.

• Experience with ETL (Extract, Transform, Load) processes.

• Knowledge of database management systems and Online Analytical Processing (OLAP).

• Experience translating business requirements into technical specifications.

• Proficiency in Microsoft Excel.

• Strong analytical, troubleshooting, and problem-solving skills.

• Excellent communication, organizational, and time-management skills.

• Ability to work independently and collaborate with cross-functional teams.

• Must be a U.S. Citizen.

• Must be willing and able to work onsite in Irvine, CA.

Preferred Qualifications

- Experience developing reports, scorecards, and dashboards using Power BI.