Applied Systems

Data Engineer (Data Lake, BigQuery)

Job description

Job Overview

Applied Systems, Inc., a worldwide leader in insurance technology, is currently searching for a Data Engineer (Data Lake, Big Query) to join our Data Lake team. In this role, you will be instrumental in modeling, building, and maintaining data pipelines and architectures. Primarily focusing on Google BigQuery, you will play a key role in developing and optimizing our data architecture, ensuring the efficient handling and accessibility of large-scale datasets.

What You’ll Do

  • Implement scalable and efficient data models within our data lake, with a focus on BigQuery
  • Manage and optimize data storage, partitioning, and indexing 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 data requirements and deliver solutions that align with business objectives.
  • Ensure data integrity and quality by implementing robust data validation and error-handling mechanisms.
  • Participate in the full lifecycle of data management, from ingestion to ETL process, and final reporting layers.
  • Stay current with industry trends and advancements in data engineering and big data technologies.

What You’ll Need To Succeed

  • 5+ years as a data engineer, with a strong focus on BigQuery and cloud-based data warehousing solutions
  • Proficiency in SQL and experience with scripting languages such as Python
  • Strong understanding of data modeling, data warehousing concepts, and big data architectures
  • Experience in managing and optimizing BigQuery and other Google Cloud Platform data services.
  • K nowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence
  • Ability to communicate in a team-oriented environment to clarify requirements and deliver solutions within committed timelines
  • Strong analytical and problem-solving skills, with a detail-oriented mindset
  • Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience

What You’ll Gain

  • Benefits from Day One
    • Health insurance plans, dental, and vision
    • Wellness incentives
    • 401(k) and/or RRSP retirement savings plans with employer match
    • Work-Life Balance
      • Competitive paid vacation time and a free day for your birthday
      • Personal/sick time
      • Paid holidays
      • Flex Time
      • Paid parental leave (U.S. candidates)
      • Volunteer time off
    • Empowering Career Growth and Success – We invest in talent, care about our people and are empowered by the results of our work. We grow our teams from within and give our employees opportunities to advance.
    What We Value

    We strive for excellence at every turn to be the best at what we do. We invest in talent, care about our people and are empowered by the results of our work. We fulfil the promise of insurance – safeguarding and protecting what matters most in people’s lives. And there is no more important job than that.

    Our focus on the workforce, workplace and marketplace gives us a qualified individual in an environment in which they can be productive while we maintain our position in the industry. To help drive that change toward a vibrant, modern workplace, we have employee-driven networks with commonalities in ethnicity, gender, sexual orientation and military status.

    Who We Are

    For more than 35 years, Applied Systems has created innovative technology for the global insurance industry. Today, we are a rapidly growing software leader that is revolutionizing the way agencies and brokerages succeed.

    We are smart and curious people in a tech-first environment that champions bold and powerful thinking. We are transforming a complex industry through digitization, automation, and innovative new partnerships. Together we are driving the industry fearlessly forward.

    It’s an exciting time at Applied. You can do big things here, in an environment that supports creative thinking and bold ideas. Visit for more information on how you can challenge what’s possible.

    EEO Statement

    Applied Systems is proud to be an Equal Employment Opportunity and Affirmative Action 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.

    Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.