Data Engineer / Sr. Data Engineer (Big Query)
About the role
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.
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, leveraging 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
Requirements
- 3+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
- Proficiency in SQL and Python to manipulate, store, manage, or retrieve data assets
- Demonstrated analytical and problem-solving skills and detail orientation
- Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience
Qualifications
- For Data Engineer: Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience
- For Senior Data Engineer: 8+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
- Advanced knowledge of data modeling, data warehousing, and big data architecture
- Experience managing and optimizing BigQuery and Google Cloud Platform data services
- Advanced knowledge of SQL and Python with the proven ability 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
- Knowledge of data sharing frameworks and governance best practices, including data privacy, security, and compliance standards
- Experience in optimizing cloud-based data solutions for cost efficiency, including monitoring and managing resource usage in BigQuery and GCP
Skills
- Expertise in SQL and Python
- Knowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence
- Ability to communicate with global team members
- Advanced analytical and problem-solving skills
- Knowledge of data sharing frameworks and governance best practices
- Experience in optimizing cloud-based data solutions for cost efficiency
Benefits
We offer a comprehensive benefits package including medical, dental, and vision coverage, holiday and vacation time, health & wellness days, a bonus day for your birthday, and a variety of incentive compensation programs. Base salary ranges from $70,000–$130,000 for a Data Engineer and $100,000–$160,000 for a Senior Data Engineer. Actual starting compensation is determined based on a variety of factors, including a candidate's experience, skills, qualifications, and the scope and responsibilities of the role.
Pay
The anticipated base salary range for this position in the United States is $70,000–$130,000 for a Data Engineer and $100,000–$160,000 for a Senior Data Engineer. Actual starting compensation will be determined based on a variety of factors, including a candidate's experience, skills, qualifications, and the scope and responsibilities of the role.
Schedule
Details on the schedule will be provided during the interview process.