Data Analyst Jobs in New York, NY

About The Position

Requirements

• Bachelors degree required. Analytics or similar discipline is preferred
• 5+ years of professional experience in data analysis with experience supporting commercial sales organizations. Life Sciences or Diagnostics industry strongly preferred
• DATA REPORTING & ANALYSIS: Broad and deep understanding of data analysis concepts to facilitate the research and analysis of commercial and operational key performance indicators (KPIs).
• REPORTING TOOLS: 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.
• DATA MANIPULATION: 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.

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.

Benefits

• paid time off
• medical/dental/vision insurance
• 401(k)