Data Engineer II

More than 35 years ago, Select Quote was founded on one core promise:
to help our customers protect the people they value most.We pioneered the way consumers shopped for term life insurance, and now, we also help people find home insurance, auto insurance, senior health insurance and more. Our quick and easy process saves consumers both time and money, and today, more than 2 million families trust us to help them with their insurance needs.

But what truly sets us apart is our people, and the opportunities to grow your career with Select Quote are unmatched.

Responsible for developing data solutions with a strong understanding of data engineering concepts and the ability to apply those concepts broadly across multiple technologies. The Data Engineer II must have the ability to work with business users to help integrate data from multiple sources and technologies and make that data available for use in reporting and system integration.

• This position has no direct supervisory responsibilities.

• Manage existing streaming, batching, and event-based data pipeline solutions while looking for opportunities to improve them.
• Independently translate business requirements into data solutions while maintaining a high level of accuracy and data integrity.
• Independently translates business requirements into technical terms for other team members.
• Collaborate with other team members to consolidate the data landscape to reduce the development time and increase consistency among data engineering solutions.
• Take ownership of complex projects and ensure their complete and accurate execution with an emphasis on delivering business value.
• Recommend changes to project architecture while following architecture guidelines set by senior developers.
• Demonstrate quality for junior team members and can provide guidance as needed.

• Strong analytical skills
• Objectivity and openness to others views, providing solutions and creative input
• Must be able to adjust when there is a shift in priorities
• Excellent communicator with individuals and groups at all levels
• Detail-oriented, organized, and able to manage user expectations
• Good organizational, time management, and listening skills
• Self-motivated and excited to work with different technologies.
• Understanding of ETL concepts and ability to apply those concepts to multiple technologies
• Comfortable working with source control (bitbucket, git, Git Hub)

• Bachelor’s degree in Engineering, Computer Science required
• 4+ years of experience engineering data systems required
• 2+ years with Apache Airflow or equivalent training required
• 2+ years of Python development using advanced modules (e.g., Pandas, Num Py) required
• 2+ years using ETL tools required
• 2+ years of troubleshooting stored procedures and other T-SQL required
• Experience working with external REST APIs required
• Experience with AWS ETL services and concepts (Glue, S3, Lambda, boto3)
• Knowledge of various file formats (e.g., JSON, CSV, Parquet, fixed-width)
• Experience with version control (Git CLI) and CI/CD preferred
• Microsoft SQL Server performance tuning
• Experience working with C# or other statically typed languages is a plus
• Experience with Data Lake development is a plus

• AWS Certified Cloud Practitioner or higher level is preferred
• AWS Certified Data Engineer - Associate is a plus

Work is performed indoors with potential for exposure to safety and health hazards related to office work. Could periodically travel to other office and operational sites. The noise level in the work environment is usually moderate.

Prolonged periods of sitting at a desk and working on a computer.

Service:
We create positive customer experiences.

Entrepreneurship:
We create innovate & take risks.

Leadership:
We build & invest in high-performing teams.

Empowerment:
We embrace a changing environment.

Courage:
We challenge the status quo & drive continuous improvement.

Teamwork:
We help support & celebrate each other.

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required.

At this time Select Quote does not hire applicants who solely possess temporary work visas requiring employer sponsorship of any kind…