Role: Sr. BI Developer with Web Focus & Data Warehousing Exp (Hybrid) – Location: Trenton, NJ (In-Person) – Only local candidates with valid DL Copy.

Job Title: BI Developer Web Focus & Data Warehousing (Hybrid)

Location: Trenton, NJ.

Duration: 12 Months

Interview Type: In-person interview required

Job Description:

A leading government-affiliated organization is seeking a Business Intelligence (BI) Developer with strong experience in Web Focus, SQL, and Data Warehousing to support their Data Analytics team. The ideal candidate will work closely with analysts and business stakeholders to extract, analyse, and integrate data from various systems, supporting analytics and reporting needs across departments.

This is a hybrid role with two days onsite (Tuesdays and Wednesdays) and three days remote each week.

Key Responsibilities:

• Collaborate with Research Analysts and business teams to understand data requirements and analytics goals.
• Extract and analyse raw system data from complex data warehouses using SQL, App Studio, and Web Focus.
• Design and develop data warehouse structures and summary tables optimized for analytics and reporting.
• Conduct data profiling and validation to ensure data quality and accuracy.
• Create and maintain data flow diagrams, data lineage documentation, and transformation logic.
• Prepare detailed data requirements, models, and transformation rules.
• Align and join data from disparate systems using common connection points.
• Automate data extraction processes to increase efficiency.
• Analyse BI tool code (e.g., Web Focus, Tableau) to ensure correct data usage.
• Identify and resolve data quality issues in collaboration with business and IT teams.
• Assist in testing and validating data extracts and visualizations.

Required Skills & Experience: