Senior Data Engineer - BigQuery, dbt & AWS | Insurtech in Columbus
Career & Market Insight
This is a senior-level data engineering role (4+ years required) at a fintech/insurtech platform managing hundreds of billions in assets — a high-stakes, high-scale environment that is excellent for résumé building.
Compensation benchmark: No salary is disclosed. For a comparable role in Brazil on a PJ basis, market rates for senior data engineers with BigQuery/Airflow/dbt expertise range from BRL 18,000 to BRL 28,000/month. If the role pays in USD (common for U.S.-based clients via PJ), USD 3,500–6,000/month is a reasonable benchmark for this level.
Skills you'll develop:
- Cloud-native data engineering on AWS (S3, Lambda, Redshift, Glue) — extremely in demand globally.
- Modern data stack: BigQuery/Snowflake + dbt — the standard for data-driven companies in 2024–2025.
- Orchestration with Apache Airflow — a core skill in MLOps and data platform teams.
- Mentoring and technical leadership, which supports a path toward Staff or Principal Engineer roles.
Green flags: Fully remote, flexible hours, multiple employment model options, learning resources, and mentoring culture all signal employee-friendly practices. The U.S.-client exposure adds international credibility.
Watch for: No salary transparency is a mild red flag. Clarify whether pay is in BRL or USD and what the PJ rate looks like before committing. The "fast-paced environment" language warrants questions about on-call expectations.
Join a leading U.S.-based technology platform for the life insurance and annuities industry. Through innovative enterprise solutions and data-driven insights, the company simplifies how insurance products are bought, sold, and administered, helping millions of people protect their financial futures.
With a bold, collaborative, and value-driven culture, the company manages hundreds of billions of dollars in assets under administration and partners with more than 100 insurance carriers and thousands of distributors across the market.
Responsibilities
- Design, develop, and optimize complex ETL pipelines that integrate large data sets from various sources.
- Build and maintain high-performance data models using Google BigQuery / Snowflake and DBT for data transformation.
- Develop Python scripts for data ingestion, transformation, and automation.
- Implement and manage data workflows using Apache Airflow for scheduling and orchestration.
- Collaborate with data scientists, analysts, and other stakeholders to ensure data availability, reliability, and performance.
- Troubleshoot and optimize data systems, identify issues, and resolve them proactively.
- Work on cloud-based platforms, particularly AWS, to leverage scalability and storage options for data pipelines.
- Ensure data integrity, consistency, and security across systems.
- Take ownership of end-to-end data engineering tasks while mentoring junior team members.
- Continuously improve processes and technologies for more efficient data processing and delivery.
- Act as a key contributor to developing and supporting complex data architectures.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 4+ years of hands-on experience in Data Engineering or related fields, with a strong background in building and optimizing data pipelines.
- Strong proficiency in Google BigQuery, including designing and optimizing queries, or equivalent data warehouse (Snowflake).
- Knowledge of dbt for data transformation and model management.
- Proficiency in Python for data engineering tasks, including scripting, data manipulation, and automation.
- Solid experience with Apache Airflow for workflow orchestration and task automation.
- Extensive experience in building and maintaining ETL pipelines.
- Familiarity with cloud platforms, particularly AWS (Amazon Web Services), including tools like S3, Lambda, Redshift, or Glue.
- Excellent problem-solving and troubleshooting abilities.
- Strong communication and collaboration skills with the ability to work effectively in a team environment.
- Self-motivated, detail-oriented, and able to work with minimal supervision.
- Ability to manage multiple priorities and deadlines in a fast-paced environment.
- Experience with other cloud platforms (e.g., Azure) is a plus.
- Knowledge of data warehousing best practices and architecture.
Benefits
- Your pick when it comes to employment models: CLT / PJ / Cooperativa.
- Resources to grow and learn on the job, including online courses, mentoring, and the latest gen laptops.
- A fully remote work environment with flexible working hours.
- Bonus for any referrals that we end up hiring.