Business Intelligence Architect | BI Architect (W2 Only)

Remote: 
Hybrid
Contract: 
Work from: 
Chicago (US)

MDA Edge logo
MDA Edge Scaleup https://mdaedge.com/
201 - 500 Employees
See all jobs

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.

Required profile

Experience

Related jobs