Build, model, and maintain scalable BigQuery-based data solutions on GCP. Implement performant data models, storage partitioning/clustering, ETL improvements, data validation, and documentation. Collaborate with architects, data scientists, and engineers to deliver governed, high-quality data for reporting and AI initiatives.
Job Description
Team: AI Engineering - - Reporting and Analytics
Salary Range: USD 70K- USD 120K
Location: Remote
Opportunity for Impact
Applied is where insurance technology gets reinvented, and we build it fast. Our cloud software and AI-powered solutions reach thousands of agencies and brokers worldwide, setting the pace for what modern insurance can do.
We're looking for a Data Engineer - GCP, BigQuery to join our AI Engineering - Reporting and Analytics team to build and enhance data solutions and AI initiatives for the business of insurance.
In this role, you will work closely with the Principal Data Architect, Data Scientists, and Software Engineers to build, model, and maintain data solutions as we optimize data architecture and accessibility of large-scale datasets for our global teams.
What You'll Do
What We're Looking For
Talent shows up in a lot of different ways, and we mean that. We welcome candidates from all backgrounds and experience levels, including military members and their spouses and those without a traditional degree or tech background. If this role speaks to you, apply.
Why You'll Like Working on Team Applied
The best work happens when smart people move fast, together. For over 40+ years, Applied has built technology that solves real problems for insurance professionals - and we're still pushing what's possible.
You'll be part of our people-first culture built on trust, inclusion, and growth - where you're supported to deliver, collaborate with teammates who care, and grow with leaders invested in your success.
How We'll Support You
We invest in the whole person, not just the role. Our benefits and resources are built to support your health, your time, and your life outside of work:
Compensation Transparency
Our targeted starting base salary in the United States for this position considers a variety of factors, including depth and breadth of experience, skills and role scope. Depending on the role, team members may also be eligible for additional compensation plans (bonus and commission).
Your Security Matters:
Our candidates' personal information and online safety are top of mind. Applied communicates with candidates only via a secure @appliedsystems.com email address or through our official careers' portal. Recruiters will never request payments or ask for financial account or sensitive personal information like Social Security numbers.
AI Utilization
We leverage AI tools to streamline parts of our recruitment workflow (such as resume parsing and interview scheduling). However, final decisions are always conducted by real humans.
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.
#LI-Remote
#LI-US
Team: AI Engineering - - Reporting and Analytics
Salary Range: USD 70K- USD 120K
Location: Remote
Opportunity for Impact
Applied is where insurance technology gets reinvented, and we build it fast. Our cloud software and AI-powered solutions reach thousands of agencies and brokers worldwide, setting the pace for what modern insurance can do.
We're looking for a Data Engineer - GCP, BigQuery to join our AI Engineering - Reporting and Analytics team to build and enhance data solutions and AI initiatives for the business of insurance.
In this role, you will work closely with the Principal Data Architect, Data Scientists, and Software Engineers to build, model, and maintain data solutions as we optimize data architecture and accessibility of large-scale datasets for our global teams.
What You'll Do
- Code BigQuery procedures, functions, and other database objects by applying expert knowledge in BigQuery SQL and ANSI SQL
- Implement scalable and efficient data models within our data lake, with a focus on BigQuery
- Manage and optimize data storage, partitioning, and clustering strategies to ensure high performance and reliability of our data infrastructure
- Develop and implement features and enhancements in BigQuery, levering your expertise in SQL and cloud-based data warehousing technologies
- Collaborate with cross-functional teams to understand requirements and deliver solutions aligned with business objectives, security requirements, and guidelines for data governance
- Develop documentation for the team to support design discussions
- Ensure data integrity and quality by implementing robust data validation and error-handling mechanisms.
- Identify and implement improvements across the full lifecycle of data management, from ingestion to ETL processes and final reporting layers, to increase productivity on the team
- Continuously build knowledge of industry trends and advancements in data engineering and big data technologies
What We're Looking For
- 3+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
- Proficiency in SQL and Python to manipulate, store, manage, or retrieve data assets
- Proven impact with BigQuery and cloud-based data warehousing solutions
- Experience managing and optimizing BigQuery and Google Cloud Platform data services
- Knowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence
- Demonstrated analytical and problem-solving skills and detail orientation
- Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience
Talent shows up in a lot of different ways, and we mean that. We welcome candidates from all backgrounds and experience levels, including military members and their spouses and those without a traditional degree or tech background. If this role speaks to you, apply.
Why You'll Like Working on Team Applied
The best work happens when smart people move fast, together. For over 40+ years, Applied has built technology that solves real problems for insurance professionals - and we're still pushing what's possible.
You'll be part of our people-first culture built on trust, inclusion, and growth - where you're supported to deliver, collaborate with teammates who care, and grow with leaders invested in your success.
How We'll Support You
We invest in the whole person, not just the role. Our benefits and resources are built to support your health, your time, and your life outside of work:
- Medical, Dental, and Vision Coverage
- Holiday and Vacation Time
- Health & Wellness Days
- A Bonus Day for Your Birthday
Compensation Transparency
Our targeted starting base salary in the United States for this position considers a variety of factors, including depth and breadth of experience, skills and role scope. Depending on the role, team members may also be eligible for additional compensation plans (bonus and commission).
Your Security Matters:
Our candidates' personal information and online safety are top of mind. Applied communicates with candidates only via a secure @appliedsystems.com email address or through our official careers' portal. Recruiters will never request payments or ask for financial account or sensitive personal information like Social Security numbers.
AI Utilization
We leverage AI tools to streamline parts of our recruitment workflow (such as resume parsing and interview scheduling). However, final decisions are always conducted by real humans.
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.
#LI-Remote
#LI-US
Similar Jobs at Applied Systems
.png)
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Define and govern enterprise-scale data architecture across batch, streaming, warehouse, lakehouse, transactional, and AI use cases. Establish standards for data quality, lineage, access, cataloging, governance, observability, and SLAs. Architect AI-enabled workflows, resolve complex architecture issues, influence roadmaps, and mentor engineers through hands-on technical leadership. The role requires 15+ years of software, data engineering, or architecture experience and expertise in large-scale data platforms and modeling.
Top Skills:
AIBatch ProcessingBigQueryData CatalogsData WarehousesDbtFeature StoresGCPLakehousesOlapOltpStreaming ArchitecturesVector Stores
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Administer hybrid Windows Server infrastructure across colocation, on-premises, Azure, and GCP environments. Manage virtual machines, cloud resources, patching, upgrades, backups, monitoring, alerts, incident response, vulnerability remediation, and root cause analysis. Develop automation using PowerShell, Python, Ansible, and infrastructure-as-code tools for provisioning, remediation, and self-healing workflows. Maintain documentation and runbooks while collaborating with engineering, IT support, security, and operations teams.
Top Skills:
AnsibleAppdynamicsArm TemplatesBashDatadogEsxiGitlab Ci/CdGoogle Cloud Platform (Gcp)GrafanaAzureNew RelicOpentelemetryPatchmypcPowershellPythonSccmSignozSolarwindsTerraformVcenterVmware VsphereWindows ServerWsus
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Manage assigned customer accounts, driving satisfaction, product adoption, retention, account growth, and advocacy. Responsibilities include resolving customer issues, developing account and strategic success plans, leading quarterly business reviews, analyzing customer health and usage metrics, communicating product feedback, and collaborating with internal teams. The role requires strong communication, presentation, organization, empathy, and creative problem-solving skills, with travel up to 15%.
Top Skills:
Salesforce
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
