Assoc CMC Regulatory Sciences Data Analyst

Regeneron Pharmaceuticals, Inc.; City of Troy (NY); On-site; USD 62,000 - 92,000; Full time

Job summary

Regeneron Pharmaceuticals, Inc. seeks a data analytics professional to support CMC Regulatory Sciences by creating tools and content that enable data functionality across planning, reporting, and monitoring workflows.

The role emphasizes data analysis, database and report development, metrics tracking, and analytics to improve efficiency and data integrity. You will design and implement data solutions using Excel, Access, VBA, SQL, SharePoint, and SQL Server, building interfaces and reports to

Qualifications

• Experience in data analysis and creating tools to support regulatory planning and submissions.
• Ability to design and build data workflows, reports, and dashboards.
• Proficiency with Excel, Access, VBA, SQL, SharePoint, and SQL Server for end-to-end data solutions.

Responsibilities

• Conduct data analysis to consolidate data for regulatory submissions and oversight of systems supporting global submission visibility.
• Develop databases and reports using data entry forms and Excel workbooks to support submission planning and responses.
• Create queries and reports to generate outputs for Excel and PowerPoint from Microsoft Access.
• Incorporate queries and reports into workflows to support planning, scheduling, monitoring, and reporting.
• Develop ad-hoc queries and reports to resolve urgent regulatory issues.
• Build Excel models, tools, and templates with advanced formulas and programming including VBA and SQL.
• Develop analytics to identify opportunities and improve reporting, planning, and staffing efficiencies.
• Develop and administer SharePoint sites for routine reports and ad hoc information requests.
• Track metrics for data timeliness, accuracy, and integrity across teams.
• Provide support and SME guidance to build additional databases and reports.
• Build front-end applications to SQL Server databases for data entry and record management.

Skills

Data analysis

Tools

Excel

Microsoft Access

PowerPoint

VBA

SQL

SharePoint

SQL Server

Job description

This role supports CMC Regulatory Sciences by creating tools and content that enable data functionality across planning, reporting, and monitoring workflows. The position focuses on data analysis, database and report development, metrics tracking, and analytics intended to improve efficiency and data integrity.

Key Responsibilities

• Conduct data analysis to design and build approaches for consolidating data tied to regulatory submissions, including oversight of systems that support global submission visibility.
• Support CMC Regulatory Sciences systems through database development and use of data entry forms and reports, potentially combined with Excel workbooks and charts, to create user-friendly interfaces for uploading and inputting submission planning and response information.
• Build and/or interpret queries and reports to generate ready-to-use outputs for Excel and PowerPoint from Microsoft Access.
• Enable day-to-day planning, scheduling, monitoring, and reporting needs by helping CMC Regulatory Sciences teams incorporate queries and reports into their workflows.
• Create ad-hoc queries and reports to gather and present information for timely resolution of urgent CMC Regulatory Sciences issues.
• Design Excel models, tools, and templates using advanced formulas and programming, including VBA and SQL.
• Develop analytics to identify opportunities and drive improvements in reporting, planning, and staffing efficiencies.
• Develop and administer SharePoint sites to provide stakeholders with access to routine reports and support ad hoc information requests.
• Develop and track metrics to assess stakeholder data timeliness, accuracy, and integrity, and align across teams to improve reporting integrity.
• Provide support and subject matter expertise to build additional databases and reports, including documenting user requirements for new development.
• Build front-end applications to SQL Server databases for end user data entry and record management.

Required / Relevant Technologies

Excel, Microsoft Access, Powerpoint, VBA, SQL, SharePoint, SQL Server

Location and Compensation

• Location: Troy, NY (onsite)
• Salary: USD 62,355 to 92,400 per year