Cognos BI Architect

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 #J-18808-Ljbffr Sonoma Consulting Inc.