Job Summary:
Aldevron, a Danaher operating company, is committed to driving innovation in life sciences, diagnostics, and biotechnology. The Commercial Data, Senior Analyst will create and maintain commercial dashboards, provide analysis and reporting on commercial KPIs, and collaborate with IT and business teams to ensure data accuracy and effective reporting practices.
Responsibilities:
• Establish Analytics and Reporting Standard Work: Maintain detailed documentation of report specifications, development scripts, and standard procedures for completing reports and develop best practices for data hygiene and governance. Collaborate with the IT team to establish necessary infrastructure and processes required to deliver Commercial reporting.
• Develop Reports and Dashboards: Create user-friendly and scalable reports and dashboards in Power BI, HubSpot, Excel, PowerPoint, considering usage scenarios, administration, standardization, integration, governance, adoption, and future growth. Collaborate with business teams to gather reporting requirements and specifications to create clear, repeatable metrics that meet business analysis needs.
• Provide insights and Commercial trends: Monitor, analyze and ultimately action field intelligence with internal stakeholders, including development and tracking of KPI’s. Share insights and support Commercial initiatives by providing analysis and summarized data to communicate trends and gaps to the business.
• Verify Data Accuracy and Integrity: Conduct data validation checks, resolve data quality issues, monitor data hygiene within CRM and reporting tools and ensure compliance with data privacy regulations and security protocols to protect sensitive information.
• Must be naturally inquisitive, team player, diligent with ability to tell a story using data and present findings to all stakeholders.
Qualifications:
Required:
• Bachelors degree required
• 5+ years of professional experience in data analysis with experience supporting commercial sales organizations
• Broad and deep understanding of data analysis concepts to facilitate the research and analysis of commercial and operational key performance indicators (KPIs)
• Advanced expertise in Microsoft Excel and analytics, including building advanced excel models (i.e. advanced pivot tables, complex lookups, conditional formulas, power pivot and power query), relationship models, DAX and advanced proficiency in visualization tools such as Power BI, Tableau, etc.
• Experience and proficiency managing and cleaning large databases and integrating sets of raw data, with extreme attention to detail and the intellectual curiosity to investigate potential data integrity issues
• Intermediate to Advanced knowledge and experience using SQL, Power BI dataflows, Python and VBA
• Must be naturally inquisitive, team player, diligent with ability to tell a story using data and present findings to all stakeholders
Preferred:
• Analytics or similar discipline is preferred
• Life Sciences or Diagnostics industry strongly preferred
Company:
Aldevron is a biological development and manufacturing organization specializing in cell and genetic engineering. Founded in 1998, the company is headquartered in Fargo, USA, with a team of 1001-5000 employees. The company is currently Late Stage.