Lead Analytics Engineer

Role Description

We are currently searching for a Lead Analytics Engineer :

• 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.

Qualifications

• 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."

Requirements

• 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.