Analytics Advisor - Hadoop Specialist

Position Summary

In this role, you would be developing and maintaining analytic productsincluding reports and data models to ensure success of key strategicinitiatives. You will also work with business partners on the analyticdevelopment team and other areas to solve complex data problems. You willprimarily responsible for designing and developing the analytic data layers aswell as Data Strategy and Data Manipulationprocesses to support analysis and reporting

Responsibilities include:

• Designing and building scalable data models and Data Strategy and Data Manipulation processes to support analysis and reporting.
• Utilizing SQL, writing queries to generate the output, performing routine maintenance, and addressing special requests.
• Following software development cycle for designing new analytical models, datamarts, reports, dashboards. Proactively interacting with business users and gathering business requirements.
• Designing functional and technical documents.
• Designing prototypes and get it approved from business users.
• Typical prototype would include database design and optimization, architecting tables, views, stored procedures, and visualizations using Tableau or MicroStrategy.
• Building and automate final model/dashboard in production. Automation would include designing SSIS packages/jobs, schedule scripts and error logging /handling code.
• Maintaining the solution on an ongoing basis and updating code as and when required.
• Supporting existing analytical work products and updating them based on various enterprises IT initiatives such as database migration, member/ client platform migrations and source system migration/consolidations.

#analytictalent

Position Summary

In this role, you would be developing and maintaining analytic productsincluding reports and data models to ensure success of key strategicinitiatives. You will also work with business partners on the analyticdevelopment team and other areas to solve complex data problems. You willprimarily responsible for designing and developing the analytic data layers aswell as Data Strategy and Data Manipulationprocesses to support analysis and reporting

Responsibilities include:

• Designing and building scalable data models and Data Strategy and Data Manipulation processes to support analysis and reporting.
• Utilizing SQL, writing queries to generate the output, performing routine maintenance, and addressing special requests.
• Following software development cycle for designing new analytical models, datamarts, reports, dashboards. Proactively interacting with business users and gathering business requirements.
• Designing functional and technical documents.
• Designing prototypes and get it approved from business users.
• Typical prototype would include database design and optimization, architecting tables, views, stored procedures, and visualizations using Tableau or MicroStrategy.
• Building and automate final model/dashboard in production. Automation would include designing SSIS packages/jobs, schedule scripts and error logging /handling code.
• Maintaining the solution on an ongoing basis and updating code as and when required.
• Supporting existing analytical work products and updating them based on various enterprises IT initiatives such as database migration, member/ client platform migrations and source system migration/consolidations.

#analytictalent

Preferred Qualifications

Healthcare experience preferred.

Required Qualifications

To be considered for this important and highly visible opportunity in our fast paced environment, you must have:

At least 2 years of post graduate, paid work experience with Hadoop

A minimum of 5 years of post graduate, paid work experience doing SQL coding on Teradata/Oracle/SQL Server;

2 years of experience with Business Intelligence platforms such as MicroStrategy., Tableau and advanced experience in data model design.

You will also have demonstrated experience in working on cross functional initiatives with business partners and other analytic colleagues