Data Engineer (GCP, BigQuery)

Applied Systems, Inc.; United States; On-site; USD 70,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Coverage

Holiday and Vacation Time

Health & Wellness Days

Bonus Day for Your Birthday

Job summary

Applied Systems is seeking a Data Engineer - GCP, BigQuery to join the AI Engineering – Reporting and Analytics team. You will build data solutions, model data, and maintain large-scale datasets for global teams, collaborating with architects, data scientists, and software engineers.

The role focuses on BigQuery, ANSI SQL, and cloud-based data warehousing, with opportunities to enhance data governance and data quality across ingestion, ETL, and reporting layers.

Qualifications

• 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.

Responsibilities

• Code BigQuery procedures, functions, and other database objects.
• Implement scalable 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, leveraging 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.

Skills

BigQuery

SQL

Python

GCP

Data Modeling

Agile Scrum

Jira

Confluence

Education

Bachelor's degree in Computer Science, MIS, or CIS

Tools

BigQuery

Jira

Confluence

Job description

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

• 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, leveraging 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

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).

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.