Data Engineer II at Spring Venture Group

Kansas City, Missouri, United States -

Full Time

Start Date

Immediate

Expiry Date

19 Feb, 26

Salary

0.0

Posted On

21 Nov, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Engineering, SQL, Python, ETL, Data Governance, Database Stability, Data Pipelines, AWS, Collaboration, Documentation, Problem Solving, Stakeholder Engagement, Code Review, Debugging, Data Integrity, Technical Communication

Industry

Insurance

Description

Company Description 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. Job Description 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 II works with a team of engineers of varying levels to design, develop, test, and maintain data applications and programs. The DE II will be expected to work independently when needed to solve moderately complex problems. We are unable to sponsor for this role at anytime, so this includes not being able to consider OPT or EAD candidates or C2C candidates. You must also CURRENTLY be in the Kansas City area. REPORTS TO The Data Engineer II reports to the Manager of Data Management in the Technology Department. ESSENTIAL DUTIES The essential duties for this role include, but are not limited to: Implement changes to existing Data Management systems with respect to data integrity, documentation, and reporting Write advanced Extract, Transform, and Load (ETL) scripts to integrate data of various formats into enterprise data stores. 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 problems Work with Project Managers, Solution Architects, and Software Development teams to produce architected solutions for Company Initiatives on time, on budget, and on value. Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code. Collaborate with more senior engineers on problems of high complexity, and architect solutions to problems of medium complexity, and advise newer engineers on problems of standard 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. Qualifications 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 Bachelor's degree in Computer Science, or a related technical field. 2-4 years of practical production work in Data Engineering. 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. Strong knowledge of the Python programming language. Strong understanding of SQL, databases, & query optimization. Additional Information 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

Responsibilities

The Data Engineer II is responsible for implementing changes to existing Data Management systems, writing advanced ETL scripts, and collaborating with stakeholders to create reliable solutions. They will also monitor database stability and assist with data governance to ensure availability for business-critical systems.