Applied Systems ยท 10 hours ago
Data Engineer / Sr Data Engineer (GCP, BigQuery)
United States
Full-time
Remote
Mid, Senior Level
$60K/yr - $160K/yr
3+ years expApplied Systems is transforming the insurance industry by building a team focused on innovative software and services. They are seeking a skilled Data Engineer to design and implement data pipelines, enabling data-driven decision-making across the organization.
InsuranceSoftware
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 other tooling around Looker performance metrics
Ensure Looker datasets are backed by performant and reliable queries
Diagnose and address performance issues in dashboard performance, 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 that align with business reporting needs
Write complex SQL queries for data extraction, transformation, and reporting
Collaborate with data engineers and analysts to deliver reliable, high quality data products
Assess opportunities and risks of various solutions to provide insights and input needed for technical decisions as we continuously build for scalability and security while maintaining high velocity
Enhance data lake operation and optimize complex SQL queries for data extraction, transformation, and reporting
Support continuous improvement of internal processes and documentation as a champion of principles-based approaches to design, implementation, and testing
Share advanced knowledge to support the team as we continue building our data infrastructure over time
Qualification
Required
3+ years of experience with Google Big Query for data warehousing
Experience with GCP (Pub/Sub, Dataflow, Cloud functions, IAM)
Experience in 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, windows functions, and query optimization
Proficiency in building and maintaining ETL pipelines to process 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.); Go experience a plus
Proficiency with Kubernetes, Terraform, CI/CD tools (GitHub Actions, Jenkins, etc.)
Familiarity with CDC tools (Debezium, Kafka, etc.) and data lake architecture
Preferred
5+ years of additional experience with Google Big Query for data warehousing
Proven impact managing and enhancing Looker environments, including performance metrics and monitoring
Advanced knowledge of SQL and Python with the proven ability to optimize queries
Demonstrated ability to address complex problems by proposing solutions based on advanced knowledge of data lake architectures and technical considerations
Benefits
Medical, Dental, and Vision Coverage
Holiday and Vacation Time
Health & Wellness Days
A Bonus Day for Your Birthday
Company
Applied Systems
Applied Systems is a digital insurance agency that provides software for agency management systems.
1001-5000 employees
H1B Sponsorship
Applied Systems has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2023 (3)
2022 (5)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
CapitalGStone Point Capital
2018-10-16Series Unknown
2017-09-11Private Equity
2013-11-26Acquired
Leadership Team
Taylor Rhodes
CEO
Recent News
Life Insurance International
2026-01-11
2025-12-17
Company data provided by crunchbase