Junior Business / Data Analyst Intern

**About Us:** TDA Magnetics is a U.S.-based manufacturer of high-precision magnetic assemblies and components built with state-of-the-art materials. We deliver innovative magnetic solutions to the aerospace, military, semiconductor, medical, industrial, automotive, transportation, telecommunications, and consumer-goods industries. TDA Magnetics is seeking a Junior Business/Data Analyst intern (3-Month Duration with the possibility of Full-Time Hire subject to performance) to support our Mid-Level Business Analyst within a growing BI/ERP function. **Position Summary:** Supports the Mid-Level Business Analyst by owning the repeatable execution layer (Steps 0–2 Groundwork) of our data operations. This is a strictly execution-focused role: it runs scheduled SQL audits, provides support to our BI tasks, applies master-data cleanup against standards defined by the BA, and surfaces findings to unblock the ERP Implementation Roadmap. By managing first-line ERP ticket triage and report maintenance, this role directly frees up the BA to focus on stakeholder deployment, process validation, and tracking ROI (Steps 3–5\). All output is reviewed and approved by the BA before becoming final. This position will be on-site only (LA County Area). This will be a 3-Month paid internship at 40 hrs/week. Due to ITAR/DFARS/CMMC regulations the role needs a U.S. person (Citizen/Permanent Resident). **Key Responsibilities:** * **Recurring Data Quality Audits**: Run an existing library of SQL audit queries on a weekly cadence to identify missing codes, inventory discrepancies, bin-location errors, etc. Compile findings into a master Data Quality Tracker to raise data-integrity concerns to the BA. * **Master Data Foundation Cleanup**: Execute line-by-line record updates and cleanup in the JobBOSS² ERP system against strict standards defined by the BA to prepare the database for advanced analytics. * **Report \& Repository Maintenance**: Assist with minor visual and formatting updates to existing dashboards, contributing to the core BI repository under direct supervision and approval of the BA. Act as the first line of defense for report-refresh failures across the portfolio of 17 operational BI reports. * **ERP Ticket Triage**: Categorize incoming internal ERP support requests against established taxonomies, resolve simple well-documented data-entry issues, and cleanly escalate complex technical tickets to the Mid-Level Business Analyst. * **Structured Data Collection**: Support the Mid-Level BA in ensuring proper data collection procedures are being followed. Analyze the collected data accordingly (Manufacturing and Operation purposes). * **Documentation Upkeep**: Keep the company Data Dictionary and internal system logs updated as tickets and data-cleanup milestones close, providing the documentation trailing edge necessary for project validation. * **Collaborative Alignment**: Work closely with cross-functional teams under the supervision of the BA to support execution-level tasks for process optimization and business-transformation initiatives. **Skills Profile:** * **Attention to Detail**: High accuracy and comfort handling routine, repetitive data-scrubbing tasks where precision matters (core requirement). * **SQL**: Ability to comfortably read, modify, and run queries using basic joins, filters, and aggregations (core requirement). * **Excel \& Power Query**: High proficiency in Excel, with a foundational understanding of data-transformation (ETL/ELT) workflows (core requirement). * **Power BI Exposure or similar BI Tools**: Basic exposure to Power BI or general business-intelligence tools (optional requirement). * **Python**: Ability to create and run basic Python scripts to support data tasks (optional requirement). * **Systems Comfort**: Adaptability and willingness to learn new software infrastructure (JobBOSS² ERP, Power BI environment, Microsoft Azure) — although no prior ERP experience required (core requirement). * **Professional Capabilities**: Strong organizational and time-management skills with the capacity to manage multiple execution-level priorities and deadlines (core requirement). * **Educational Background**: Ideally suited for a recent graduate or current upper-level student in Computer Science, Data Analytics, Statistics, or a related technical field. Pay: $25\.00 per hour Work Location: In person