Data Engineer III

About Us More than 35 years ago, SelectQuote 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 SelectQuote are unmatched. About the Role Responsible for developing Data Engineering solutions with a strong understanding of data engineering concepts and the ability to apply those concepts broadly across multiple technologies. The Data Engineer III improves processes and methodologies across multiple projects and solutions. The Data Engineer III plays a leadership role within Enterprise Analytics, leading improvement teams to enhance the department's performance and serves as a mentor to junior Data Engineers and colleagues. Supervisory Responsibilities: This position has no direct supervisory responsibilities. Essential Duties and Responsibilities: Maintain existing data engineering solutions while looking for opportunities to improve them. Communicate both business requirements and technical terms with a high degree of understanding. Determine business requirements and create solutions while maintaining a high level of accuracy and data integrity. Collaborate with other team members to consolidate the data landscape to reduce the development time and increase consistency among data engineering solutions. Lead and design complex projects and ensure their complete and accurate execution with an emphasis on delivering business value. Train and coach junior engineers in data engineering best practices. Skills/Abilities: Strong analytical skills Comfortable working with source control (Bitbucket, git, GitHub) Knowledge of different file formats, including but not limited to JSON, CSV, Parquet, and fixed-width Objectivity and openness to others' views, providing solutions and creative input Ability to adjust when there is a shift in priorities Excellent communicator with individuals and groups at all levels within the organization Detail-oriented, organized, and able to manage user expectations Good organizational, time management, and listening skills Self-motivated learner Excited to work with new and different technologies Understanding of data engineering and ETL/ELT concepts with an ability to apply those concepts to multiple technologies Education and Experience: Bachelor’s/Master’s degree in Engineering, Computer Science (or equivalent experience) 6+ years of experience working within Data systems or equivalent training 4+ Years of strong experience troubleshooting stored procedures and other T-SQL code 4+ years of Experience with Airflow or equivalent training 4+ years of experience in Python coding using advanced modules, Pandas, Numpy, and other libraries Experience working with C# or other statically typed languages is a plus Experience working with external REST APIs Microsoft SQL Server 2019 or later Microsoft SQL Server performance tuning Experience with AWS systems and concepts for data engineering, Simple Storage Solutions (S3), Lambda, boto3, SQS/SNS Experience with in-memory databases such as Redis and Elasticache Physical Requirements: 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 office is usually moderate. Prolonged periods of sitting at a desk and working on a computer. SelectQuote Core Values: S ervice: We create positive customer experiences. E ntrepreneurship: We create, innovate & take risks. L eadership: We build & invest in high-performing teams. E mpowerment: We embrace a changing environment. C ourage: We challenge the status quo & drive continuous improvement. T eamwork: 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 SelectQuote does not hire applicants who solely possess temporary work visas requiring employer sponsorship of any kind including but not limited to OPT, H-1B, L-1, O-1, TN, F-1, J-1, E-3, etc.SelectQuote Insurance Services does not discriminate against any applicant for employment, or any employee because of age, color, sex, disability, national origin, race, religion, or veteran status. Our Benefits The Compensation for this position is listed below. Local minimum wage laws apply. This information is posted pursuant to local requirements to provide applicants with information about what they might be eligible to receive. Individual pay decisions will depend on job-related factors such as experience, education, skill, performance, and geographic location where work will be performed. Successful candidates may be able to participate in one or more incentive compensation or short-term incentive plans, which could generate additional earnings in accordance with the terms of each plan. We are proud to offer the following benefits: Competitive Medical, Dental, and Vision Insurance HSA/FSA Voluntary Hospital Indemnity, Critical Illness, Accident Insurance, and Short Term Disability Voluntary Life Insurance for Self, Spouse and Dependent Company-paid Basic Life Insurance and Long Term Disability Retirement plan and Employer match contribution with Profit Share Tuition Reimbursement program Company perks and Discount program Engaging Wellness and Financial Education Resources Employee Assistance Program Incentive Plans Base Salary Minimum $115,000 Base Salary Maximum $130,000