Lead ETL Developer at Envoy Global

| Chicago
Sorry, this job was removed at 1:41 p.m. (CST) on Wednesday, February 24, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Please send resumes to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Envoy Global is on a mission to disrupt the global immigration process. Our patented online platform integrates the best of people and technology to streamline, simplify and expedite the immigration process for employers and individuals.

Working alongside our affiliated law firms, we are giving companies the tools they need to hire the best talent from around the world, send talent where it’s needed, and help support foreign workers and immigrants throughout the process. We’re a fast‐growing, award‐winning technology company, a leader in our space, and are backed by some of the country’s leading venture capital and growth equity firms.

This role intersects data engineering and data security to provide data solutions to internal stakeholders and customers. The person in this role will work closely Data Architect, BI & Analytics team and Engineering teams to deliver data assets for Data Security, DW and Analytics.

This position will be based in Chicago, but Envoy Global is currently operating in a remote capacity until at least April 2021. 

Responsibilities and Duties

  • Lead, design, build, test and maintain cloud-based data structures such as data marts, data warehouses and data pipelines.
  • Lead, design, build, test and maintain cloud-based data pipelines to acquire, profile, cleanse, consolidate, transform, integrate data
  • Lead, design and develop ETL processes for the Data Warehouse lifecycle (staging of data, ODS data integration, EDW and data marts) and Data Security (Data archival, Data obfuscation, etc.).
  • Build complex SQL queries on large datasets and performance tune as needed
  • Design and develop data pipelines and ETL jobs using SSIS
  • Maintain ETL packages and supporting data objects for our growing BI infrastructure
  • Carry out monitoring, tuning, and database performance analysis
  • Facilitate integration of our application with other systems by developing data pipelines
  • Prepare key documentation to support the technical design in technical specifications
  • Collaborate and work alongside with other technical professionals (BI Report developers, Data Analysts, Architect)
  • Mentor and train other ETL staff members in best practices.
  • Identify opportunities for process improvement/optimization; design and implement these improvements as directed
  • Communicate clearly and effectively with stakeholders

Qualifications and Skills

  • Bachelor's in Computer Science or a related field (hands-on experience trumps)
  • 8+ years of experience as a SSIS ETL developer, Data Engineer or a related role
  • Master’s in Management Information Systems or similar
  • Strong ETL experience using SSIS or another equivalent tool
  • Knowledgeable in Data Modeling and Data warehouse concepts
  • Experience working with Azure stack
  • Demonstrated ability to write SQL/TSQL queries to retrieve/modify data
  • Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations
  • Ability to work in an Agile environment
  • Ability to learn new tools and technologies and adapt to an evolving tech-scape

Perks & Benefits:  

  • Extremely competitive and robust benefits through BCBS IL including telemedicine and mental health resources, and Principal Dental, Vision coverage 
  • 401k and company match which vests immediately  
  • Annual accrual of 18 days of paid time off (PTO), 2 personal days, and 10 paid holidays per year 
  • 2 paid volunteer days 
  • Paid Parental Leave Program 
  • On demand learning and development courses through LinkedIn Learning 
  • Product and industry training  
  • Stock options after one year of employment 
  • Growing social responsibility programs & partnerships 
  • Opportunity to work for an organization that changes lives every day! 

Recent Community Recognition:  

  • Built in Chicago's 2020 & 2021 Best Places to Work 
  • Chicago Innovation Award Winner 2019 
  • ITA Industry Disrupter Winner 2019

Envoy Global is an equal opportunity employer regardless of race, color, religion, creed, sex, marital status, national origin, disability, age, veteran status, on-the-job injury, sexual orientation, political affiliation or belief. 

EOE AA M/F/Vet/Disability

Read Full Job Description
Please send resumes to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • TypescriptLanguages
    • jQueryLibraries
    • ReactLibraries
    • Entity Framework Libraries
    • Ninject Libraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • MVCFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • SQL AzureDatabases
    • SQL Databases
    • Cosmos DBDatabases
    • SQL Data Warehouse Databases
    • Google AnalyticsAnalytics
    • PowerBI Analytics
    • AxureDesign
    • InVisionDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • WordpressCMS
    • SalesforceCRM
    • OutlookEmail
    • Salesforce Lead Gen

Location

The Loop is a vibrant area with all sorts of eateries, shops & theaters! Plus, the office is easy to get to with various train and bus stops close by.

An Insider's view of Envoy Global

What’s the vibe like in the office?

The vibe in our office is open and welcoming! We have a mixture of people from all over which makes day to day interactions truly enriching. We make sure to get to know one another; rather it be at our monthly All Hands meetings,or grabbing a cup of Cold Brew in the kitchen. Our vibe is to “vibe” with one another & make Envoy one big happy family!

Bri

Office Manager & Executive Assistant

How do you collaborate with other teams in the company?

The marketing team at Envoy gets the opportunity to work with nearly every other team in the company to create exciting content and resources for customers and prospects. Collaborating across sales, product development and other departments really improves the quality of our work and fosters a great culture.

Nidhi M.

Content Marketing Associate

What does career growth look like on your team?

Career growth is about carrying a sense of urgency and accountability at all times. Build your career by finding the opportunity and not waiting for the opportunity to find you. It’s important to drive change amongst your team, company, but most importantly – yourself.

Mike H.

Sales Director

How do your team's ideas influence the company's direction?

Our semimonthly All Hands Meetings allow employees to see how the company is doing and ask questions in real time to members of leadership. One of our core values is our ability to be candid: we have pulse surveys, manager meetings, hackathons, and encourage all employees to bring up questions and suggestions to any member of leadership.

Lindsay Dagiantis

Vice President, HR

What makes someone successful on your team?

At Envoy, success comes in many forms, but the one that stands out is someone being responsive and thorough. We all have great ideas, passionate about the industry, but when it comes down to it, getting the job done quickly and thoroughly allows us to build a great foundation for an even better product and workplace.

Kristina Mossman

Customer Relationship Specialist

What are Envoy Global Perks + Benefits

Envoy Global Benefits Overview

•Convenient Chicago Loop location – 2 blocks from Metra trains and the CTA
•Extremely competitive benefits plan including BCBS medical coverage, including FREE employee dental and vision coverage, and a company-matched 401k plan that vests immediately
•Stock options after one year of employment
•Annual accrual of 18 days of paid time off (PTO), 2 personal days, and 10 paid holidays per year
•Paid Parental Leave Program
•Casual work environment
•In-office company-paid gym membership with LifeStart Gym
•Company sponsored lunches, happy hours, and events throughout the year
•Healthy snacks & unlimited LaCroix
•Monthly Product Lunch & Learns and ongoing Career Development/Training
•Built In Chicago’s 2019 Best Places to Work
•ITA Industry Disrupter Winner 2019
•Chicago Innovation Award Winner 2019
•Growing social responsibility programs & partnerships
•Opportunity to work for an organization that changes lives every day!

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Mean gender pay gap below 10%
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Options Program
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Generous PTO
18 days of PTO + 2 "Floating" days
Paid Volunteer Time
Sabbatical
Envoy offers full-time employees with seven years of continued service the opportunity to take a four-week paid sabbatical.
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

Additional Perks + Benefits

We provide thorough and ongoing training. Highly competitive medical, dental, and vision insurance with an option for PPO or HMO. Regular opportunities to interact with co-workers through social events, intramurals, and collaborative projects. Fully stocked kitchen, including unlimited snacks, coffee, tea, and all of the flavored LaCroix you can handle!

More Jobs at Envoy Global8 open jobs
All Jobs
Data + Analytics
Dev + Engineer
HR + Recruiting
Operations
Product
Sales
Product
new
Chicago
Developer
new
Chicago
Developer
new
Remote
HR + Recruiting
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Please send resumes to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Envoy Global's full profileSee more Envoy Global jobs