Hybrid Financial Analyst II — Power BI & Excel Expert

Kelly Services; West Point (PA); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401K

Paid time off

Job summary

Kelly Science and Clinical FSP is seeking a Business Analyst II for a long-term engagement with a Global Pharmaceutical client in West Point, PA. The role is hybrid and offers full benefits through Kelly FSP.

The candidate will develop expense models, analyze cost drivers, and deliver data-driven insights using advanced Excel, Power BI DAX, and Power Query. Independent, detail-oriented work in a fast-paced environment is essential.

Qualifications

• Bachelor’s degree in Finance, Business, Supply Chain, Scientific discipline, or related field.
• Minimum of 3 years of experience in financial analysis, business analytics, supply chain analytics, or a related analytical role.
• Advanced proficiency in Microsoft Excel, including formulas, financial modeling, and high-volume data analysis.
• Hands-on experience with Power BI, including DAX coding, Power Query, and data connection management.
• Strong analytical, problem-solving, critical-thinking, and attention-to-detail skills.
• Ability to work independently, manage priorities, and execute detailed work with minimal oversight in a fast-paced environment.
• Effective written and verbal communication skills, with the ability to collaborate across functions, suppliers, and both internal and external stakeholders.
• Preferred experience with SAP ECC, clinical development or manufacturing supply chain, and project management.

Responsibilities

• Support GCS financial processes, expense modeling, forecasting, and variance analysis for business planning and long-range planning.
• Analyze cost drivers, trends, and key variables to improve financial models and support data-driven decision-making.
• Build, maintain, and enhance analytical tools and Power BI reporting solutions, including automation and query-based data connections.
• Support pillar leads, suppliers, relationship managers, OEM leadership, and cross-functional stakeholders to align deliverables with business objectives.
• Support process improvements, what-if scenario planning, and business case development for expense management initiatives.
• Execute tactical and analytical work independently

Skills

Excel proficiency

Power BI

Data analysis

Financial modeling

Communication skills

Education

Bachelor’s degree in Finance or related field

Tools

SAP ECC

Job description

Kelly Science and Clinical FSP is seeking a Business Analyst II for a long-term engagement with a Global Pharmaceutical client in West Point, PA. The role is hybrid and offers full benefits through Kelly FSP.

The candidate will develop expense models, analyze cost drivers, and deliver data-driven insights using advanced Excel, Power BI DAX, and Power Query. Independent, detail-oriented work in a fast-paced environment is essential.