Elmwood Park
Job Description ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY’s solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals and health systems, healthcare IT vendors, ambulatory practices, health plans, and other healthcare organizations with cutting-edge technologies and solutions that drive their growth and interoperability strategies. Today, ELLKAY remains true to our core values, building strong partner relationships and offering unparalleled service and support while providing innovative, scalable solutions to the challenges our customers face in today’s data-rich world. ELLKAY's experience, customer-focused approach, and reputation for innovation, speed, and accuracy differentiate ELLKAY as a premier partner for your interoperability needs and data management strategy. Job Description: We are seeking a Snowflake Data Architect with strong experience designing cloud data platforms and building/orchestrating ETL/ELT pipelines. This role will lead end-to-end data architecture on Snowflake, define standards and best practices, and partner with engineering and business teams to deliver scalable, secure, and high-performing data solutions. The ideal candidate is hands-on, comfortable guiding teams, and experienced in modern orchestration and automation practices. Essential Duties & Responsibilities: • Define strategy for legacy system decommissioning, including data extraction, migration, translation, validation, and long-term archival access., • Architect ETL/ELT data pipelines from legacy electronic medical record (EMR/EHR) systems (e.g., Cerner, eClinicalWorks (eCW), NextGen,) including both structured and unstructured content into the LKOasis platform leveraging Snowflake., • Own and architect the Medallion architecture (Bronze/Silver/Gold layers), establishing standards for ingestion, curation, quality, lineage, and consumption-ready datasets., • Build strategy to identify change records (CDC/incrementals) and implement them in a Medallion (Bronze/Silver/Gold) design so downstream tables always reflect the latest changes., • Design, build, and optimize ETL/ELT pipelines for batch and incremental processing., • Orchestrate pipelines using tools such as Airflow, ADF, dbt or similar schedulers/orchestrators., • Establish and enforce best practices for performance and cost optimization (warehouse sizing, workload isolation, clustering, query tuning)., • Implement Snowflake capabilities such as stages, file formats, Snowpipe, Streams/Tasks, stored procedures, and secure data sharing as needed., • Create data quality, testing, and monitoring frameworks (validation checks, SLAs, alerting, incident triage)., • Develop security and governance controls (RBAC, masking policies, row access policies, audit/logging)., • Partner with stakeholders to translate requirements into curated datasets/data products and documentation., • Lead implementation of Snowflake Container Services (SCS) to run and manage containerized workloads that support data ingestion, processing, and platform integrations within Snowflake., • 7+ years of experience in data engineering and/or data architecture, including 3+ years working with Snowflake., • Proven experience building and orchestrating ETL/ELT pipelines in production environments., • Strong expertise in Snowflake architecture and development (SQL, performance tuning, Snowpipe, Streams/Tasks, UDFs/stored procedures)., • Hands-on experience with at least one orchestration/transformation stack. Airflow and/or dbt preferred., • Strong SQL skills and programming experience., • Experience with cloud platforms and storage (AWS S3, Azure ADLS, or GCP GCS)., • Strong understanding of data integration patterns (CDC, incremental loads, semi-structured data like JSON/Parquet)., • Experience implementing data governance and security controls in cloud data platforms., • SnowPro certification (Core or Advanced). ELLKAY offers a comprehensive and competitive benefit package that starts day one! Including: • Medical, Dental, and Vision benefits, • Employer-paid Life and LTD, • 401k w/ matching – once eligibility is met, • Work/life balance, • Paid Volunteer Program, • Flexible working hours, • Generous FTO, • Remote work options, • Employee Discounts, • Working with talented, collaborative, and friendly people who love what they do, • Professional growth within, • Innovation environment At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work. We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business. Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work-life balance to their individual preferences. For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role. While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets. For more information on our company, visit . ELLKAY LLC is a Smoke-Free Workplace. ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.