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
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.
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.
** 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
Skills Required
- Minimum 4+ years Cognos development and support experience
- Hands-on experience with Cognos Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer (Cognos BI 10.2.x)
- Ability to independently develop Framework Manager models and advanced Report Studio or Analysis Studio reports
- Strong experience developing reports using Cognos DMR models and creating dimensional reports
- Experience extracting data from SQL Server and Microsoft Excel and loading data into QVDs; building and maintaining QVDs and QVWs
- Design dashboards, create charts, and implement periodic calculations
- Ability to troubleshoot query/report issues, comparing Cognos tabular results with Teradata queries
- Strong understanding of BI and Data Warehouse concepts
- Minimum 5+ years overall experience in IT and business intelligence
- Team handling experience in multi-geographical environments and stakeholder/customer handling
- Excellent interpersonal, oral and written communication skills; ability to teach and cross-train others
- Authorization to work in the U.S. (U.S. Citizen or Green Card Holder). Employer is unable to sponsor visas
- Experience or familiarity with Apache Kafka, RabbitMQ, NoSQL datastores, Java, Python, SQL, and AWS
What We Do
Sonoma Consulting Inc. is a national IT consulting and executive search firm founded in 2011 by Mark McGee. The company operates through two business divisions—IT Consulting Services and Executive Search—serving approximately 150 national clients that range from entrepreneurial start-ups to Global Fortune 500 companies. It specializes in harmonizing systems and application or infrastructure development projects.








