XTGlobal - Cognos MDX Developer - Data Analytics (8-12 yrs)

Cognos MDX Developer

Hyderabad / Vizag / Remote - Fulltime

We are seeking a Cognos Developer who will be responsible for the production support, design, development and implementation of Business Intelligence (BI) Solutions.

Responsibilities :

- Monitor and troubleshoot existing Cognos BI Reports, including framework models and powerplay cubes and ensure the availability of Cognos reporting for the end-users.

- Monitor the integrity and validity of the data.

- Analyze BI requirements and enhance existing/ create new Cognos Reporting solutions to support standard reporting, Dashboard, Storyboard, and self-service environment.

- Collaborate with cross-functional teams to gather and document BI requirements.

- Analyze BI requirements and design/develop Cognos Reporting solutions to support standard reporting, Dashboard, Storyboard, and self-service environment.

- Collaborate with stakeholders to define the business and presentation layers of the BI model that is business-friendly and supports a self-service environment.

- Perform Unit, smoke testing of the Cognos reports and validate the data between the report against the output from database.

- Maintain/manage the security aspects of the BI Platform including user/group provisioning, security role maintenance, and integration with Active Directory.

- Assist with testing platform upgrades.

Qualifications and skills :

Requirements :

- Minimum 2 years of experience with bachelor's degree or 4 years of advanced reporting experience.

- Most recent experience must be Business Intelligence/Data Analytics focused with at least 1 year of hands-on experience in advanced report development using Cognos.

- Proficiency with Cognos Analytics (11. X) and its Product Suite (Report Studio, Framework Manager, Transformer)

- Working knowledge of relational databases, SQL, and procedural SQL scripting languages

- Experienced in Framework Manager Dimensional Modeling, Transformer cube design, and development.

- People person, team player with a strong can-do mentality

- Understanding of data warehousing, OLAP concepts

- Must be an inquisitive learner and have a thirst for improvement.

- Strong analytical skills, including experience, familiarity, and ease with analyzing large, multi-dimensional data sets.

- Exceptional communication and collaboration skills to engage with multiple stakeholders and different teams to deliver BI solutions efficiently.

- Highly motivated, result-oriented self-starter who enjoys working in a fast-paced environment. Proven ability to function well independently as well as in a team.

Preferred :

- Experience with Java Scripting

- Experience working with data sourced from JD Edwards

- Experience working in a DevOps environment.

- Understanding of SOX and project management principles and concepts

Additional Details :

- Proficiency with all aspects of IBM Cognos Analytics Product Suite (Reports , Framework Manager, Powerplay Transformer, Administration)

- Proficiency with SQL to query Oracle and SQL Databases.

- Experienced in Framework Manager Dimensional Modeling, Transformer cube design and development

- Proven experience in scripting (HTML, Java Scripting and/or jQuery) to extend Cognos capabilities

- Proven experience in creating reports using Dimensional model using Cognos MDX

- Excellent performance tuning and trouble shooting skills

- Ability to work collaboratively in a team environment with a strong focus on customer service and solution ownership

- Effective verbal, written and interpersonal communication