Data Engineer / Sr Data Engineer

Job Description
Amazing Career Moments Happen Here
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.
Position Overview
We're seeking a Data Engineer / Senior 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.
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

And we'd be looking for senior level team members to additionally:

• Support delivery by sharing comprehensive feedback in code reviews and guidance about alignment with standards when solving complex problems
• 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
• Share advanced knowledge prior experience building data infrastructure and managing unstructured data
• Support with continuous improvement of internal processes and documentation to champion a principles-based approaches to design, implementation, and testing.

We're Excited to Learn More About You
The position could be an excellent match for a Data Engineer with:

• 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
• 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
  • We proudly support and encourage people with military experience, as well as military spouses, to apply

At the senior level, we'd be looking for:

• 8+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
• Proven impact 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
• Advanced knowledge of SQL and Python with the proven ability 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

When You Join Team Applied, You Can Expect:
A culture that values who you are and recognizes that you aren't just an employee; you are a teammate, and you matter. We thrive on the benefits of our different experiences and celebrate the uniqueness our teammates bring to work with them every day.
We flex our time together , collaborating remotely and in-person to empower our teams to work in the ways that work best for them.
A comprehensive benefits and compensation package that centers our teammates and helps them to bring their best to work every day:

• Medical, Dental, and Vision Coverage

• Holiday and Vacation Time

• Health & Wellness Days

• A Bonus Day for Your Birthday

Learn more about the people behind our products at https://www1.appliedsystems.com/en-us/about-us/jobs/
Our targeted starting base salary in the United States for this position ranges from $60,000 - $160,000. To determine a new team member's starting pay, we consider a variety of factors, including someone's depth, breadth, and variety of experience, skills, and responsibilities. Depending on the role, team members may also be eligible to participate in additional compensation plans such as bonus and commission.
Your Security Matters:
Our candidates' personal information and online safety are top of mind for us. At Applied, we proactively protect your personal information and only communicate with candidates via a secure @appliedsystems.com email or through our official careers portal. Recruiters will never request payments, ask for financial account information or sensitive information like social security numbers.
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