Data Engineer - WellNow Urgent Care

WellNow Urgent Care is here to help our patients get well. Founded in 2011, we have quickly grown, with over 180 locations across New York, Illinois, Indiana, Ohio and Michigan. Putting people at the heart of everything we do we focus on providing the best care for both our patients and our employees. ​

​

WellNow is a part of TAG – The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S. and supports over 20,000 healthcare professionals and team members at more than 1,300 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and AZPetVet. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.​

Job Summary:

The Data Engineer is a key member of WellNow’s Data Operations team.  Their work enables data-driven decision making across the organization by collecting, transforming, and publishing data from various structured or unstructured sources.  They lead by example, building high-performing data pipelines and data stores that are efficient, organized, and reliable.  Their work focuses on creating enterprise data models which are flexible, robust, and highly available while being cost-effective.  They work cross functionally as a solution partner, having daily interactions with internal teams across WellNow as a collaborator and colleague, and on occasion with external parties.  In time, they become subject matter experts regarding WellNow’s data and processes, able to use their expertise to manage multiple projects at once, while making recommendations to ease support issues. 

Responsibilities: 

• Design, develop and monitor large scale data pipelines empowering executive dashboards, operational reporting, and machine learning algorithms 
• Consume and process data from a variety of sources (RDBMS, APIs, FTPs and other cloud storage systems) and file formats (Excel, CSV, XML, JSON, Parquet) 
• Use advanced data modeling skills to design and develop dimension and fact tables supporting a near real-time enterprise data model 
• Create and maintain documentation pertaining to data systems (configurations, test plans, functional specs, etc.) 
• Use consultative skills to better understand and mature customer requirements while identifying and resolving potential design issues 
• Perform duties and responsibilities specific to department functions & activities and any other assigned task by reporting manager 

Qualifications: 

• Bachelor’s degree or higher in Computer Science, Data Science, or related technical discipline 
• Advanced MS SQL Server knowledge (MS SQL Server 2016+ preferred) 
• Development expertise with MS SQL Server Integration Services (SSIS), dbt and Apache Airflow 
• Proficient with cloud data warehousing solutions such as Snowflake or BigQuery. 

What Sets You Apart: 

• Experience in EMR backend systems 
• Expert Microsoft t-SQL development skills 
• Extensive experience using various data modeling techniques (Kimball, Inmon, or Data Vault) 
• Experience migrating on-premises database systems to the cloud 
• Experience in a multicloud environment, with a focus on GCP 

Education:

Bachelor’s degree or higher in Computer Science, Data Science, or related technical discipline

Salary: $110,000-148,000/year