Business Intelligence Analyst

Business Intelligence Analyst

Location: Trenton United States

Job Description:

Req number:

R6398

Employment type:

Full time

Worksite flexibility:

Hybrid

Who we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

The ideal Business Intelligence Analyst will conduct data extraction via SQL, App Studio, and WebFocus as well as prepare and document data requirements and conduct data validation for the automation of data extractions to be used in analytics.

Job Description

We are seeking a highly skilled and experienced Business Intelligence Analyst to join our IT team. This position will be full-time, hybrid, and is a contract position.

What You'll Do

• Collaborate with Research Analysts and internal teams to identify and address data needs for analytics

• Extract, analyze, and join data from various systems using SQL, App Studio, and WebFocus

• Conduct risk assessments, business impact analysis, and document technical findings

• Prepare data requirements, transformation rules, and design new data warehouse structures

• Automate data extraction processes and validate data accuracy for analytics

• Create data flow diagrams and perform data profiling to identify and resolve data quality issues

• Analyze BI tool code (e.g., WebFocus, Tableau) to ensure accurate data usage

• Develop training materials and support Disaster Recovery testing tasks

What You'll Need

Required:

• 5+ years of experience using SQL, App Studio, and WebFocus for data extraction and analysis

• Mining large datasets and applying statistical methods for actionable insights

• Designing and documenting data warehouse structures and transformation logic

• Data profiling and resolving data quality issues with business and IT teams

• Creating data flow diagrams and mapping data lineage

• Experience with DB2 server client tools

• Strong communication and collaboration skills with internal and external stakeholders

Preferred:

• 3+ years of experience with Tableau and WebFocus InfoAssist

• Ability to compare project procedures to standards and demonstrate expertise in WebFocus technologies

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

$56 - $66 per hour

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role receive paid time off and may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.