Data Engineer

Applied Systems, Inc.

11d•$60,000 - $120,000•Remote

About The Position

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. We're seeking a Data Engineer 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.

Requirements

3+ years focused on modeling, building, and maintaining data solutions
Proven experience with BigQuery and cloud-based data warehousing solutions
Advanced knowledge of data modeling, data warehousing, and big data architecture
Experience managing and optimizing BigQuery and Google Cloud Platform data services
Proficiency in SQL and Python to manipulate, store, manage, or retrieve data assets
Knowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence
Ability to communicate with global team members to clarify requirements, confirm priorities, and deliver solutions within committed timelines
Advanced analytical and problem-solving skills, with a detail-oriented mindset
Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience

Responsibilities

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. Maintain and advocate for these standards through code review
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