Business Intelligence Architect (8356-1)

Location: Chicago, IL | Type: Contract | Work mode: Hybrid | Max pay rate: $68/hr | Experience level: Mid-senior | Start date: To be decided

About the role

Hybrid role with 3 days onsite. You will design, solution, develop, and lead developers creating reports and dashboards for clients.

Responsibilities

• Architect complex solutions based on client’s custom requirements.
• Demonstrate deep expertise on ThoughtSpot Embed use cases and utilize ThoughtSpot’s REST APIs and Visual Embed SDK to integrate ThoughtSpot with various custom applications.
• Create and maintain user/group and administer the ThoughtSpot cluster from a Data Admin perspective.
• Help developers create and maintain reports and dashboards using IBM Cognos Analytics.
• Create BI solutions leveraging data from 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-based access controls, and compliance measures with BI platforms.
• Conduct capacity planning and performance tuning for ThoughtSpot and Cognos environments.
• Collaborate with 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.

Requirements

• Bachelor’s degree in computer science or related field.
• Expertise with ThoughtSpot Embed and Visual SDK is required.
• 7+ years of experience in Business Intelligence and Analytics tools.
• 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 and dimensional modeling.
• Experience with SQL and database technologies (e.g., Snowflake, Oracle).
• Experience with Power BI and 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 JavaScript 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.
• ThoughtSpot and IBM Cognos certifications (preferred).