Big Data Lead
Mexico City - Mexico
Job Summary
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 32000 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 Big Data Lead / Data Analyst:
The Challenge (Responsibilities)
- Translate business questions into analyses KPIs and dashboards.
- Query and transform data using SQL against RDS Oracle Amazon Redshift and Athena.
- Perform data profiling and validation on S3/Redshift datasets; escalate data quality issues and partner on resolution.
- Write Python (pandas) for exploratory analysis feature preparation and light automation.
- Optimize queries via appropriate partitioning filters and Redshift/Athena best practices.
- Document logic assumptions and lineage in Confluence; manage work in Jira.
- Create STTM Mapping document by coordinating with upstream/downstream stakeholders.
- Collaborate with data engineers on data requirements schema changes and data freshness SLAs.
- Follow version control practices (Git) for SQL notebooks and dashboard assets.
Your Profile (Requirements)
- 4-5 years of experience as a Data Analyst.
- Strong SQL (CTEs window functions joins query optimization basics).
- Python for analysis (pandas basic visualization) and working with JSON.
- Hands-on experience with Amazon Redshift Athena and S3-based datasets.
- Understanding of dimensional modeling star schemas and partitioned data.
- Requirements gathering stakeholder communication and documentation (Confluence/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
- Basic statistics (A/B testing confidence intervals) Excel/Sheets power-user skills.
- Familiarity with Glue Data Catalog concepts data contracts and data quality checks.
- Build and maintain dashboards in QuickSight (or Tableau/Power BI) with consistent well-documented metrics.
- Familiarity with cloud-native foundations or AI coding assistants.
Languages
- Advanced Oral English: For seamless collaboration with global teams.
- Advanced Spanish.
Special Notes
- N/A
Work Arrangement
We value flexibility to support your lifestyle. This position is available as:
- Remote / Hybrid / On-site (Depending on specific project needs).
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 Careers Page: Requirements:
AWS SQL Python Redshift Athena