Sr. Data Engineer

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.