Lead Analytics Engineer

Posted 21 Days Ago
Be an Early Applicant
Hiring Remotely in México
Remote
Senior level
Information Technology • Consulting
The Role
Lead design and governance of KPIs and semantic layers. Deliver advanced SQL performance tuning across RDS/Oracle/Redshift and cost-efficient Athena queries. Use Python for reproducible analyses, automation, and data validation. Define data quality expectations, implement automated checks and anomaly detection, perform deep-dive analyses, and maintain source-to-target mappings. Improve query performance and establish version control and peer-review practices for analytics assets.
Summary Generated by Built In
Description

...eligible for the visa application process.At Sequoia Connect, we are a Talent-First Technology Ecosystem that redefines how elite professionals interact with the global digital landscape. We move beyond traditional models to act as a catalyst for the top 1% of global talent, connecting human potential with complex industrial execution. By joining our inner circle, you are not simply taking a position; you are aligning with a strategic partner dedicated to updating your "Human OS" and accelerating your growth through world-class, high-impact projects.

We are currently partnering with a rapidly growing, automation-led powerhouse that serves 31 Fortune 500 companies across the financial, healthcare, and manufacturing sectors. With a global workforce of over 32,000 employees and a presence in 28 countries, our client is a titan of digital transformation. Their "Automate Everything, Cloudify Everything" strategy ensures you will be working at the absolute forefront of AI-driven automation and cloud solutions.

This is your chance to thrive in a "Customer Success, First and Always" environment that prizes continuous learning and radical ownership. You will collaborate within an international network of expertise across 39 delivery centers worldwide, gaining exposure to complex engineering challenges that redefine industrial standards. If you are a driven professional looking for a dynamic, forward-thinking workplace where your growth is the priority, this is where you belong.

We are currently searching for a Lead Analytics Engineer:

The Challenge (Responsibilities)

  • Lead the design and governance of core KPIs, metric definitions, and semantic layers for Our Client.
  • Deliver complex analytical work utilizing advanced SQL, focusing on performance tuning across RDS, Oracle, and Redshift, alongside cost-conscious querying in Athena.
  • Utilize Python to create reproducible analyses, automation scripts, and robust data validation checks.
  • Define data quality expectations, implement automated checks and anomaly detection, and triage resolutions collaboratively with engineering teams.
  • Conduct comprehensive deep-dive analyses, cohorting, funneling, forecasting, and experiment design.
  • Create and maintain Source-to-Target Mapping (STTM) documents through tight coordination with upstream and downstream stakeholders.
  • Improve query performance continuously through sort keys, distribution keys, partitioning, predicate pushdown, and compression awareness.
  • Establish strict version control and peer-review processes for analytics assets, contributing to lightweight CI for SQL and tests.

Your Profile (Requirements)

  • Degree holders for the visa application process.
  • Expert-level proficiency in SQL on RDS, Oracle, and Redshift, including deep query tuning and vacuum/analyze awareness.
  • Proven expertise in AWS Athena, specifically regarding partitions, file formats, and cost control strategies.
  • Advanced Business Intelligence (BI) development skills with a strong emphasis on data storytelling and UX best practices for dashboards.
  • Strong Python programming skills focused on analysis, automation, packaging, and the reusability of common analytics functions (light use of pandas, statsmodels, scikit-learn).
  • Solid foundation in statistics tailored for inference and experiment design, with practical application in business contexts.
  • Demonstrated ability to translate complex business needs into robust analytical solutions using collaboration tools like Confluence and Jira.
  • High-Performance Mindset: Resilience, emotional intelligence, and a focus on agile delivery.
  • Technologist DNA: A deep understanding of the difference between "coding" and "engineering."

Desired

  • Experience with advanced modeling tools and the governance of analytics layers.
  • Familiarity with AWS Glue Data Catalog, IAM basics for data access, and S3 file formats (Parquet/ORC).
  • Exposure to event-based data architectures (Kinesis, SNS, SQS) and data freshness SLAs.
  • Ability to build scalable, reusable dashboards and data models in QuickSight or Tableau while enforcing consistency and naming standards.
  • Familiarity with cloud-native foundations or AI coding assistants, such as GitHub Copilot or similar tools for code productivity.

Languages

  • Advanced Oral English: For seamless collaboration with global teams.
  • Advanced Spanish.

Special Notes

  • This position requires close alignment with various data stakeholders to drive business-critical analytics.

Work Arrangement

We value flexibility to support your lifestyle. This position is available as:

  • Remote

If you meet these qualifications and are pursuing new challenges, start your application on our website to join an award-winning employer. Explore all our job openings | Sequoia Career’s Page: https://www.sequoia-connect.com/careers/

Requirements
  • Expert SQL on RDS/Oracle/Redshift (query tuning, vacuum/analyze awareness) and Athena (partitions, file formats, cost control).
  • Advanced BI development and data storytelling; strong UX best practices for dashboards.
  • Python for analysis and automation; packaging and reusability of common analytics functions.
  • Solid statistics for inference and experiment design; practical application in business contexts.
  • Collaboration tools (Confluence/Jira), stakeholder management, and ability to translate business needs into robust analytical solutions.

Skills Required

  • Degree holder (required for visa application process)
  • Expert-level SQL on RDS, Oracle, Redshift including deep query tuning and vacuum/analyze awareness
  • Proven expertise in AWS Athena (partitions, file formats, cost control)
  • Advanced BI development skills, data storytelling and UX best practices for dashboards
  • Strong Python for analysis, automation, packaging, and reusable analytics functions (light pandas, statsmodels, scikit-learn)
  • Solid statistics foundation for inference and experiment design with business application
  • Experience using collaboration tools and translating business needs (Confluence, Jira)
  • High-performance mindset, resilience, emotional intelligence, agile delivery focus
  • Technologist DNA: understanding difference between coding and engineering
  • Experience with advanced modeling tools and analytics layer governance
  • Familiarity with AWS Glue Data Catalog, IAM basics, and S3 file formats (Parquet/ORC)
  • Exposure to event-based data architectures (Kinesis, SNS, SQS) and data freshness SLAs
  • Ability to build scalable, reusable dashboards and data models in QuickSight or Tableau with consistent naming standards
  • Familiarity with cloud-native foundations or AI coding assistants (e.g., GitHub Copilot)
  • Advanced oral English and advanced Spanish
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Austin, TX
30 Employees
Year Founded: 2017

What We Do

From Technologist to Technologist. We are the catalysts of digital evolution. Our core expertise lies in connecting Top Technologists with Top Companies through unparalleled IT headhunting solutions. Our international expertise helps businesses of all sizes innovate and succeed. Our clients are global companies with over 100k employees serving 700+ clients in 50+ countries. Rooted in a profound grasp of technology, our premier IT Headhunting Services drive transformative growth for Fortune 500 corporations. We maintain the highest standards of technological innovation to meet global demands.

Similar Jobs

Magna International Logo Magna International

System Engineer (Producto)

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
Ramos, Mexicali, Baja California, MEX
171000 Employees

Flywire Logo Flywire

Operations Associate

Fintech • Payments • Software
Remote or Hybrid
Mexico City, Cuauhtémoc, Mexico City, MEX
1200 Employees

JumpCloud Logo JumpCloud

Support Engineer

Cloud • Information Technology • Security • Software
Easy Apply
In-Office or Remote
México, Ciudad de México, MEX
800 Employees

Magna International Logo Magna International

Supervisor de Producción

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
COA, Coahuila De Zaragoza, MEX
171000 Employees

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account