14/03 Tanvi Mittal
hr at RSK Business Solutions Pvt. Ltd.

Views:713 Applications:69 Rec. Actions:Recruiter Actions:28

Data Wrangler II/Data Analyst - Business Intelligence (3-5 yrs)

Gurgaon/Gurugram Job Code: 422408

Role : The purpose is to understand the business logic supporting US healthcare data and apply the logic to data clean-up and analytic efforts.

Skills Required :

- Expertise in Data wrangling - people who can analyze an external data source, write transformation/clean-up scripts, and load data into structured DB

- Knowledge of healthcare data, in particular, US medical and pharmacy claims

- Experience with Business Intelligence, Data integration, and Data Mining applications

- Ability to understand data entities, relationships, table structures, and flow of data throughout the organization

- Advanced knowledge of database functionality, SQL, and Stored Procedures using MySQL

- Advanced knowledge of Microsoft Excel

- Advanced knowledge of R or Python scripting language a plus

- Strong verbal and written communication skills

- Ability to perform multiple tasks in a fast-paced, continually changing environment

- Knowledge of AWS Services (Web API- s, Glue, Athena, EC2, Redshift,

Responsibilities/Duties :

- Work with the Business teams to understand data structures and logic tied to the intake of US medical claims, pharmacy claims, and results from health data analytic partners

- Write intake scripts to transform medical claims, pharmacy claims, biometrics, and socio-economic data and load into structured DB

- Write extracts to support interfaces with external analytic vendors

- Write intake scripts to transform analytic output from analytic partners and load into structured DB

- Experience as a business/data analyst in a data-centric project environment

- Strong SQL skills, comfortable with large volumes of data understand data transformation normalization and data-modeling

- System troubleshooting and problem-solving across platform and application domains

Add a note
Something suspicious? Report this job posting.