Data Analyst II

Spectraforce Technologies, Inc.; Plainsboro Township (NJ); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Spectraforce Technologies, Inc. in Plainsboro, NJ is seeking a Data Analyst II to support the Data Strategy Office with documentation, quality control, analytical support, and development.

The role focuses on data governance, ad-hoc analyses for business decisions, and creating analytically ready data sets using Tableau, SQL, Excel, and SAS. Collaboration with stakeholders and a proactive, independent work style are essential.

Qualifications

• Bachelor’s Degree in a quantitative/management field is preferred, experience may substitute.
• 3–5 years of data experience in a commercial domain; pharma experience is a plus.
• Experience managing stakeholders to drive projects forward.
• Strategic and analytical capabilities with the ability to synthesize insights from data.

Responsibilities

• Quality control and standards development for the Data Office.
• Assess, prioritize, and document functional requirements.
• Deliver ad-hoc analyses to support business decisions.
• Develop data governance policies and datasets for analytics use.
• Collaborate with stakeholders to present recommendations and improve data processes.
• Build analytically ready data sets and support data enablement across the organization.

Skills

Tableau

SQL

Analytical thinking

Problem solving

Independent work

Education

Bachelor's degree (quantitative/management)

Tools

Advanced Excel

Alteryx

SAS

Job description

Position Title: Data Analyst II

Work Location: Plainsboro, NJ

Assignment Duration: 12 months

Work Schedule: 8:00 to 4:00, or 9:00 to 5:00

Work Arrangement: Hybrid - 3 days a week in the office

TOP THREE MUST HAVES

1. Tableau and SQL
2. Curiosity and drive to find creative solutions
3. Ability to work independently with high-quality production

Position Summary

Responsible for overall support of the our organization data strategy office including but not limited documentation, quality control, analytical support and development.

Background & Context

Support for the our organization Data Strategy Office focused on documentation, quality control, analytical support, and development.

Key Responsibilities

• Responsible for quality control and standards development in our organization Data Office.
• Assess, prioritize, and document functional requirements.
• Deliver ad-hoc analyses to support business decisions.

Main Job Tasks

Drive Data Governance & Data Enablement

• Quality control to support analytics and reporting.
• Develop understanding of key business questions to be answered in each project.
• Leverage analytical skills to collect, clean, quality control, integrate and analyze data - including sales, marketing & cost data.
• Ensure project documentation is maintained; all governance policies and procedures are followed. Support creation of new data governance policies.
• Develop and present recommendations to key stakeholders.
• Be a trusted advisor for the analysis methodology.
• Develop custom analysis with Tableau, Advanced Excel, SAS, PowerPoint, Access; SQL.
• Help build a center of excellence for creating analytically ready data sets, for use among analytics community.
• Ensure detailed data quality checks are performed on an ongoing basis to ensure analytical readiness.
• Assemble large, complex data sets that meet functional / non-functional business requirements & Identify, design, and implement internal process improvements, automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Acquiring data from primary or secondary data sources and maintaining databases & provide guidance and support on the data set, identify areas requiring process improvements to standardize data governance.

Deliver ad-hoc analyses to support decision making

• Aware of persistency and adherence metrics, knowledge of analytics on de-identified patient level data.
• Ensure superior customer satisfaction by delivering high end quality support to the stakeholders.
• Collaborate closely with stakeholders to look at feedback and development opportunities.

Qualification & Experience

Education:

• Bachelors Degree (preferably within quantitative/management discipline) preferred, solid relevant experience may be substituted for degree requirements if appropriate.

Experience:

• 3-5 years of experience working with data in the commercial domain, experience in pharmaceutical industry is preferred.
• Experience managing stakeholders to drive projects forward.
• Strategic and analytical capabilities, with experience in analyzing complex situations, collecting data and effectively synthesizing insights.
• Project management and relationship building skills to overcome complex and multidimensional business challenges.
• Technical skills - Tableau Advanced Excel, Alteryx a plus.
• Experience in SQL and complex Query.
• Working level knowledge of SAS a plus.

Personal Skills:

• Ability to think strategically and look beyond the data, data storytelling.
• Strong analytical and problem-solving skills.
• High motivation and proactivity.
• Strong written and oral communication skills.
• Attention to detail and focus on quality.
• Excellent interpersonal skills, with the ability to develop strong working relationships and effectively influence stakeholders across all levels of the business.
• High degree of flexibility, as the nature & timing of assignments change according to business requirements.