IPmedia

Lead Analytics Engineer

IPmedia

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇧🇷 Brazil

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

MySQLPostgresSQL

About the role

  • Lead the BI team, providing technical guidance, reviewing code, and conducting hands-on learning sessions.
  • Write and optimize complex SQL queries in MySQL 8 (core) and PostgreSQL (new services).
  • Be responsible for critical traffic and product attribution logic, with direct impact on revenue and strategic decisions.
  • Guide decisions on data modeling and structuring, ensuring consistency across dashboards, processes, and analytical layers.
  • Establish best-practice standards for SQL and relational modeling, promoting long-term consistency and quality.
  • Perform pair programming and code reviews, teaching through practice and raising the team's technical level.
  • Work side-by-side with engineering and product, ensuring business decisions are correctly reflected in the data.
  • Present weekly and monthly KPIs clearly and accessibly, ensuring the entire team stays informed about performance and results.

Requirements

  • 5+ years of experience with SQL in production, in systems handling critical or financial data.
  • Deep mastery of indexes, execution plans, partitioning, and query optimization.
  • Strong experience with MySQL and PostgreSQL in production environments.
  • Proven ability to mentor and teach; you will be the team's technical reference.
  • Experience with collaborative Git workflows (branches, pull requests, code review, and script versioning).
  • Solid knowledge of relational data modeling and ensuring consistency across layers.
Benefits
  • Training courses
  • Learning opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLMySQLPostgreSQLquery optimizationrelational data modelingindexesexecution planspartitioningcode reviewspair programming
Soft skills
mentoringteachingtechnical guidancecommunicationcollaborationleadershiporganizational skillspresentation skillsteamworkproblem-solving