What are the responsibilities and job description for the Cognos BI Architect position at Sonoma Consulting Inc.?
Company 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 stake holders. 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 is 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
Titles: Data Engineer, Senior Data Engineer, Database Engineer, Data Architect, Senior Data Architect
