Data Engineer

Midtown Athletic Clubs•Chicago, IL

34d•$80,000•Onsite

About The Position

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.

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.
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.

Nice To Haves

Knowledge of BI tools and experience in report writing using Qlik or similar a plus.

Responsibilities

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.