Analytics Engineer

We all know every decision should be driven by data. But what about the data you don’t know? For years, the status quo in data aggregation has lacked visibility, moved slowly, and cost too much. Leaving organizations to make critical decisions, day after day, without the whole picture. Native changes that.

Across 138 countries and counting, our technology connects communities of global smartphone users to source actionable data in real-time, cost
- effectively, and with the visibility you need. So leaders inside organizations, non-profit agencies and governments can now make the best decisions under the best conditions.

With Native organizations win. And communities win, too. People can earn more from their opinions and discoveries. They can influence their cities for the better. And, unlike other data sourcing methods out there, they can do it all with full transparency that the data they’re gathering is going to an organization that values it, and values them.

**Analytics Engineer**

**_
**This position is based in Bogota / Colombia_**

We’re growing rapidly, and we’re searching for an energetic and strategic **Analytics Engineer.**You will be part of a team of highly talented individuals and be responsible for owning and maintaining our data transformation pipelines with the highest standards of quality and best practices. You'll bridge the gap between raw data and business insights, working with both technical and business stakeholders to ensure data reliability and accessibility.

**What You Will Do**

You’ll work in the Data Production & Delivery team, a group of data analysts, and analytics engineers who are responsible for turning our raw data into the insights our customers need to make faster, more effective decisions. Responsibilities include:

- Design, maintain and enhance data pipelines and models
- Design and implement efficient data models and transformation pipelines, primarily using Dataform (or similar tools)
- Maintain and update existing transformations to reflect business and product changes
- Monitor pipeline performance and optimize jobs for reliability and efficiency
- Maintain documentation and version control for pipeline changes
- Ensure data quality and reliability
- Design and implement data quality checks and automated testing for data transformations
- Develop and maintain monitoring systems and data quality metrics to detect and track data anomalies.
- Implement data validation rules and error handling
- Operational Support and Collaboration
- Monitor and troubleshoot pipeline and scheduled job failures; implement corrective actions to ensure accuracy and operational continuity.
- Collaborate with stakeholders to resolve data issues and ensure alignment between data models and evolving business needs
- Perform regular updates and adjustments to product data models based on catalog changes and market dynamics.
- Continuously review and refine transformation processes to uphold data accuracy and operational standards.
- Translate research and requirements into recurring products
- Work with Product and Data Science teams to prototype new data products and capabilities based on your research and/or customer requirements.
- Translate ad hoc research and analysis into scalable, recurring data solutions that deliver long-term value.
- Support efforts to evolve and improve existing data products to better meet customer needs and drive adoption.

**What You Bring Along**
- Fluent in English
- BA/BS degree in Engineering, Computer Science, Mathematics, Statistics, or a related technical field—or equivalent practical experience
- Must have 3-5 years of hands-on experience with SQL, including advanced topics such as complex joins, window functions, subqueries, and query optimization
- Experience with data modeling and transformation tools such as Dataform or dbt
- Familiarity with cloud data warehouses (e.g., BigQuery, Snowflake, Redshift)
- Familiarity with version control systems (Git)
- Proficiency in Python for data analysis, automation, and building data workflows
- Relentless drive to listen, learn, and improve the world around you
- Enjoys bringing order to complexity by structuring and optimizing analytics tasks and requests
- Proactive about documenting and sharing your work to enable team collaboration and growth

**Bonus Points**:

- Experience with a data visualization tools (Google Data Studio, Tableau, Looker, etc)
- General analytics experience, generating client-facing reports, ideally in the commercial sector (ie market research companies, consumer packaged goods vendors, etc)
- Scripting language (such as R or Python), ideally for data analysis and visualization
- Experience with data quality frameworks
- Familiarity working with Google BigQuery and Looker
- You excel in ambiguity and are confident in diving deep to find items of interest in large datasets
- Passion for creating greater transparency in the world, particularly in developing economies
- Passion for s