Cognos BI Architect

Sonoma Consulting Inc.; New Brunswick (NJ); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology consulting company located in New Jersey is looking for a Cognos Developer with at least 4 years of experience in Cognos development and support projects. The candidate should be adept at handling customer communications and have strong skills in the Cognos reporting tool suite. The role requires strong knowledge of data warehousing, multigeographical teamwork, and the ability to independently manage multiple projects. Dedicated U.S. citizens and Green Card holders are encouraged to apply for this full-time position.

Qualifications

• Minimum 5+ years’ experience in IT and business intelligence.
• Ability to independently work on multiple projects with minimal supervision.
• Excellent interpersonal, oral and written communication skills.

Responsibilities

• Develop and support Cognos architecture and reporting tools.
• Communicate with customers to address concerns directly.
• Collaborate with team members on data warehouse and report development.

Skills

Cognos reporting tool suite (Report Studio, Query Studio)

SQL Server

Data warehousing concepts

Apache Kafka

Rabbit MQ

NoSQL datastores

Java

Python

Amazon Web Services

Job description

Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companies to help them build innovative businesses that keep them one step closer to their customers and one step ahead of the competition. We offer a meaningful work environment for employees, attractive and interesting engagements for consultants, and cutting‑edge digital innovation for our customers. We delight in helping our customers execute their digital vision, big projects or small. Halo Group knows that by combining the highest quality talent with our unwavering support, we will become an invaluable extension of the team. Halo Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all areas of product/project governance, UX/UI, multi‑platform applications, quality assurance/testing, cloud computing, and data analytics. Since its inception, Halo Group has been recognized for numerous awards, including:

• INC 5000
• Future 50
• 101 Best and Brightest
• Michigan 50 Companies to Watch
• Goldline Research – “Most Dependable Companies”
• Ernst & Young – “Entrepreneur of the Year” Finalist

Job Description

Minimum 4+ years overall Cognos development and Support experience.

Should be well‑versed with Cognos architecture and must have idea about development projects support projects. Team handling experience in a multi‑geographical environment. Prior experience in handling multiple stakeholders. Customer handling. Need to communicate directly with customers to address their concerns. Hands‑on experience with the Cognos reporting tool suite Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer in Cognos BI 10.2.x. Ability to independently develop Framework Manager Models and advanced Report Studio and or Analysts Studio reports is required. Strong experience developing report studio reports using Cognos DMR model. Strong experience in creating Dimensional Reports. Data extraction from SQL Server MS Excel and load data into QVDs. Design dashboard building business logic for creation of reports. Build and maintaining QVDs and QVWs. Create different Charts in Dashboards. Implement Periodic Calculations. Ability to collaborate on a team with infrastructure, data warehouse, and business analyst resources, and clearly communicate solutions to both technical and non‑technical team members. Ability to troubleshoot query issues during report development using a methodical approach, including comparing the tabular data from Cognos queries with Teradata queries on the data warehouse database based on the report specification. Strong understanding of BI and Data Warehouse database concepts.

Qualifications

Minimum 5+ years’ experience in IT and business intelligence. Strong knowledge in data warehousing concepts.

Ability to independently work on multiple projects with minimal supervision and also to function effectively as a team member. Excellent interpersonal, oral and written communication skills. In addition, the ability to teach and cross‑train others. Extremely disciplined, self‑motivated and detail oriented.

Additional Information

U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time. This is a Full‑Time / Permanent job opportunity. Only for US Citizen and Green Card Holder.

All your information will be kept confidential according to EEO guidelines.

Skills: Apache Kafka, Rabbit MQ, NoSQL datastores, Java, Python, SQL, Amazon Web Services