Overview Join Our Team as a Data Engineer at US Anesthesia Partners Are you a passionate Data Engineer ready to make a significant impact in the healthcare industry? At US Anesthesia Partners, we are seeking a dynamic individual to join our team and drive the success of our enterprise data warehouse program. If you have a knack for innovation and a commitment to excellence, this is the opportunity you've been waiting for! Why US Anesthesia Partners? At US Anesthesia Partners, we don't just value data; we thrive on it. Our team is dedicated to leveraging cutting-edge technology to enhance patient care and streamline healthcare operations. Join us, and you'll be part of a forward-thinking company that values collaboration, innovation, and excellence. What We’re Looking For: Our ideal candidate is not just technically proficient but also an exceptional communicator who can bridge the gap between technical teams and business stakeholders. Your Role: Data Engineer As a Data Engineer, you will be at the heart of our data operations, working closely with business analysts and users to transform complex business requirements into technical solutions. Your expertise will guide the design and enhancement of our data models, ensuring optimal performance and scalability. At this time, US Anesthesia Partners does not hire candidates residing in New York, California, Hawaii, or Alaska. Job Highlights Key Responsibilities: + Collaborate with business analysts and users to prioritize and understand user requirements. + Lead technical discussions to shape functional designs and specifications. + Act as a liaison between business users and the EDW development team, translating business needs into technical solutions. + Partner with data warehouse architects to design enhancements that meet client demands. + Design, code, and test new features for our data warehouse, including updates to columns, tables, views, OLAP cubes, etc. + Analyze query performance and optimize queries for development engineers. Qualifications Required Skills & Experience: + Bachelor's Degree in Computer Science, Computer Engineering, Information Technology, or equivalent IT certifications. + Strong analytical skills for solving complex business requirements. + Excellent verbal and written communication skills; a true team player. + Self-starter with outstanding analytical abilities. + 5+ years in healthcare IT with knowledge of US healthcare protocols (CPT, ICD-9/10, HIPAA). + 10+ years of database development experience on both on-premise and cloud platforms (MS SQL Server, Azure Synapse preferred). + 5+ years in designing and supporting enterprise data warehouses. + Advanced SQL and Python skills for writing stored procedures and optimizing query performance. + 3+ years with BI solutions like PowerBI, SSRS, SSAS, SSIS, Tableau. + Experience troubleshooting database issues (duplicate keys, inefficient joins/views). The above job description has been written to indicate the general nature and level of work performed by employees within this classification. It is not written to be inclusive of all duties, responsibilities and qualifications required of employees assigned to this job. US Anesthesia Partners, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, gender identity, sexual orientation, pregnancy, status as a parent, national origin, age, disability (physical or mental), family medical history or genetic information, political affiliation, military service, or other non-merit-based factors. (https://careers-usap.icims.com/jobs/15063/data-engineer/job?mode=apply&apply=yes&in\_iframe=1&hashed=-336089587) Job ID2024-15063 FunctionInformation Technology LocationUS-Remote Employment StatusFull Time