• Business Intelligence Analyst

    CAI (Trenton, NJ)


    Business Intelligence Analyst

    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** **Analys** **t** 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

     

    Reasonable accommodation statement

     

    If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.

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