Staff Data Engineer (BigQuery, BI)

Job Description

Ivans, a division of Applied Systems, is currently seeking a Staff Data Engineer (BigQuery, BI) to work with the Ivans Architecture and Engineering teams to design and implement scalable data solutions for our growing portfolio of data-driven initiatives. Reporting directly to Architecture leadership, you will contribute to strategy, aligning technical data solutions with business goals and long-term initiatives.

What You’ll Do: 

• Design and implement scalable data pipelines using cloud-native technologies like BigQuery, Cloud Storage, Pub/Sub, and DataFlow.
• Collaborate with Architecture leadership to align data solutions with strategic business goals and long-term initiatives.
• Optimize data infrastructure for performance and reliability, focusing on storage, partitioning, and indexing strategies.
• Support BI product development, with a focus on Looker, while being familiar with other tools like Tableau and PowerBI.
• Work with stakeholders to validate business and technical requirements, ensuring alignment and successful project outcomes.
• Implement data cataloging and governance tools like Dataplex to manage metadata and ensure data integrity.
• Automate and manage data workflows to ensure efficient, reliable data operations.

What You’ll Need to Succeed:

We’re looking for someone who: 

• Can work remotely or from an Applied Systems office

Your experience should include some or all of the following: 

• 7 years of experience as a Data Engineer, with a focus on cloud-based data solutions.
• Experience with BigQuery and cloud-based data warehousing solutions.
• Strong proficiency in SQL and programming languages like Python for data management and manipulation.
• Expertise in data modeling, warehousing concepts, and big data architectures.
• Leadership and mentoring experience
• Practical experience with Infrastructure as Code (IaC) tools, such as Terraform.
• Familiarity with CI/CD processes and Agile methodologies (Scrum or Kanban).
• Experience developing ETL/ELT pipelines and using orchestration tools like DataFlow.
• Familiarity with BI tools such as Looker, Tableau, or PowerBI (Looker experience is a plus).
• Experience with data governance practices and tools like Dataplex for metadata management.
• Self-motivated with a commitment to continuous learning and professional development.
• Ability to work independently while effectively collaborating with stakeholders.

Additionally, you may have:

• Experience in the insurance sector.
• Familiarity with data governance and cataloging best practices.
• Experience working with extremely large and mature datasets, understanding the challenges of optimizing data pipelines, storage, and retrieval in high-scale environments.

• Associate's or Bachelor’s degree in computer science, Information Systems, or equivalent education or work experience
• We proudly support and encourage people with military experience, as well as military spouses, to apply

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 

Applied Systems is the leading global provider of cloud-based software that powers the business of insurance. Recognized as a pioneer in insurance automation and the innovation leader, Applied is the world’s largest agency and brokerage management systems provider, serving customers throughout the United States, Canada, the Republic of Ireland, and the United Kingdom. By automating the insurance lifecycle, Applied’s people and products enable millions of people worldwide to safeguard and protect what matters most.

For 40 years, Applied Systems has led an industry we helped to create with a mission to continuously improve the business of insurance. From partnerships, acquisitions, and insurance innovation initiatives, Applied has focused on efforts to be an indispensable partner in our industry.

It’s an exciting time at Applied. You can do big things here, in an environment that supports creative thinking and bold ideas. Visit http://www.AppliedSystems.com 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. 

 #LI-Remote