Data Engineer

Midtown is seeking a Data Engineer to join our world-class team at our Chicago headquarters.

About Our Company

We work at Midtown to inspire people to transform their lives—and we do our job well. Our members stay longer than any other major athletic club chain in North America because we are committed to providing resort-like environments, personal attention, and strong communities at every one of our clubs. We believe all three of those pillars start with attracting and growing rock star talent at every level of our organization.

Who We Want

We are looking for people that share our core values: kind individuals who want to win together, see things as the glass half full, are passionate about helping others, and strive to always be better than yesterday.

The Position

The Data Engineer will be tasked with developing and implementing optimized data pipelines and transforming data from a variety of sources into actionable insights using the Microsoft Azure platform. They will collaborate with other members of the engineering team on data initiatives and ensure data delivery is consistent throughout applications and reports.

The primary responsibilities are:

• Design, implement, test, deploy, and maintain data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into our central data warehouse, and moving data out to applications.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Contribute to the continual improvement of the business’s data platforms through observations and well-researched knowledge. Monitor industry best practices and trends and through acquired knowledge, take advantage of process and system improvement opportunities.
• Build reports and data visualizations, using data from the data warehouse and other sources.
• Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs.

Data Engineering requirements:

• BS in Engineering, Information Technology, or equivalent work experience.
• 1-3 years of expertise designing and developing scalable big data and machine learning products using Azure Databricks and Azure Data Lake Gen2.
• Experience with data integration through APIs, web services, SOAP, and/or REST services using ETL/ELT tools such as SSIS, Azure Data Factory, and Airflow.
• Experience with object-oriented/object function scripting languages: Python, Scala, etc.
• Working knowledge of SQL and experience working with relational databases, query authoring (T-SQL and ANSI SQL) as well as working familiarity with a variety of databases.
• Knowledge of BI tools and experience in report writing using Qlik or similar a plus.
• Fundamental knowledge of agile development methodologies.
• Experience with various collaboration tools: Azure DevOps, JIRA, and/or MS Teams.
• Strong communication and problem-solving skills.
• Eager to work with multiple teams and projects at the same time.

Associate Benefits

• Members of the Midtown team receive:·Complimentary club membership
• Discounts on Midtown products and services
• Access to hundreds of free courses for professional development
• Health insurance for eligible full-time associates (30+ hours a week)
• And more

Salary: Starting at $80K, plus bonus potential. The actual compensation will depend on experience, and/or additional skills you bring to the table.

This job description is intended to describe the general requirements for the position. It is not a complete statement of duties, responsibilities, or requirements. Other duties not listed here may be assigned as necessary to ensure the proper operations of the department.

MIDTOWN is an Equal Opportunity Employer.

This job description is intended to describe the general requirements for the position. It is not a complete statement of duties, responsibilities or requirements. Other duties not listed here may be assigned as necessary to ensure the proper operations of the department.

MIDTOWN is an Equal Opportunity Employer.