Data Engineer / Senior Data Engineer (Remote)

Jobright.ai is an AI-powered career platform that helps you discover verified jobs directly from employer sites across the U.S. and tailor your applications with ease. Please note: Jobright is not a staffing agency and does not hire for these roles directly.Job Summary:Applied Systems is transforming the insurance industry by building innovative software and services. They are seeking a Data Engineer / Senior Data Engineer to develop and enhance data solutions and AI initiatives, collaborating with cross-functional teams to optimize data architecture and ensure data integrity.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 technologiesQualifications:Required:• 8+ 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 experienceCompany:Applied Systems is a digital insurance agency that provides software for agency management systems. Founded in 1980, the company is headquartered in University Park, Illinois, USA, with a team of 1001-5000 employees. The company is currently Late Stage. Applied Systems has a track record of offering H1B sponsorships.