Data Engineer II

Summary

Join Openly's growing data engineering team as a Data Engineer II and contribute to building and enhancing data solutions for our insurance data platform. You will play a crucial role in designing, creating, and maintaining data pipelines and structures, collaborating with various teams to deliver high-quality data. This position requires 1-2 years of data engineering experience, proficiency in SQL, and familiarity with Google Cloud technologies. Openly offers a competitive salary, comprehensive benefits including remote-first culture, paid time off, parental leave, and professional development opportunities. We are committed to providing a compensation package that reflects the responsibilities and the unique expertise you bring to our team. The target salary range is $108,000-$121,500 USD, with a full salary range of $108,000-$162,000 USD.

Requirements

• 1 to 2 years of data engineering and data management experience
• Scripting skills in one or more of the following: Python
• Basic understanding and usage of a development and deployment lifecycle, automated code deployments (CI/CD), code repositories, and code management
• Experience with Google Cloud data store and data orchestration technologies and concepts
• Hands-on experience and understanding of the entire data pipeline architecture: Data replication tools, staging data, data transformation, data movement, and cloud based data platforms
• Understanding of a modern next generation data warehouse platform, such as the Lakehouse and multi-data layered warehouse
• Proficiency with SQL optimization and development
• Ability to understand data architecture and modeling as it relates to business goals and objectives
• Ability to gain an understanding of data requirements, translate them into source to target data mappings, and build a working solution

Responsibilities

• Design, create, and maintain data solutions. This includes data pipelines and data structures
• Work with data users, data science, and business intelligence personnel, to create data solutions to be used in various projects
• Translate concepts to code to enhance our data management frameworks and services to strive towards providing a high quality data product to our data users
• Collaborate with our product, operations, and technology teams to develop and deploy new solutions related to data architecture and data pipelines to enable a best-in-class product for our data users
• Collaborate with teammates to derive design and solution decisions related to architecture, operations, deployment techniques, technologies, policies, processes, etc
• Participate in domain, stand ups, weekly 1:1's, team collaborations, and biweekly retros
• Assist in educating others on different aspects of data (e.g. data management best practices, data pipelining best practices, SQL tuning)
• Build and share your knowledge within the data engineer team and with others in the company (e.g. tech all-hands, tech learning hour, domain meetings, code sync meetings, etc.)

Preferred Qualifications

Experience with terraform

Benefits

• Remote-First Culture
• Competitive Salary & Equity
• Comprehensive Medical, Dental, and Vision Plan Offerings
• Life and disability coverage including voluntary options
• Competitive PTO - 20 days and 11 paid holidays (including floating holidays)  per year under the Company’s vacation and holiday policies
• Parental Leave - up to 8 weeks (320 hours) of paid parental leave based on meeting eligibility requirements
• (Birthing parents may be eligible for additional leave through STD)
• 401K Company Contribution - Openly contributes 3% of the employee's gross income, even if the employee does not contribute
• Work-from-home stipend - We provide a $1,500 allowance to spend on setting up your home workplace
• Annual Professional Development Fund: Each employee has $2,000 in professional development (PD) funds to spend on activities or resources annually
• Be Well Program - Employees receive $50 per month to use towards your overall well-being
• Paid Volunteer Service Hours
• Referral Program and Reward
• Depending on position, Employees generally are eligible for cash incentive compensation, including commissions for sales eligible roles