Data Engineer II

Confirmed live in the last 24 hours

Locations

Woodridge, IL, USA

Experience Level

Entry

Junior

Mid

Senior

Expert

Desired Skills

Data Analysis

Hadoop

Java

MongoDB

MySQL

SQL

Tableau

Python

NoSQL

Requirements

A Bachelor's degree in Computer Science, or a related degree
3+ years of experience in a database administration role (SQL or MySQL)
Proficient at developing T-SQL procedures
Experience with performance tuning and optimization
Experience with data transfer with SFTP, file compression and encryption
Knowledge of high availability and disaster recovery for SQL Server
Excellent verbal and written communication skills
Experience working with engineers in a highly technical environment
Knowledge of data archiving techniques, preferred
Experience with data visualization tools (e.g., Tableau), preferred
Experience with NoSQL technology, such as MongoDB and Hadoop, preferred
Experience with other programming/scripting languages, such as Java, Python, preferred
Familiarity with machine learning methods and techniques, preferred

Responsibilities

Develop, construct, test, and maintain data architectures to align with business requirements provided by clients including creating data tables and partitions
Write code in Python to perform data transformations and maintain automate systems
Create and deploy sophisticated analytics programs utilizing machine learning and other statistical methods for data analysis to resolve internal and customer requests
Develop data set processes for automation and report generation
Refine and automate other processes, track issues, troubleshoot, and document changes
Identify methods to improve data reliability, efficiency, and quality
Prepare and clean data for predictive and prescriptive modeling
Configure, monitor, and maintain database servers and processes
Assist software engineers with query tuning and schema refinement
Provide occasional on-call support for critical production systems
Present project status updates and insights to stakeholders based on analytics in weekly team meetings

Who You Are

Interested in building a data transformation layer into the architecture of a product to aggregate and calculate items more efficiently?

As a Data Engineer, you will support and maintain the infrastructure that blends our Call Detail Record (CDR) system’s data with customer data for key clients. You’ll focus on data aggregation and transformation within the context of our overall data pipeline by utilizing machine learning techniques, Python data transformations, and messaging and queueing with Apache Kafka. You would also support a Microsoft SQL Server environment.

#Dice

What You’ll Do

Develop, construct, test, and maintain data architectures to align with business requirements provided by clients including creating data tables and partitions
Write code in Python to perform data transformations and maintain automate systems
Create and deploy sophisticated analytics programs utilizing machine learning and other statistical methods for data analysis to resolve internal and customer requests
Develop data set processes for automation and report generation
Refine and automate other processes, track issues, troubleshoot, and document changes
Identify methods to improve data reliability, efficiency, and quality
Prepare and clean data for predictive and prescriptive modeling
Configure, monitor, and maintain database servers and processes
Assist software engineers with query tuning and schema refinement
Provide occasional on-call support for critical production systems
Present project status updates and insights to stakeholders based on analytics in weekly team meetings

Qualifications - We encourage you to apply if you think your experience may be a match, even if you do not meet all of the qualifications.

A Bachelor’s degree in Computer Science, or a related degree
3+ years of experience in a database administration role (SQL or MySQL)
Proficient at developing T-SQL procedures
Experience with performance tuning and optimization
Experience with data transfer with SFTP, file compression and encryption
Knowledge of high availability and disaster recovery for SQL Server
Excellent verbal and written communication skills
Experience working with engineers in a highly technical environment
Knowledge of data archiving techniques, preferred
Experience with data visualization tools (e.g., Tableau), preferred
Experience with NoSQL technology, such as MongoDB and Hadoop, preferred
Experience with other programming/scripting languages, such as Java, Python, preferred
Familiarity with machine learning methods and techniques, preferred

Who We Are

At Vail, we believe in the unique power of voice interactions to create more expressive, more intimate, and more efficient interpersonal interactions. Using Vail technology, we make millions of voice interactions better every day. We process around 10% of all toll-free call traffic in the U.S; 1 in 10 times when someone calls a customer support hotline Vail is routing or interacting with that call.

We are rapidly growing across multiple dimensions, including our customer base, the scope of products we offer, and the size of our team. Now is the right time for a strong candidate to join and grow with us. We have a supportive culture where employees are encouraged to achieve both personal and team goals because we believe growth leads to both business impact and personal fulfillment.

We offer competitive compensation and affordable benefits with flexibility and choice to meet individual and family (including Domestic Partnerships) needs including:

· Multiple medical, dental, and vision plan options

· Company-paid life insurance, short and long-term disability

· 401(k) savings plan with company match (50% on first 6% of employee contribution)

· 31 days total annual PTO

· Annual Bonus Program

· Paid maternity and paternity leave

· Relocation allowance

· Employee referral bonus

· Gym membership

· Technical and Professional Development stipend

We are striving to implement and sustain an inclusive and equitable work environment for all employees by sourcing underrepresented groups and continually empowering those individuals within our organization to further enrich Vail’s communication solutions. We recognize that equitable and unique individuals benefit our teams’ problem-solving, innovation and development efforts.

COVID-19

Vail’s offices are located in Deerfield, IL, and Chicago, IL. Interviews and onboarding may be conducted remotely. We are observing a hybrid work arrangement giving employees flexibility to come into the office based on personal, team, and business needs.

51-200 employees

Website

Carrier-grade multi-channel communication solutions provider

Company Overview

At Vail they develop innovative technology to enhance the way people communicate. Their mission is to create business value for their clients and growth opportunities for their employees by developing solutions that inspire people to interact freely and authentically.

Benefits

Health - When you work hard, it’s important to stay healthy. Our competitive benefits package includes medical, dental, and vision insurance options to keep you healthy and happy.
Financial/Savings - We pride ourselves with rewarding great work with great compensation. Plan ahead with our 401(k) Retirement Plan with company match. Take advantage of our pre-tax transit program to save money from parking to train tickets.
Work/Life Balance - With flexible work hours, open workspaces, casual office attire, and employee outings, it’s easy to work hard, play hard, and enjoy a balanced lifestyle.
Vacation - We believe that time away from the office is important, and key to employees’ satisfaction and productivity at work. With a generous accrual of vacation in addition to holidays, our team members can take off the time they need to come back revitalized.
Wellness - We encourage an active lifestyle by providing memberships to gyms near each of our office locations. We also host periodic wellness events and keep our office kitchens stocked with yummy, healthy snacks!
Have Some Fun! - We encourage employees to engage with each other outside of their teams. We sponsor runners in the JP Morgan Chase Corporate Challenge, the annual Vail Ringers softball team, and have a group training for the Chicago Triathalon, as well as host book clubs, hackathons and game nights.

Company Core Values

We cultivate long-term client relationships
We solve business problems with innovative, solution-appropriate technologies
We appreciate individuality, encourage collaboration and foster employee growth