Data Engineer II

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 companys 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 :

POSITION REQUIREMENTS

Additional Information :

Benefits :

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

Security Responsibilities :

Spring Venture Group is an Equal Opportunity Employer

Remote Work : No

Employment Type : Full-time

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Experience : years

Vacancy : 1