Data Engineer / Sr. Data Engineer (Big Query)

Job Description

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 h...