Role overview

Qualifications

Advanced SQL mastery with expert-level proficiency in queries, CTEs, window functions, and complex aggregations
Data modeling: proven track record designing scalable schemas for transactional and analytical use cases
Optimization expertise: deep knowledge of database performance tuning and structural improvements
Functional Python: ability to use Python for data exploration and automation tasks

Responsibilities

Define Data Strategy: Architect and implement the long-term data roadmap to transition the organization into a structured, high-performance ecosystem
Schema Design: Design and optimize complex data models for both transactional and analytical use cases
Performance Tuning: Lead database performance tuning and structural improvements to ensure high-speed query execution and system reliability
Cross-Functional Collaboration: Partner with Product, Backend Engineering, and Stakeholders to ensure data schemas support business goals and application UX

Key facts

Remote from: Brazil, Colombia, Argentina, Bolivia, Mexico
Full time
Data Engineer
English

Other skills

Communication
Strategic Thinking
Problem Solving

About the company

In All Media

IT Services & IT Consulting

In All Media is a trailblazing Nearshore Managed Service Provider, laser-focused on Team Augmentation for software development. We craft bespoke, highly specialized teams that effortlessly merge with our client's processes and culture, delivering unparalleled results. Our Austin headquarters anchors our global reach, with a diverse talent pool distributed across the Americas, Europe, and Asia. This allows us to execute our Nearshore model efficiently in all three regions. Since our inception, we have employed an agile, remote, and distributed model, allowing us to tap into the world's finest technical talent, regardless of location, adapting methodologies like SAFe to perfectly align with our client's needs. We source our exceptional talent from Coderfull, our exclusive community boasting over 5,000 rigorously vetted engineers. Our teams are formed and trained within this community, with specialized interest groups focusing on cutting-edge technologies making In All Media a true Community Lead Enterprise. Our Community teams have a proven track record of collaboration, in-depth knowledge of each other's strengths, and exceptional team dynamics. This synergy results in rapid onboarding, heightened productivity, and an unwavering commitment to success. Our teams embrace flexibility and benefit from a thriving community spirit, abundant career growth opportunities, and a stable compensation model. Our proprietary Community Management platform streamlines talent management, empowering them to efficiently handle daily work, career development, and administrative tasks. AI has captivated our community with its potential to revolutionize our industry so we are harnessing AI to augment, not replace, human skills investing heavily in AI tools, training, and partnerships, to increase our team’s productivity and guide our clients toward a future-ready AI adoption strategy. Experience the In All Media difference today.

Company details

IndustryIT Services & IT Consulting

Company size1001 - 5000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

🧭 About Inallmedia.com

Inallmedia.com is a global technology and design firm focused on building impactful digital solutions through remote, distributed teams across LATAM. We partner with international clients across industries, providing long-term technical expertise, product innovation, and team augmentation.

Our teams work on high-scale platforms that require strong engineering ownership, business alignment, and measurable product impact.

🚀 Project Overview (Project Outpost)

You will join a high-visibility initiative focused on maturing the organization's data landscape. The Outpost project is moving from an "evolving" data environment to a structured, high-performance ecosystem.

As a Data Architect, your mission is to solve current structural inconsistencies and define the long-term data strategy. This is not a "maintenance" role; it is an architectural leadership position meant to ensure data is reliable, accessible, and high-quality for both internal operational efficiency and external customer reporting. By improving schema performance and structure, you will directly enable better business decisions and robust application performance.

🔍 Key Responsibilities

Define Data Strategy: Architect and implement the long-term data roadmap to transition the organization into a structured, high-performance ecosystem.
Schema Design: Design and optimize complex data models for both transactional (operational) and analytical use cases.
Performance Tuning: Lead database performance tuning and structural improvements to ensure high-speed query execution and system reliability.
Identify Critical Insights: Use analytical intuition to independently identify business-critical data points and define clear analysis goals.
Standardization: Establish and enforce organizational naming conventions, data governance practices, and structural consistency across the landscape.
Automation: Utilize Python to create automation scripts for data exploration, cleaning, and landscape management.
Cross-Functional Collaboration: Partner with Product, Backend Engineering, and Stakeholders to ensure data schemas support both business goals and application UX.

💡 Must-Have Skills

Advanced SQL Mastery: Expert-level proficiency in query design, CTEs, window functions, and complex aggregations.
Data Modeling: Proven track record of designing scalable schemas for diverse use cases (Transactional vs. Analytical).
Optimization Expertise: Deep knowledge of database performance tuning and structural improvements.
Functional Python: Proficiency in using Python (loops, functions, dictionaries) for data exploration and automation tasks.
Strategic Intuition: The ability to navigate ambiguity and independently identify how data structure impacts business outcomes.
Self-Direction: Proven ability to manage complex data landscapes and architectural shifts without constant supervision.
Fluent English: Strong communication skills for daily collaboration with international stakeholders.

🌟 Nice-to-Have Skills

Cloud Warehousing: Specific experience with Snowflake or similar modern cloud data warehouse environments.
Governance: Experience implementing formal data governance frameworks and metadata management.
ETL/ELT Optimization: Hands-on experience optimizing specific data transformation pipelines to reduce latency.
Modern Data Stack: Familiarity with tools like dbt or Airflow for managing the data lifecycle.
LATAM Experience: Experience working in remote, distributed teams across Latin American time zones.

🌐 Time Zone & Collaboration

The role requires collaboration with teams aligned to Central Time (CT), USA. Candidates must overlap at least 4–5 hours daily with US-based stakeholders to ensure seamless architectural alignment.

#LI