INTERNSHIP DETAILS

Data Analyst Intern

CompanyLockwood Industries, LLC dba Fralock
LocationMilpitas
Work ModeOn Site
PostedJune 16, 2026
Internship Information
Core Responsibilities
The intern will transform large datasets into actionable insights by collaborating with Product, Marketing, and Operations teams. Key tasks include data sourcing, cleansing, writing SQL queries, and designing interactive dashboards in Power BI.
Internship Type
intern
Salary Range
$20 - $24
Company Size
184
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
Fralock designs, develops and manufactures engineered solutions for High Reliability applications. We serve technically advanced OEM's in the Aerospace, Defense, Electronics, Energy, Industrial, Life Science, Medical, Satellite, and Semiconductor Equipment markets. Fralock manufactures CIRLEX® an all-polyimide sheet material, Adhesiveless Laminates, All-Polyimide Laminates, Flexible & Rigid Flex Circuits, Engineered Technical Ceramics, and Specialty Engineered Laminates AS9100D, ISO13485-2016, ISO9001-2015, ITAR compliant, FDA registered ***CIRLEX® is a registered trademark of DUPONT used under license by FRALOCK.
About the Role

Data Analyst Intern 

Full Time + Benefits (Medical, Dental, Vision, 401k with Company Match, PTO)

Job Type: Onsite

Hourly Range: $20.00 - $24.00

Location: Milpitas, CA


Fralock is an engineered solutions provider of specialty components and subassemblies using advanced materials for high reliability, severe environment, and technically challenging applications. We develop and manufacture custom integrated solutions. 

Established in 1967, we are a critical solutions provider to Fortune 500 corporations, government, and targeted OEMs in a variety of industries including Semiconductor Equipment Manufacturing, Medical and Life Science, Aerospace and Defense, Industrial, Electronics, and Energy. Fralock is headquartered in Valencia, CA with manufacturing locations located throughout Northern and Southern California.


VISION

To be recognized by our customers as a leading solutions provider of proprietary engineered advanced materials for high reliability, severe environment, and technically challenging applications.

MISSION

To create value, profitably grow, and share our success with all stakeholders.

CULTURE

  • Respect – We treat others the way they want to be treated.
  • Integrity – We practice a high standard of ethics in our business dealings with customers, employees, and suppliers.
  • Responsiveness – We have a sense of urgency in responding to internal and external requests and work proactively to solve problems.
  • Excellence/Competence – We empower our people to continuously improve and execute high quality work.
  • Teamwork – We work together to achieve Fralock business objectives by communicating at a high level, by listening and having clarity in our expectations of one another.
  • Individual Accountability and Personal Responsibility – We do what we have committed to do when we committed to doing it.
  • Continuous Improvement across all segments of the company


This position requires access to information controlled under the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR), the successful candidate must be a "U.S. person" as defined in the ITAR and EAR (which generally means (i) be a citizen or national of the United States; or (ii) be a lawful permanent resident of the United States; or (iii) have been admitted to the United States as a refugee, or have been granted asylum, as specified under applicable law.


Main Functions

In this role, you will bridge the gap between raw data and business strategy by transforming massive datasets into actionable insights. You will collaborate closely with cross-functional teams (Product, Marketing, and Operations) while gaining hands-on experience with modern data infrastructure, automated pipelines, and cloud databases. This position offers direct mentorship and a potential pathway to full-time career opportunities. Assist operations and Product Management with database inquires, dashboard and report generation. 


Typical Duties

  • Data Sourcing: Collect and aggregate information from databases.
  • Data Cleansing: Standardize raw information, fix errors, eliminate duplicate entries, and validate data integrity.
  • Database Querying: Write efficient SQL code to extract tailored datasets for ad-hoc requests.
  • Dashboard Building: Design interactive data visualizations and reports using Power BI.

Required Skills

  • Spreadsheets: Intermediate to advanced mastery of Microsoft Excel or Google Sheets (e.g., VLOOKUP, Pivot Tables).
  • Database Systems: Fundamental command of relational databases and basic SQL syntax (SELECT, JOINs, Group By).
  • Programming Languages: Familiarity with Python (Pandas, NumPy) or R for script-based analytical tasks.

Preferred Skills

BI Frameworks: Basic navigation and design exposure in visualization applications like Tableau or Power BI.


Education Requirements
Enrolled Student: Pursuing a Bachelor's or Master's degree in Data Science, Statistics, Computer Science, Economics, Mathematics, or Business Analytics.


Experience Requirements
None


Physical Requirements

None


Working Conditions

  • Climate controlled office and production environment.
  • Safety-toed shoes required and other Personal Protective Equipment (PPE), as needed. 


All offers of employment at Fralock are contingent upon clear results of a background check. Background checks may include some or all the following depending on job title and responsibilities:

  • Social Security Verification
  • Prior Employment Verification
  • Criminal History
  • Personal and Professional References
  • Motor Vehicle Records
  • Credit History


Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of a position.


Fralock provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.


Key Skills
Microsoft ExcelGoogle SheetsSQLPythonRPower BITableauData CleansingData SourcingData VisualizationRelational DatabasesPandasNumPy
Categories
Data & AnalyticsTechnologyEngineeringManufacturingScience & Research
Benefits
MedicalDentalVision401k With Company MatchPaid Time Off