Data Engineer III

Who We Are:
Spring Venture Group is a leading digital direct-to-consumer sales and marketing company with product offerings focused on the senior market. We specialize in distributing Medicare Supplement, Medicare Advantage, and related products via our family of brands and dedicated team of licensed insurance agents. Powered by our unique technologies that combine sophisticated marketing, comparison shopping, sales execution, and customer engagement – we help thousands of seniors across the country navigate the complex world of Medicare every day.

This person has the opportunity to work primarily remote in the Kansas City or surrounding areas, making occasional visits to the office, but must CURRENTLY be in the Kansas City area.

We are unable to sponsor for this role, this includes international students.

OVERVIEW

The Data Management team is responsible for all things data at Spring Venture Group. Most importantly, our team is responsible for constructing high quality datasets that enable our business stakeholders and world-class Analytics department to make data informed decisions. Data engineers, combining Software Engineering and Database Engineering, serve as a primary resource for expertise with writing scripts and SQL queries, monitoring our database stability, and assisting with data governance ensuring availability for business-critical systems. The DE III works with a team of engineers of varying levels to design, develop, test, and maintain software applications and programs. The DE III will be expected to work independently when needed to solve the most complex problems encountered. They will be expected to be a leader and a mentor.

ESSENTIAL DUTIES

The essential duties for this role include, but are not limited to:

• Serve as a primary advisor to Data Engineering Manager to identify and bring attention to opportunities for technical improvements, reduction of technical debt, or automation of repeated tasks.
• Build advanced data pipelines utilizing the medallion architecture to create high quality single source of truth data sources in Snowflake
• Architect replacements of current Data Management systems with respect to all aspects of data governance
• Design advanced services with multiple data pipelines to securely and appropriately store company assets in our enterprise data stores.
• Technically advise any member of the data engineering department, providing direction when multiple paths forward present themselves.
• Actively participate as a leader in regular team meetings, listening and ensuring that one is assisting others at every chance for growth and development.
• Write advanced ETL/ELT scripts where appropriate to integrate data of various formats into enterprise data stores.
• Take ownership (both individually and as part of a team) of services and applications
• Write complex SQL queries, scripts, and stored procedures to reliably and consistently modify data throughout our organization according to business requirements
• Collaborate directly and independently with stakeholders to build familiarity, fully understand their needs, and create custom, modular, and reliable solutions to resolve their requests
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Work with Project Managers, Solution Architects, and Software Development teams to build solutions for Company Initiatives on time, on budget, and on value.
• Independently architect solutions to problems of high complexity, and advise junior and mid-level engineers on problems of medium complexity.
• Create data pipelines using appropriate and applicable technologies from Amazon Web Services (AWS) to serve the specific needs of the business.
• Ensure 99.95% uptime of our company’s services monitoring data anomalies, batch failures, and our support chat for one week per team cycle from 8am-9pm.
• Follow and embrace procedures of both the Data Management team and SVG Software Development Life Cycle (SDLC), including obtaining and retaining IT Security Admin III clearance.
• Support after hours and weekend releases from our internal Software Development teams.
• Actively participate in code review and weekly technicals with another more senior engineer or manager.
• Assist departments with time-critical SQL execution and debug database performance problems.

ROLE COMPETENCIES

The competencies for this role include, but are not limited to:

• Emotional Intelligence
• Drive for Results
• Continuous Improvement
• Communication
• Strategic Thinking
• Teamwork and Collaboration

POSITION REQUIREMENTS

The requirements to fulfill this position are as follows:

• Bachelor's degree in Computer Science, or a related technical field.
• 4-7 years of practical production work in Data Engineering.
• Expertise of the Python programming language.
• Expertise of Snowflake
• Expertise of SQL, databases, & query optimization.
• Must have experience in a large cloud provider such as AWS, Azure, GCP.
• Advanced at reading code independently and understanding its intent.
• Advanced at writing readable, modifiable code that solves business problems.
• Ability to construct reliable and robust data pipelines to support both scheduled and event based workflows.
• Working directly with stakeholders to create solutions.
• Mentoring junior and mid-level engineers on best practices in programming, query optimization, and business tact.

Benefits:

The Company offers the following benefits for this position, subject to applicable eligibility requirements:

• Competitive Compensation
• Medical, Dental and vision benefits after a short waiting period
• 401(k) matching program
• Life Insurance, and Short-term and Long-term Disability Insurance
• Optional enrollment includes HSA/FSA, AD&D, Spousal/Dependent Life Insurance, Travel Assist and Legal Plan
• Generous paid time off (PTO) program starting off at 15 days your first year
• 15 paid Holidays (includes holiday break between Christmas and New Years)
• 10 days of Paid Parental Leave and 5 days of Paid Birth Recovery Leave
• Annual Volunteer Time Off (VTO) and a donation matching program
• Employee Assistance Program (EAP) - health and well-being on and off the job
• Rewards and Recognition
• Diverse, inclusive and welcoming culture
• Training program and ongoing support throughout your Venture Spring Venture Group career  

Security Responsibilities:

• Operating in alignment with policies and standards
• Reporting Security Incidents Completing assigned training
• Protecting assigned organizational assets

Spring Venture Group is an Equal Opportunity Employer