UnitedHealth Group - Senior Manager - Analytics - Cognos

Discipline : Business Operations

Industry : Business Analysis

Job Description/Role and Responsibilities :

- The primary role of the developer is to take the design and technical specifications and develop effective and high quality technical solutions that meet the business requirements.

- The technical domain of the BI Developer includes understanding Business Intelligence (BI) best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, BI development, performance tuning and support system testing.

The responsibilities of the individual are :

- Ability to work closely with Business Analysts and SMEs to understand business needs and help define requirements for reporting solutions

- Ability to design and build reporting- semantic layer using Cognos cubes

- Proficient in designing and creating reports primarily using Cognos.

- Expertise in other BI Tools like Microstrategy and Business Objects and Microsoft SSRS preferred

- Proficient in- developing ETL packages using SSIS

- Familiarity with Data Visualization tools like Tableau, preferred

- Participate in development and configuration projects for a broad set of solutions including transactional and repository reporting applications

- Develop technical design documents to describe and support justification of the chosen reporting architecture and proposed implementation

- Develop detail design documents, data structure diagrams and code assets supporting the Reporting implementation

- Proficient in creating Process Flows using Visio

- Create/maintain report design related artifacts

- Validate the BI design and ensure that technical specifications are complete, consistent, concise, and achievable

- Ensure quality assurance by unit test activities including the development of test cases and publication of unit test results

- Performance tuning of BI processes

- Well versed with Automation tools like Tivoli Maestro

- Ability to work in a matrixed team environment with distributed responsibility across different teams

- Ability to work and deliver in a very high paced environment with limited information at times to support business needs

- Experienced in- working with sensitive/de-identified data environments

- Experience in working with encrypted and secure data transfers

- Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.

- Participate in BI/Reporting architecture design reviews.

- Conduct BI/Reporting unit testing and code reviews.

- Participate in system and integration test; identifies and remedies solution defects.

- Create other technical artifacts needed for project implementation.

No. of Openings - 2

Qualification/Required Qualifications :

The person performing this role would require having at least

- 8+ years of Cognos Suite

- 6+ years of SQL Server Integration Services, (SSIS 2008 and above for ETL)

- 6+ years of SQL(SQL 2008 and above)

- Proficient in Unix shell scripting

- Excellent SQL skills and ability to create T-SQL/stored procedures

- Configuration Management using Microsoft Team Foundation Server and/or other version control tools

- Understanding of Enterprise Data warehouse data models and dimensional modelling concepts, source to target mapping and Data Integration architecture

- Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the client

- Excellent oral and written communication skills

Preferred Qualifications :

- Knowledge of a Data Modeling Tool like Erwin

- Knowledge of other databases like Teradata, Oracle, SQL Server

- Knowledge of MS SQL Server Suite (SSIS, SSRS, SSAS) and other BI- tools like- Business Objects, Micro-strategy

- Knowledge of Testing and Defect tracking tools like HP ALM/QC

- MS Office Suite, MS Visio

- Knowledge of end to end- SDLC- from project inception to deployment

- Experience in different project management methodologies i.e. Agile and Waterfall

- Healthcare Payer/PBM domain knowledge in a data warehouse environment

The Apply Button will redirect you to website. Please apply there as well.