Sr. Data Engineer
Applied Systems, Inc.1 month ago
Bengaluru, IndiaSenior
Responsibilities
- 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 for reporting, analytics, and business requirements.
- Apply data modeling practices supporting data quality, governance, performance, usability, and reporting solutions.
- Own YAML-driven SQL deployment manifests and multi-environment, multi-locale rollout logic through GitLab CI/CD pipelines.
- Manage SQL, LookML, and YAML code with Git, including reviews and deployments.
- Improve the full data lifecycle from ingestion and transformation through reporting and analytics.
- Contribute to AI-enabled initiatives involving engineering productivity, data quality, automation, and development workflows.
- Drive scalability, reliability, performance, and security improvements across data platforms.
- Provide technical leadership through code reviews, design discussions, mentoring, and coordination across teams.
Requirements
- 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, cloud-based data warehousing, and large-scale multi-tenant schema design.
- Experience optimizing and managing BigQuery and Google Cloud Platform services.
- Advanced SQL and Python expertise.
- Advanced analytical, troubleshooting, and problem-solving skills.
- Ability to communicate with global team members, clarify requirements, confirm priorities, and deliver within committed timelines.
- Experience with Looker, LookML, or similar BI/reporting platforms is preferred.
- Experience with AI-assisted engineering tools such as Claude AI, Copilot, or similar solutions is preferred.
Benefits
- Flexible collaboration combining remote and in-person work.
- A culture focused on inclusion, individuality, teamwork, and professional development.
- Equal employment opportunity and commitment to diversity and inclusion.
Tech Stack
Categories
Data Engineering
About Applied Systems, Inc.
Applied Systems builds cloud software for property and casualty insurance agencies and brokerages, including agency/broker management systems, quoting/rating tools, analytics, and insurer connectivity. The company sells its platforms on a subscription basis and operates the IVANS data exchange that links agencies with insurance carriers. Founded in 1983 and headquartered in Chicago, it is privately held by Hellman & Friedman and serves markets across North America and the U.K./Ireland.