Sr. Data Engineer

External Job Ad 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 beneficia l., 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…