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.
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.
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
If you are an applicant residing in California, please view our privacy policy here:
https://careers.aspendental.com/us/en/tag-privacy-policy-for-california-employees
