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

Overview

Hybrid
Up to $85
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

Sr. BI Developer
BI Developer
Business Intelligence
Web Focus
SQL
Data Warehousing
Data Extraction
Data Analysis
Data Integration
Analytics
Reporting
App Studio
Data Modeling
Data Profiling
Data Validation
Data Flow Diagrams
Data Lineage
Transformation Rules
DB2
Tableau
InfoAssist
Raw System Data Analysis
Large Dataset Mining
BI Tools
Report Development
Stakeholder Collaboration
Automation
Visualizations
Public Sector Experience

Job Details

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:

Skill

Working with business teams to define analytics needs

Raw system data analysis

Mining large datasets and deriving actionable insights

Data extraction from large, complex data warehouses

Preparing data models, requirements, and transformation rules

SQL proficiency

Data profiling and issue resolution

Creating data flow diagrams and mapping

DB2 server/client experience

Preparing data for Tableau

Creating data extracts and reports in Web Focus Info Assist

Proficiency in App Studio for report coding

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About HSK Technologies, Inc.