Data Engineer / Senior Data Engineer (GCP, BigQuery)

Position Overview

Transforming the insurance industry is ambitious, we know. That’s why at Applied, 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. EZLynx is seeking a skilled and motivated Data Engineer to join our growing data team. The ideal candidate will design and implement data pipelines, build efficient ETL processes, and manage our Looker instance to enable data-driven decision-making across the organization. In this role, you will collaborate with cross-functional teams to deliver scalable data solutions that integrate platforms such as SQL Server, BigQuery, and Looker. This is an exciting opportunity for someone passionate about leveraging data to drive business outcomes, solving complex problems, and thriving in a fast-paced, collaborative environment.

Key Responsibilities

• Design, build, and maintain scalable ETL pipelines using cloud-native services (GCP, BigQuery, Pub/Sub, etc.).
• Automate deployment and configuration using Terraform, Helm, and Kubernetes.
• Develop dashboards and tooling around Looker performance metrics.
• Ensure Looker datasets are supported by performant and reliable queries.
• Diagnose and resolve performance issues in dashboards, LookML codebases, Explores, and derived tables.
• Build and maintain CI/CD pipelines for microservices and data workflows.
• Support and maintain custom tools for data processing and orchestration.
• Monitor and troubleshoot data lake operations and cloud resources.
• Design efficient and logical data models aligned with business reporting needs.
• Write complex SQL queries for data extraction, transformation, and reporting.
• Collaborate with data engineers and analysts to deliver high-quality data products.
• At a Senior level, assess opportunities and risks of various solutions to ensure scalability and security while maintaining velocity.
• Enhance data lake operations and optimize complex SQL queries for data extraction, transformation, and reporting.
• Support continuous improvement of internal processes and documentation.
• Share advanced knowledge to mentor and support the growing data team.

Required Qualifications

• Ability to work remotely or from an Applied office.
• 3+ years of experience with Google Big Query for data warehousing.
• Experience with GCP (Pub/Sub, Dataflow, Cloud Functions, IAM).
• Experience in managing Looker environments, including performance metrics and monitoring.
• Experience with CI/CD pipelines and version control systems (e.g., Git).
• Proficiency in SQL, including stored procedures, window functions, and query optimization.
• Expertise in building and maintaining ETL pipelines for processing large datasets.
• Knowledge of data modeling best practices (star/snowflake schemas, normalization).
• Ability to work cross-functionally in an agile, fast-paced environment.
• Experience with scripting languages (Python, Bash, etc.); additional Go experience is a plus.
• Proficiency with Kubernetes, Terraform, and CI/CD tools (GitHub Actions, Jenkins, etc.).
• Familiarity with CDC tools (Debezium, Kafka, etc.) and data lake architecture.

Preferred Qualifications

• 5+ years of additional experience with Google Big Query for data warehousing at a Senior level.
• Proven impact in managing and enhancing Looker environments, with a focus on performance metrics and monitoring.
• Advanced knowledge of SQL and Python with a strong track record in query optimization.
• Demonstrated ability to solve complex challenges by leveraging deep understanding of data lake architectures and technical considerations.
• Military experience or military spouse background is highly valued.

Benefits & Perks

• Benefits: Medical, Dental, and Vision Coverage
• Benefits: Holiday and Vacation Time
• Benefits: Health & Wellness Days
• Benefits: A Bonus Day for Your Birthday