> Markdown version of [/jobs/ext/4012363-business-intelligence-architect-bi-architect-w2-only](https://www.wearedevelopers.com/jobs/ext/4012363-business-intelligence-architect-bi-architect-w2-only). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Business Intelligence Architect | BI Architect (W2 Only)

- **Company:** Macpower Digital Assets Edge LLC
- **Location:** Chicago, IL, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** JavaScript (Programming Language), Data Analysis, Cascading Style Sheets (CSS), Software as a Service, Cloud Database, Databases, Data Infrastructure, Data Security, Data Visualization, Data Warehousing, Relational Databases, Database Queries, Dimensional Modeling, IBM Cognos Business Intelligence, Oracle (Applications), Performance Tuning, Role-Based Access Control, Power BI, SQL Databases, ReactJS, Snowflake, Information Technology, Data Management, Front End Software Development, Restful APIs, Analysis Studio
- **Published:** October 29, 2026
- **Apply:** https://www.thejobnetwork.com/job/035449b3-5619-43b0-a558-90801bb75b30/business-intelligence-architect-bi-architect-w-only

## About the Role

* 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.

## 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.