TECH212: Data Analytics Engineer (MySQL, Looker)

JerseySTEM, Inc. • ,

3d

About The Position

Moving beyond standard spreadsheet reporting, the Data Analytics Engineer focuses on data preparation and front-end business intelligence. Working within a collaborative team, this role is responsible for writing clean transformation queries to prep raw operational data and implementing high-impact operational dashboards that provide the organization with reliable information.

Requirements

• A genuine passion for educational equity, youth development, and contributing to closing the gender gap in STEM fields.
• FIVE years of industry experience in SaaS or non-profit technical environments.
• Solid proficiency in relational databases and visual analytics platforms (specifically MySQL and Looker Studio).
• Strong mastery of writing, optimization, and troubleshooting of complex SQL queries to manipulate, aggregate, and join disparate data tables.
• A strong analytical mindset with the ability to work effectively in a team environment, turning raw system numbers into clear, readable, and intuitive visual layouts for team leadership.
• Comfortable navigating and utilizing Jira for task tracking and Google Workspace for documentation and collaboration.
• Bachelor’s degree in a quantitative field (Data Analytics, Computer Science, Information Systems, or related discipline) or equivalent practical professional experience.

Nice To Haves

• Familiarity with Python or R for data analysis is advantageous.
• Prior experience with structured data research or data documentation is a plus.

Responsibilities

• Clean, aggregate, and structure raw operational data related to schools, colleges, and corporate partners.
• Consume data from tables managed by the Data Integration team and use SQL or data prep tools to turn them into optimized views for reporting.
• Design, develop, and maintain high-performing dashboards and visual reports using our standard toolset (Looker for now) to identify key trends and patterns.
• Write clean, optimized SQL queries and manage database view configurations to ensure frontend reporting sheets refresh smoothly, rapidly, and accurately.
• Partner with team members to gather operational requirements, translate complex tracking metrics into intuitive layouts, and help drive data-backed organizational decisions.
• Implement rigorous validation checks to ensure dashboard numbers consistently align with actual system records.
• Contribute to internal documentation detailing data processing procedures to maintain team-wide consistency.

Benefits

• Pro-bono (unpaid) positions
• Minimum six-month commitment of approximately six flexible hours per week
• $100 refundable deposit (returned after six months of active membership, exempt for educators, retirees, veterans, interns, and students)

What This Job Offers

• Career Level: Mid Level