Sr. Data Analyst

Role overview

Responsibilities

• Generate standard or custom SQL reports summarizing business, financial, or economic data for stakeholders.
• Synthesize business intelligence and trend data to support recommendations; analyze customer trends for strategic implications.
• Create and update databases, build complex SQL stored procedures, and develop dashboards, systems, or process methods.
• Prepare reports or correspondence about project specifications, activities, and status.
• Consult with customers and departments on project status, proposals, and technical issues, including software system design or maintenance.
• Collaborate with project and technical teams to provide insight into data issues and support business decisions and processing events.
• Supervise and assign work to other analysts; perform data interpretation, forecasting, predictive modeling, and executive presentations.

Education and experience

• Bachelor’s degree in Database Management, Data Analytics, or a similar field; a master’s degree is a plus.
• 3–5 years of analytics experience working with large datasets and 3+ years of business intelligence tool design experience.
• Pharmaceutical or life sciences experience is strongly preferred; previous client-facing experience is preferred.

Technical skills

• Advanced SQL is required, including complex joins, subqueries, analytical functions, and clean, comprehensive dataset production.
• Experience with Microsoft SQL Server or Oracle to establish architecture, build stored procedures, and write complex queries.
• Business intelligence dashboard and report development using Power BI, Tableau, or Looker is required; SSRS and Excel are listed as reporting tools.
• PostgreSQL, AWS, Salesforce, or Python experience is a plus.

Knowledge and competencies

• Expertise in data interpretation, forecasting, predictive modeling, and executive presentation.
• Able to explain complex analytics to non-technical audiences; strong problem-solving, critical-thinking, communication, and time-management skills.
• Competencies include service orientation, technical utilization, process knowledge and improvement, and timely, informed decision-making.

Travel

• Occasional travel to offices in New Jersey, Pennsylvania, or Pittsburgh.

Compliance

• Follow company policies, procedures, information security and compliance programs, including SOC 1, SOC 2, PCI, and HIPAA.
• Comply with company and client business rules, ethics, and applicable local, state, and federal laws.

Compensation

• Posted salary range is USD 65,000–94,600 per year; total compensation may vary based on location, skills, experience, and capabilities.
• The position may be eligible for bonus or commissions.

Benefits and time off

• Benefits include medical, dental, vision, life, and disability insurance, and participation in the 401(k) plan with employer contributions where applicable.
• Exempt employees receive flexible paid time off, eight standard company holidays, and three floating holidays annually, subject to first-year proration and company policy.