Data Analyst Intern

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.