IT Product Analyst II - Onsite

WORK LOCATION

This is an onsite position local to our Philadelphia office. Address: 701 Market Street Philadelphia, PA 19106
Please note: Duncan Solutions, LLC, does not provide visa sponsorship now or in the future. Candidates must be legally authorized to work in the United States without current or future sponsorship requirements.

Position Summary

The IT Product Analyst II is a seasoned product professional responsible for configuring, building, testing, deploying, and supporting application platforms throughout their lifecycle, with a strong focus on daily data file validation, reconciliation, and operational accuracy. This role partners closely with product management, development, and operations teams to deliver reliable, scalable, and supportable product capabilities. The IT Product Analyst II applies strong configuration practices, contributes to solution design decisions, and ensures product implementations meet functional, operational, and quality standards.

Essential Duties And Responsibilities

• Data File Monitoring & Reconciliation
• Monitor and review daily files received and sent via secure file transfer (SFTP) and alternatives
• Validate file completeness, accuracy, and timeliness
• Reconcile file data against source systems and control reports
• Investigate, document, and resolve complex data discrepancies that impact downstream systems
• Maintain audit trails and reconciliation documentation
• Application & Product Support
• Perform root-cause analysis and issue resolution
• Provide production support and incident response for business-critical application workflows
• Work with cross-functional teams to resolve defects
• Data Analysis, Reporting & Investigation
• Use PL/SQL queries to create reports and validate data sets
• Identify project populations and investigate workflow issues
• Analyze system outputs to identify trends or anomalies
• Support operational and analytical reporting needs
• ETL & Data Process Support
• Design, create, maintain, and support ETL jobs that enable time-sensitive, high-volume, data processing
• Monitor data processing jobs and troubleshoot failures
• Validate inputs and outputs of automated data processes
• Coordinate fixes or enhancements with technical teams
• Documentation, Testing & Continuous Improvement
• Document processes, procedures, and reconciliation steps
• Participate in functional, integration, and regression testing
• Support system enhancements and configuration changes
• Identify opportunities to improve accuracy, efficiency, and controls

What You’ll Need to Succeed

• Skilled in using excel for data validation, correction, and audits
• Sound analytical and problem-solving skills with the ability to assess systems end-to-end
• Proven ability to translate ambiguous business needs into clear, actionable requirements
• Working knowledge of file import and export processes and query systems
• Strong written and verbal communication skills goals with technical and non-technical audiences
• Experience supporting client implementations or multi-tenant product environments

Education / Experience / Skills

• High School Diploma or GED from an accredited institution
• 3+ years of experience in application configuration or a related IT role
• Preferred Bachelor’s degree in Business, Information Technology, Computer Science, or a related field
• Familiarity with product metrics, KPIs, and value measurement

Physical Demands and Working Conditions

This role is primarily computer-based and may be performed in an office or remote work environment. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

What We Offer

• Professional environment, stability, upward mobility, and a wide breadth of benefits
• Medical, Dental, & Vision Insurance
• Healthcare & Dependent Flexible Spending Accounts (FSA)
• Health Savings Account (HSA) with Employer Contribution
• Company Paid Life and AD&D Insurance
• Company Paid Short- & Long-Term Disability
• Employee Assistance Program (EAP)
• 401(k) with Employer Match (Traditional/Roth/Safe Harbor)
• Paid Time Off
• 10 Company Holidays
• PTO Accrual
• Sick Time Accrual
• Parental Leave
• Jury Duty
• Military Leave
• Bereavement

Other Voluntary Benefits

• Life and AD&D Insurance for Employees/Spouse/Child(ren)
• Critical Illness
• Accident Insurance
• Dependent Care Flexible Spending Account (DCFSA)

Equal Opportunity Employer

Duncan Solutions, LLC is proud to be an Equal Opportunity Employer. We actively encourage applications from everybody. All qualified job applicants will receive consideration without regard to race, color, religion, creed, national origin, aboriginality, genetic information, ancestry, marital status, sex, sexual orientation, gender identity or expression, physical or mental disability, pregnancy, veteran status, age, political affiliation or any other non-merit characteristic. Please visit our website to learn more about us https://www.duncansolutions.com/. To view all of our current job opportunities, please visit https://businessprocessingsolutions.bamboohr.com/careers.