Data Engineer at Midtown Athletic Clubs in Chicago, IL

Summary: Midtown Athletic Clubs is seeking a Data Engineer to join their team at their Chicago headquarters. The role involves developing and implementing optimized data pipelines, transforming data into actionable insights, and collaborating with engineering teams to ensure consistent data delivery across applications and reports. 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 Required Qualifications: - 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 - 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 Preferred Qualifications: - Knowledge of BI tools and experience in report writing using Qlik or similar a plus - Fundamental knowledge of agile development methodologies Required Skills: Azure Databricks, Azure Data Lake Gen2, ETL/ELT tools Important Skills: Python, SQL Nice-to-Have Skills: BI tools, Agile methodologies, Collaboration tools Benefits: 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