Note: The job is a remote job and is open to candidates in USA. SelectQuote Insurance Services helps consumers find insurance products through a quick and easy process. The Data Engineer III develops and maintains data engineering solutions, leads complex projects and process improvements within Enterprise Analytics, and mentors junior engineers while ensuring data integrity and business value.
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
- 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
- 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 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
- 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
- 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
- Experience working with C# or other statically typed languages is a plus
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
Company Overview