Business Intelligence - Production Support w/Microstrategy exp. (REMOTE)

Business Intelligence - Production Support w/Microstrategy exp. (REMOTE)

Date: Mar 6, 2025

Location: Toronto, ON, CA

Company: NTT DATA Services

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Business Intelligence - Production Support w/Microstrategy exp. (REMOTE) to join our team! This is a fully remote role and can be based anywhere in Canada.

Job Responsibilities Include:

• Working closely with Project managers, user interaction designers, and onsite/offshore software engineers to deliver new and enhancement projects.
• Prioritize and manage work to critical project timelines in a fast-paced environment.
• Preparation of Architectural documents and best practices for the solution.
• Provide back-up strategy for implementation and Data Migration planning.
• Create appropriate indexes for the relevant columns of the tables in the database.
• Documentation of test cases and workflow instructions.
• Deployment of BI packages and BI reports.
• Unit test of BI ETL Jobs for extraction, transformation, and loading of client data.
• Unit test of BI Tool Reports that are used to populate and send the Clients Data via BI Tool.
• Ensure system and database scalability, security, performance, and reliability.
• Participate in implementation, rollout, migration, integration, upgrades for BI applications.
• Design the Data foundation/Data Lake and the business layers in BI Dashboard.
• Define security roles & user groups for BI Reporting Tool.
• Create dashboards for easy monitoring and alerting.
• Build new environments for BI Tool and manage version controlling and upgrades.
• Organize and deliver services on a cross-section of complex projects for BI Tool.
• Define Folder security in CMC and implement Row level security in reports and dashboards.
• Develop strategy regarding overall architecture and infrastructure, identifying necessary system enhancements.
• Conduct system and application performance analysis, coordination, and remediation.
• Identify automation for repetitive activities and propose performance improvements.
• Identify low performance jobs within the system and rewrite/redesign to improve performance.
• Drive a coordinated Business Intelligence and Automation strategy to enable KPIs to track and report the success of each activity.

Basic Qualifications:

• 8+ years of experience in development/enhancement, analysis, design, maintenance, documentation & testing.
• 6+ years of experience in SSIS & SQL Server and at least 4+ years of experience in MicroStrategy.
• Experience in developing new BI ETL Packages/Processes to meet new Clients' requirements.
• Create technical Specification Documents for the development of New ETL Packages and BI Tool Reports.
• Create design documents for defining process, quality, and information analyzer jobs.
• Creation of Adhoc and Canned Reports in BI Tool while analyzing the business user’s requirements.
• Analysis and study of existing systems and integrate new ETL Packages within the system.

About NTT DATA

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies.

Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure, and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com