To be a driven business analyst who can work on complex Analytical problems and help the customer in better business decision making especially in the area of pharma/life sciences (domain).
Job Responsibilities- Participates in requirements gathering and research, proposes technology solutions, and develops solutions within agreed upon timelines. Understand the underlying data and flow of data.
- Design, implement, and support data warehousing – implement business rules via stored procedures, middleware or other technologies; define user interfaces and functional specifications
- Build ETL pipelines with ability to implement complex business rules
- Evaluate, design, and maintain multiple database environments; identify data sources, construct data decomposition diagrams, provide data flow diagrams, and document the process; write codes for database access, modifications and constructions including stored procedures and database server configuration
- Well versed with SQL and PL/SQL with ability to create, debug, optimize store procedures / SQL statements
- Troubleshoot and resolve data quality issues, database performance issues, database capacity issues, replication and other distributed data issues
- Resolve performance issues by looking at query plans, create appropriate indexes, resolve dead locks, and create table hints
- Implement SDLC processes including creating STTM documents, system design, code reviews, deployment plans, enhancements, status reporting etc
- Client engagement including requirements management, user acceptance
- Provide hypercare and production support of implemented data engineering solution
- Impact assessment, incident/problem management, change request estimation and implementation
- Automation and continuous improvement
Education BE/B.TechMaster of Computer ApplicationWork Experience- Minimum of 0-5 years of relevant experience in Pharma domain.
- Technical:
Ø Should have 0-5 years of hands on experience in the following tools:
• Must have working knowledge of tools: Atleast 2 of the following – Qlikview, QlikSense, Tableau, Microstrategy, Spotfire/ (Informatica, SSIS, Talend & metallion)/ Big Data technologies - Hadoop ecosystem.
Ø Aware of techniques such as: UI design, Report modeling, performance tuning and regression testing
Ø Basic expertise with MS excel
Ø Advanced expertise with SQL
- Functional:
Ø Should have experience in following concepts and technologies:
• Specifics:
• Pharma data sources like IMS, Veeva, Symphony, Cegedim etc.
• Business processes like alignment, market definition, segmentation, sales crediting, activity metrics calculation
• Calculation of all sales, activity and managed care KPIs