senior Business Intelligence Developer

About the Company

Provider of urgent and primary care centers for individuals in the Midwest, focused on an affordable approach to delivering urgent and primary care services. The Company’s primary objective is to provide a quality, convenient, and affordable healthcare option, with a commitment to offering a more personal care experience.

Job Summary

Midwest Express Clinic is seeking a Senior Business Intelligence Developer to join our growing team. This is a newly created role and will be an integral part of MEC’s commitment to providing Healthcare with Heart enabling the organization to make data driven decisions and track key metrics across a variety of platforms. The Senior Data Architect is responsible for designing, implementing, and maintaining the data warehouse architecture and data pipelines, integrating data from various source systems into the data warehouse. This role ensures the efficient, accurate, and secure flow of data from various sources into the data warehouse, supporting the organization's data analytics and business intelligence initiatives. This position will work across teams to ensure data integrity and accessibility while collaborating with a team of Business Analysts. The senior Data Architect and must be able to operate and navigate in a fast-paced, highly entrepreneurial environment. This is a hybrid position located in the Chicagoland market.

The successful candidate will be responsible for the following:

• Design and optimize data models and schemas for the data warehouse.
• Implement data warehousing best practices to ensure data quality, performance, and scalability.
• Monitor and tune data warehouse performance, ensuring efficient data storage and retrieval.
• Develop, implement, and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse, as well as from the data warehouse to various target systems.
• Ensure data integrity, accuracy, and consistency during data transfers.
• Troubleshoot and resolve data integration issues promptly.
• Establish and enforce data governance policies and procedures.
• Ensure data security and compliance with relevant regulations and standards.
• Conduct regular audits to ensure data quality and integrity.
• Work closely with business stakeholders, BI analysts, and other IT teams to understand data requirements and translate them into technical specifications.
• Collaborate with data integration specialists to ensure seamless data flow.
• Create and maintain comprehensive documentation for data architectures, ETL processes, and data models.
• Provide training and support to other team members and end-users on data-related best practices and tools.
• Work closely with business stakeholders, BI analysts, and other IT teams to understand data requirements and translate them into technical specifications.

This role has an expected salary range of $135,000

Benefits: Midwest Express Clinic is proud to offer our employees a competitive selection of employer sponsored medical, dental, vision, and short term disability plans that meet the diverse needs of our employees and their families. Employees can also opt into a wide range of voluntary benefit plans including, but not limited to pre-tax spending accounts (FSA, HSA, Dependent Care, and Commuter), life insurance, critical illness, and even pet insurance. We offer a company-sponsored 401K plan, with employer match, to help them plan for a financially secure future. We also believe in the importance of work-life balance, with all full-time employees eligible for Wellness or Paid Time Off benefits.