Data Engineer II

Data Engineer II

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.

• 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) retirement savings plan with company match every pay period (50% on first 6% of employee contribution) 
• 30 days PTO 
• Annual Bonus Program  
• Paid maternity and paternity leave 
• Relocation allowance 
• Employee referral bonus 
• Gym membership 
• Access to LinkedIn Learning  

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. We will continue to interview and onboard employees remotely during this unprecedented time. We are not requiring employees to come into our offices at this time. Once the pandemic ends, we will observe a hybrid work arrangement giving employees continued flexibility to come into the office based on personal, team, and business needs.


#Dice