What are the responsibilities and job description for the Business Intelligence Architect | BI Architect (W2 Only) position at MDA Edge?
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.
- 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.
- 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.
Salary : $68