Data Analyst/Business Analyst

About the position

The Cognos Business Intelligence Analyst will provide professional business analysis and analytical skills to assist in the overall Business Intelligence process. Perform business analysis, design analysis, Cognos Development, and Testing. The Cognos Business Intelligence Analyst is responsible for creating the Requirements & Reporting Specifications for the team while utilizing the application of standard, descriptive, and inferential statistical methods for conducting necessary analysis. This could include participating in converting legacy system reports to Cognos BI solutions. This includes participating in the data integrity initiative and works with end users to follow through with associated action items. This could include framework modeling, report writing (relational and multi-dimensional), and creating dashboard components using the Cognos suite of products. The Cognos Business Intelligence Analyst helps to enforce data integrity, researches and documents data mapping from source to target systems, and assists with data modeling as necessary. Creates and executes test plans/scripts to test/QA reports and programs. Works closely with Project Management, Cognos Developers, Data Architects, Data Modelers, Application Development, and ETL Development Team to design and implement BI applications using shared architecture and Enterprise Data Warehouse. Will be working closely with business users to verify data requirements and access needs. Populates metadata. Develops report templates and implements BI standards. He/she may help with any administration, security, or maintenance needs as identified by the team.

Responsibilities
? Perform business analysis, design analysis, Cognos Development, and Testing.
,
? Create Requirements & Reporting Specifications for the team.
,
? Utilize standard, descriptive, and inferential statistical methods for analysis.
,
? Participate in converting legacy system reports to Cognos BI solutions.
,
? Participate in the data integrity initiative and follow through with action items.
,
? Conduct framework modeling, report writing, and create dashboard components using Cognos.
,
? Enforce data integrity and document data mapping from source to target systems.
,
? Assist with data modeling as necessary.
,
? Create and execute test plans/scripts to test/QA reports and programs.
,
? Work closely with Project Management, Cognos Developers, Data Architects, Data Modelers, Application Development, and ETL Development Team.
,
? Verify data requirements and access needs with business users.
,
? Populate metadata and develop report templates.
,
? Implement BI standards and assist with administration, security, or maintenance needs.

Requirements
? Gathering business requirements.
,
? Experience with Teradata, Oracle, SQL Server Databases and Cognos.
,
? Experience in Business Intelligence.
,
? Strong understanding of project management, specifically in the SDLC and Agile methodologies.
,
? Expert in Microsoft products including Outlook, Word, Excel, PowerPoint, Visio.
,
? Ability to write PL/SQL scripts for data refreshes and queries.
,
? Ability to identify and map source and target data for Cognos development.
,
? Excellent written and verbal communication skills.
,
? Ability to lead meetings regarding requirements definition.
,
? Ability to communicate effectively with business, vendor, and project management staff.
,
? Ability to participate in decisions regarding study design, data collection, data analysis, and methodology.
,
? Ability to work independently or as part of a team.
,
? Ability to perform other activities as needed to help the team or project succeed.

Nice-to-haves
? Agile Methodology
,
? Agile User Stories/Acceptance Criteria
,
? Data Profiling
,
? MySQL
,
? Relational Databases
,
? Requirements Management Tools

Benefits

Apply Job!