IT Product Analyst II

Join Our Team at Duncan Solutions, LLC

Duncan Solutions, LLC, is a full-service transportation management company that focuses on connecting people, technology, and data to make cities more livable and efficient. As a leading provider of parking and tolling management solutions, we support municipal and commercial clients with citation processing, debt collection, DMV registered owner identification, back-office transaction processing, image review, customer service center and customer experience (CX) operations, integrated on-street parking management, and more.

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.

This role will offer $70,000 - $85,000 annually, depending on experience, skills, and location.

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.

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
• Perform other duties as assigned.

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

Duncan Solutions, LLC, offers a professional environment, stability, upward mobility, and a wide breadth of benefits. We offer our full-time regular employees who meet eligibility criteria the following which include:

Medical, Dental, & Vision Insurance

• 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…