Canon Financial Services, Inc.→
2026 Canon Insights Summer Internship - Technology and Computer Science Intern
InternshipHybridFull-time
Location
Melville, NY
Salary
$42k–$42k/yr
Experience
No experience required
Posted
1 day ago
Skills
data validationetl processesdatabase managementbigquerysql serverrpapythonexcel vbaai enhancementsprocess improvement
Job Description
Summary: Canon U.S.A., Inc. is currently hiring for their 2026 Canon Insights Internship Program. The Technology and Computer Science Intern will gain hands-on experience by supporting key projects related to data validation and automation, contributing to Canon's business goals.
Responsibilities:
- You will have the opportunity to gain hands-on work experience by participating in significant work projects that help you learn, develop business skills, and provide a meaningful contribution to Canon's business and goals
- You will be exposed to world-class teams and our business, marketing, and strategy initiatives through training, meetings, presentations, and other planned activities
- You’ll gain marketable skills and knowledge that you’ll need in transitioning into the workforce
- You’ll come to the office 3 days a week and 2 days with the option to work from home (unless a specific business need arises requiring in-office attendance on other days). This position offers a hybrid work schedule on full-time (9 AM – 5 PM) schedule based on a 35-hour work week. Note that work schedules and office reporting requirements may change from time to time based on business needs
- Support the CSAP NASPO Process Improvement initiative by documenting, validating, and automating monthly sales and leasing reporting. The project aims to resolve issues caused by inconsistent data sources and manual ETL (Extract, Transform, Load) processes to ensure accurate commission fee payments and program compliance
- Develop automated validation processes for existing datasets to ensure data integrity and accurate administrative fee calculations
- Update state-specific templates using inconsistent data from various sources (Dealers, CSA, CFS)
- Transfer automation tools to business users and provide necessary documentation
- Establish automations for extracting and cross-checking CSAP/CSMP claim data against current state contracts
- Upload validated data records into established templates
- Create and support automations for various compliance and state reporting initiatives
- Design a long-term plan for the automated updating and validation of claim data
- Finalize standardized templates and automated calculation tools for submission to state entities by established deadlines (e.g., the 5th day of each month)
- Fully document all workflows, codebases, and process enhancements
Required Qualifications:
- An enrolled undergraduate student who is currently a junior and entering their senior year as of Summer 2026, pursuing a Bachelor's degree aligned with the department of interest
- A strong communicator—both written and verbal—with advanced proficiency in Google Workspace (Sheets, Docs, Slides, Chat, Calendar and Drive)
- Brings the ability to thrive as a collaborative team player while also working independently with confidence and enthusiasm
- Currently enrolled undergraduate student majoring in Computer Science, Information Technology, or a related technical field
- Experience with data validation, ETL processes, and database management.(Big Query/SQL Server preferred)
- Proficiency in automation tools (e.g., RPA, Python, or advanced Excel/VBA)
- Strong documentation skills
- Ability to translate complex technical processes for non-technical users
- Detail-oriented with a focus on data accuracy and compliance
Preferred Qualifications:
- Knowledge of AI enhancements for process improvement is a plus (Gemini preferred)
Required Skills: Data validation, ETL processes, Database management, BigQuery, SQL Server, RPA, Python, Excel VBA, AI enhancements, Process improvement
Internship Start Date: Start in 2026 Summer
Benefits: Medical, Dental, Vision, 401(k) Savings Plan, Discretionary profit sharing, Discretionary success sharing, Educational assistance, Recognition programs, Vacation
Benefits
Medical
Dental
Vision
401(k) Savings Plan
Discretionary profit sharing
Discretionary success sharing
Educational assistance
Recognition programs
Vacation