Senior Business Intelligence & Systems 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.
• Work closely with business stakeholders, BI analysts, and other IT teams to understand data requirements and translate them into technical specifications.
• Provide training and support to other team members and end-users on data-related best practices and tools.

Education, Experience, and Systems Requirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of proven experience in data architecture and integration related positions.
• Proven experience in data architecture, data engineering, and data warehousing.
• Proven experience in data integration, ETL processes, reverse ETL processes, and data pipeline development.
• Strong proficiency in SQL and database management systems (SQL Server, Microsoft Fabric, Snowflake, Domo, etc).
• Strong proficiency in ETL and data integration tools (boomi, Jitterbit, Matillion, etc).
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Self-starter with the ability to investigate and understand business requirements, translate them into technical specifications, and implement the required design.

​​​​​​ Personal Attributes

• Must be willing to direct the work of and perform work alongside existing Business Analyst resources in a lean and agile environment
• Demonstrated ability to adapt to changing circumstances and environment, strong analytical, critical thinking and organizational skills, attention to detail and ability to identify and implement process improvement capabilities
• Self-starter, starting, and completing tasks without daily direction
• Ability to collaborate with all stakeholders, design, execute and successfully lead initiatives and projects
• Ability to adapt communication for different stakeholders, and promote continuous improvement

Compensation: This is a full-time, exempt position with a salary range of $120,000 - $150,000 depending upon the candidate's skills and experience.

Midwest Express Clinic is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.

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.