Business Intelligence Architect | BI Architect (W2 Only)

Job Description

Job Description

Job Description: We are seeking a highly experienced Business Intelligence Architect to design, develop, and lead the implementation of reporting and dashboard solutions tailored to client requirements. This role will play a key part in architecting advanced BI solutions using ThoughtSpot, IBM Cognos, and modern data platforms. Key Responsibilities:

• Architecting complex BI solutions based on custom client requirements.
• Demonstrate deep expertise in ThoughtSpot Embed , utilizing its REST APIs and Visual Embed SDK for integration with custom applications.
• Administer the ThoughtSpot cluster, managing users, groups, and data access from a Data Admin perspective.
• Guide developers in creating and maintaining reports and dashboards using IBM Cognos Analytics .
• Build business intelligence solutions leveraging cloud data warehouses, especially Snowflake .
• Develop and optimize SQL queries to extract data from relational databases.
• Translate business requirements into scalable and effective reports, dashboards, and analytics.
• Maintain architectural documentation including blueprints, data flow diagrams, and technical specifications.
• Define and enforce best practices in reporting, data visualization, and analytics implementations.
• Implement data security measures, including role-based access control and compliance protocols.
• Perform capacity planning and performance tuning for ThoughtSpot and Cognos environments.
• Collaborate with business stakeholders to understand their information needs and provide strategic insights.
• Provide end-user technical support for reports and dashboard-related issues.
• Participate in project planning, offering input on design and development processes.
• Troubleshoot and resolve complex Cognos-related issues, providing expert-level support.
• Oversee upgrades and migrations of Cognos environments.
• Ensure deliverables are aligned with defined timelines and budgets .

Basic Qualifications:

• Bachelor's degree in Computer Science or a related field.
• 7 years of experience in Business Intelligence and analytics tools.
• 7 years of hands-on experience with IBM Cognos Analytics as a 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.
• Deep understanding of data warehousing concepts , including dimensional modeling.
• Strong SQL skills; experience with Snowflake, Oracle , or similar databases.
• Proficient in ThoughtSpot SaaS and ThoughtSpot Embed (Visual SDK expertise required).
• Experience with Power BI is a plus.
• Working knowledge of REACT is a plus.
• Strong front-end development skills in JavaScript and CSS .
• Exceptional analytical, problem-solving, and troubleshooting skills.
• Ability to communicate complex technical concepts to non-technical stakeholders.
• Certifications in ThoughtSpot and IBM Cognos are strongly preferred.

Must-Have Skills:

• Bachelor's degree in Computer Science or a related discipline.
• Expertise in ThoughtSpot Embed and Visual SDK.
• 7 years of experience in Business Intelligence and analytics tools.
• 7 years as a Cognos BI Developer or Architect .
• Expert proficiency in IBM Cognos Analytics (11.x or later) .
• Experience with Cognos Framework Manager, Report Studio, Dashboarding , and Analysis Studio .
• Solid knowledge of data warehousing , dimensional modeling , and SQL .
• Proficiency in Snowflake , Oracle , and Power BI .
• Experience with ThoughtSpot SaaS .
• Working knowledge of REACT , JavaScript , and CSS .
• Valid certifications in ThoughtSpot and IBM Cognos .