Data Engineer / Sr Data Engineer (GCP, BigQuery)

Applied Systems

  • Snowflake, AZ
  • $60,000-160,000 per year
  • Permanent
  • Full-time
  • 6 hours ago
Job Description:Amazing Career Moments Happen HereTransforming 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 OverviewEZLynx is seeking a skilled and motivated Data Engineer to join our growing data team. The ideal candidate will be responsible for designing and implementing data pipelines, building efficient ETL processes, managing our Looker instance to enable data-driven decision-making across the organization. In this new role, you will work closely with cross-functional teams to deliver scalable data solutions and integrate platforms such as SQL Server, BigQuery, and Looker.This is an exciting opportunity for someone who is passionate about leveraging data to drive business outcomes, enjoys solving complex problems, and thrives in a fast-paced, collaborative environment.What You’ll Do
  • 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
And we’d be looking for a Senior level team member to additionally:
  • 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
We’re Excited to Learn More About YouWe’re looking for someone who:
  • Can work remotely or from an Applied office
The position could be an excellent match for a Data Engineer with:
  • 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
At a Senior level, we’d be also look for:
  • 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
  • We proudly support and encourage people with military experience, as well as military spouses, to apply
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 atOur 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 StatementApplied 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

Applied Systems