.Job Summary:Key Responsibilities:- Gather, extract, analyze and interpret field data from different sources to develop business insights- Create various types of reports and visualizations to identify trends, patterns and key performance indicators related to business activities: sales, marketing, operations, and other processes- Design and develop standardized and ad hoc reports, dashboards, and visualizations for business stakeholders- Provide recommendations based on data analysis to optimize sales and marketing strategies and effectiveness of field teams- Collaborate with cross-functional teams to develop and implement data-driven solutions- Develop and maintain reports and dashboards to track key metrics related to field Operations- Ensure data accuracy and completeness by performing regular data audits and reconciliations- Identify and communicate opportunities for process improvements to increase efficiency and accuracy of business processes- Write and execute queries upon request for data, and continuously improve performance and reliability of reportsQualifications:- Bachelor's degree in data analytics, business, or related field- Minimum of 4 years of experience in data analysis. Experience with Pharma marketing a plus- Experience with AWS Databricks, PySpark, Python & SQL is required.- CRT020: Databricks Certified Associate Developer for Apache Spark 2.4 with Python 3 Certification is required.- Experience in Report building using VBA automation is required- Experience with Xponent, DDD, SP&SD data is a plus- CRT020: Databricks Certified Associate Developer for Apache Spark 2.4 with Python 3 Certification is a plus- Strong analytical skills with the ability to analyze and interpret complex data sets, conduct quality checks and validations and build dynamic dashboards as business tools / assets in Excel, PowerBI, VBA Microsoft Office- Strong attention to detail with the ability to identify patterns and trends in data- Excellent communication skills, both written and verbal- Ability to work collaboratively with cross-functional teams- Knowledge of industry regulations and guidelines related to field reporting is a plus- Ability to derive, summarize and communicate insights from analyses.- Organization and time management skillsIn addition to strong analytical skills, should have excellent communication skills with a demonstrated track record of effective business partnership as demonstrated by material business impact and influencing.Additional Responsibilities:- Develop a deep understanding of internal customers' data and analytical needs focusing on the customer-facing model leadership- Champion the use of local customer insight in strategic and resourcing decisions across the business- Collaborate with the US Sales Force Operations to ensure success of key business processes and coordination on joint initiatives- Identify and prioritize enhancements and new analytic capabilities
