DriveWhip is seeking a Senior-Level Backend Software Engineering Services Contractor based in Argentina or Mexico. This role focuses on Analytics Reporting, applying best practices in data modeling, transformation, and testing to deliver quality data to critical customer reporting interfaces.
What You'll Do
- Build and maintain composable data models.
- Optimize SQL query performance and maintain Python APIs for serving data to customers.
- Transform raw data into business insights for critical customer reporting interfaces.
- Build new models and optimize existing ones using SQL and Python.
- Apply software engineering principles like version control and continuous integration to the analytics codebase.
- Expand the data warehouse with clean data ready for analysis.
- Apply advanced data testing strategies to ensure datastores align with expected business logic.
- Implement validation checks and automated testing procedures for data quality.
- Work with stakeholders to define business logic and data expectations.
- Surface insights to stakeholders to drive change in data usage.
- Lead initiatives and problem definition, scoping, design, and planning.
- Build tools and automation to run data infrastructure.
- Manage large-scale data migrations in relational datastores.
What We're Looking For
- 5+ years of experience working with data in a software environment.
- Mastered proficiency in SQL and Python.
- Advanced experience managing business semantic layer tooling, data catalog tooling, and data integrity testing frameworks.
- Experience with DBT implementation and best practices.
- A track record of working autonomously and developing deep domain knowledge of data systems.
- Required Tech Stack: SQL, Python, OLAP datastores, DAG tooling (like Dagster or Airflow), and DBT.
Nice to Have
- Experience with Python API development.
- Experience with GCP services.
- Experience with cloud-based infrastructure (AWS, GCP, Terraform) and document, graph, or schema-less datastores.
Technical Stack
- SQL
- Python
- OLAP datastores
- DAG tooling (like Dagster or Airflow)
- DBT
- GCP services
- AWS
- Terraform
Team & Environment
You will be reporting to the Hiring Manager.
Work Mode
This is a local-country position open to contractors based in Argentina or Mexico.
