J
JerseySTEMRemote
DATA112: Data Analytics Engineer (MySQL, Looker)
United States of America
Full Time
5 hours ago
No H1BKey skills
PythonSQLRAnalyticsLookerBusiness IntelligenceMySQLSaaSJiraLeadershipTeam LeadershipCollaboration
About this role
JerseySTEM is a mission-driven professional network dedicated to improving access to STEM education for underserved middle school girls in New Jersey. They are seeking a Data Analytics Engineer to focus on data preparation and front-end business intelligence, responsible for writing SQL queries and implementing operational dashboards.
Responsibilities:
- Clean, aggregate, and structure raw operational data related to schools, colleges, and corporate partners
- 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
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
- Familiarity with Python or R for data analysis is advantageous
- Prior experience with structured data research or data documentation is a plus