Cognos BI Architect Wealth Management

Compunnel, Inc.; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

A leading company is seeking an experienced Business Intelligence Architect in Chicago. The role involves designing and implementing advanced BI solutions, leading developers, and utilizing tools like IBM Cognos and Snowflake. Ideal candidates will have extensive experience in data warehousing and report/dashboard development with a focus on ThoughtSpot SaaS.

Qualifications

• 10+ years experience as a Cognos BI developer or architect.
• Expert knowledge of Cognos Analytics and Framework Manager.
• Experience with SQL and database technologies.

Responsibilities

• Architect complex BI solutions based on client requirements.
• Help developers create and maintain reports using Cognos and Snowflake.
• Conduct capacity planning and performance tuning for Cognos.

Skills

Cognos Analytics

SQL

Data warehousing

Business Intelligence

Analytical skills

Education

Bachelor’s degree in computer science or related field

Tools

IBM Cognos Analytics

Snowflake

Power BI

ThoughtSpot SaaS

Job description

We are looking for an experienced Business Intelligence Architect to join our team.

As a Business Intelligence Architect, you will be responsible for designing, solutioning, developing and leading developers creating reports and dashboards delivery to clients.

Job Responsibilities:

Architecting complex solutions based on client’s custom requirements.

Help the developers create and maintain reports and dashboards using Business Intelligence applications using IBM Cognos Analytics

Create BI solutions leveraging data form Cloud data warehouses like Snowflake

Write and maintain SQL queries to retrieve data from relational databases.

Analyze and understand business requirements to design and develop effective reports and dashboards.

Develop and maintain architectural blueprints, data flow diagrams, and technical documentation

Define best practices for reporting, data visualization and analytics solutions

Implement data security, role base access controls and compliance measures with BI platforms

Conduct capacity planning and performance tuning for Cognos environments.

Collaborate with the business stakeholders to understand their information needs and provide insights.

Provide technical support to end-users on report and dashboard related issues.

Participate in project planning and provide input to the design and development process.

Troubleshoot and resolve complex Cognos issues, providing expert-level support.

Oversee the migration and upgrade of Cognos environments.

Ensure adherence to timelines and budgets

Qualifications:

Bachelor’s degree in computer science or related field.

Minimum 10+ years of experience as a Cognos BI developer or architect

Expert-level proficiency in IBM Cognos Analytics (11.x or later).

Strong experience with Cognos Framework Manager, Report Studio, Dashboarding, and Analysis Studio.

Solid understanding of data warehousing concepts, dimensional modeling

Experience with SQL and database technologies (e.g., Snowflake, Oracle).

Experience with Power BI, ThoughtSpot SaaS

Experience with REACT is a plus

Excellent analytical and problem-solving skills, with the ability to quickly learn and understand complex business processes.

Strong knowledge of front-end Java Script and CSS.

Strong attention to detail and the ability to work independently or as part of a team.

Excellent oral and written communication skills, with the ability to effectively communicate technical concepts to non-technical stakeholders

Looking for, most importantly cognos and thoughtspot exp

seasoned architect

maintain requirements and customizations

not looking for developer, already have that offshore

hands on experience with snowflake and not another similar db

nice to have: custom authentication set up

Overview:

moving from Cognos to ThoughtSpot SaaS

will be maintaining custom reports and dashboards