Sr. Data Engineer

Applied Systems; Indiana; Hybrid; USD 130,000 - 190,000; Full time

Job summary

Applied Systems India Pvt Ltd is seeking a Senior Data Engineer to design, build, and optimize data solutions using BigQuery. You will collaborate with Data Scientists and Software Engineers to model, maintain, and scale data across multiple environments and locales, including the US and Canada.

The role emphasizes data governance, security, and scalable analytics. Required are 6–9 years of experience, advanced SQL and Python, and strong cloud data warehouse expertise.

Qualifications

• Bachelor's degree in CS, IT, or related field.
• 6-9 years designing, building, maintaining cloud data solutions.
• Proven BigQuery & cloud data warehousing experience.
• Experience with BigQuery, GCP services and multi-tenant schemas.
• Advanced SQL and Python, scalable data solutions.
• Strong analytical, debugging, and problem-solving skills.
• Able to communicate with global teams; prioritize and deliver on time.
• Nice to have Looker/LookML or similar BI tooling; AI-assisted tooling is a plus.

Responsibilities

• Design, develop, and maintain BigQuery tables, views, and procedures.
• Create scalable data models to support reporting and analytics.
• Apply best practices for data quality, governance, and performance.
• Own deployment manifests and multi-environment rollouts (GitLab CI/CD).
• Collaborate with cross-functional teams to meet business objectives.
• Use Git for code management (SQL, LookML, YAML).
• Contribute to AI-enabled initiatives to improve productivity and quality.
• Lead complex initiatives and coordinate delivery across stakeholders.

Skills

BigQuery

SQL

Python

Looker/LookML

CI/CD (GitLab)

Data modeling

Multi-tenant data architecture

Communication (global teams)

Education

Bachelor's degree in Computer Science or related field

Tools

Looker

LookML

GitLab

Google Cloud Platform

Job description

Amazing Career Moments Happen Here

Transforming the insurance industry is ambitious, we know. That’s why at Applied Systems India Pvt Ltd., an Applied Systems company, we’re building a team that shows up every day ready to learn, willing to try new things, and driven to deliver innovative software and services that make us indispensable to our customers – all within a culture built on values that make us indispensable to each other too. With 40+ years of experience in the Insurtech game, we’re not just redefining what’s achievable, we’re creating a place where amazing career moments are made possible.

Job Description

Amazing Career Moments Happen Here

Transforming the insurance industry is ambitious, we know. That’s why at Applied Systems India Pvt Ltd., an Applied Systems company, we’re building a team that shows up every day ready to learn, willing to try new things, and driven to deliver innovative software and services that make us indispensable to our customers – all within a culture built on values that make us indispensable to each other too. With 40+ years of experience in the Insurtech game, we’re not just redefining what’s achievable, we’re creating a place where amazing career moments are made possible.

Position Overview

We're seeking a skilled Senior Data Engineer to build and enhance data solutions using BigQuery, with exposure to Looker and LookML being beneficial., while supporting data-driven and AI-enabled initiatives within the insurance domain. In this role, you will work closely with the Principal Data Architect, Data Scientists, and Software Engineers to design, build, model, and maintain data solutions. You will help optimize data architecture and improve accessibility of large-scale, multi-tenant datasets across environments (development, staging, production) and locales (US, Canada) for our global teams.

What You Will Do

• Design, develop, and maintain BigQuery tables, views, functions, and stored procedures using BigQuery SQL and ANSI SQL.
• Design and implement scalable data models and data objects to support reporting, analytics, and business requirements.
• Apply data modeling best practices to ensure data quality, governance, performance, and usability across analytics and reporting solutions, including Looker where applicable.
• Own SQL deployment manifests (YAML-driven) and multi-environment/multi-locale rollout logic, ensuring safe and reliable deployments through GitLab CI/CD pipelines.
• Collaborate with cross-functional teams to understand requirements and deliver solutions aligned with business objectives, security requirements, and data governance standards.
• Use Git for SQL, LookML, and YAML code management, reviews, and deployments.
• Contribute to AI-enabled initiatives that improve engineering productivity, data quality, automation, and development workflows.
• Identify and implement improvements across the full data lifecycle, from ingestion and transformation to reporting and analytics layers.
• Provide technical leadership through code reviews, design discussions, and mentoring of team members.
• Drive scalability, reliability, performance, and security improvements across data platforms.
• Lead complex initiatives and coordinate delivery across multiple stakeholders and teams.

What You will Need to Succeed

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 6-9 years of experience designing, building, and maintaining cloud-based data solutions.
• Proven experience with BigQuery and cloud-based data warehousing platforms, including large-scale multi-tenant schema design.
• Experience optimizing and managing BigQuery and Google Cloud Platform services.
• Advanced SQL and Python expertise with a demonstrated ability to design scalable and maintainable data solutions.
• Advanced analytical, troubleshooting, and problem-solving skills.
• Ability to communicate with global team members to clarify requirements, confirm priorities, and deliver solutions within committed timelines.
• Good to have: Experience with Looker, LookML, or similar BI/reporting platforms.
• Experience leveraging AI-assisted engineering tools such as Claude AI, Copilot, or similar solutions to improve productivity, code quality, testing, and development workflows.

When You Join Team Applied, You Can Expect:

A culture that values who you are and recognizes that you aren’t just an employee; you are a teammate, and you matter. We thrive on the benefits of our different experiences and celebrate the uniqueness our teammates bring to work with them every day.

We flex our time together, collaborating remotely and in-person to empower our teams to work in the ways that work best for them.

Learn more about the people behind our products at

• LinkedIn Page Applied Systems India
• https://www1.appliedsystems.com/en-us/about-us/jobs/

Your Security Matters:

Our candidates’ personal information and online safety are top of mind for us. At Applied, we proactively protect your personal information and only communicate with candidates via a secure @appliedsystems.com email or through our official careers’ portal.

EEO Statement

Applied Systems is proud to be an Equal Employment Opportunity Employer. Diversity and Inclusion is a business imperative and is a part of building our brand and reputation. At Applied, we don’t discriminate, and we are committed to recruit, develop, retain, and promote regardless of race, religion, color, national origin, sexual orientation, gender identity, disability, age, veteran status, and other protected status as required by applicable law.