Business Intelligence Architect

Job Title: Business Intelligence Architect

Job Duration: 6 Months

Job Location: Chicago, IL

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 7+ 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

IBM Cognos certifications