Job Description

The Associate will provide integral support to our ongoing client projects. Data Insights Analyst will leverage standard pharma industry datasets - Sales, claims, Payer datasets from IQVIA, Symphony and Veeva etc to synthesize key insights to provide strategic recommendations and implications, as appropriate. A successful candidate should have experience in the biopharma and/or healthcare industry, a background in data analysis and managing data integration projects, a proactive mindset, and a demonstrated track record of generating impactful insights for clients. Successful candidate should be capable of building data pipelines and Business Intelligence reports on Data Lake architecture combining several data sets to enable performing univariate and multivariate analysis. This includes data integration, harmonization and transforming raw data into curated datasets for Data / BI Analytics. On the tools side, The successful candidate should possess a strong background in a complex data processing environment using SQL platforms (like Redshift, Athena, Snowflake etc), Python/Jupyter Notebooks ( SageMaker etc) and Business Intelligence tools such as Tableau, Qlik, Quicksight. Key Responsibilities: Analyze Pharma datasets like IQVIA, Symphony, Veeva and Open data using SQL and cloud based data analytics tools to provide insights that solve client problems Synthesize and form recommendations using data visualization tools (QuickSight, Tableau, ThoughtSpot, etc) and PowerPoint slides Analyze new requests for data, identifying the appropriate datasets, and generating database queries and summary data outputs for stakeholders Provide findings and final recommendations to client via written communication and formal presentations Understand client business issues, operating business rules, data and standard operating procedures What You Bring: Education: Bachelors or masters degree required in any discipline with strong record of academic success in quantitative and analytic coursework such as finance, applied mathematics, management science, data science, statistics, econometrics or engineering Experience: 1-3 years of previous experience working with key pharmaceutical/biotechnology data sets like Sales, Claims,Payer and other secondary data. Skills: Extensive experience in building data pipelines, Data Lake architecture using AWS services Redshift,Athena, S3 . Must be proficient in Python and SQL Demonstrated experience with data processing, data analysis, profiling, data cleansing and standardization process Build data stories and visualization using Business Intelligence tools such as Tableau, Qlik, Quicksight etc Excellent advanced SQL and analytical skills to query databases to perform data analysis to further enhance business analysis. Ability to demonstrate strong Microsoft Excel skills, including Pivots and macros Ability to work independently and collaborate with colleagues to accomplish team goals and deadlines Advanced problem-solving skills and build / elevate internal capabilities; Ability to adapt quickly in a constantly changing environment.