Data Architect
$140k/y-$160k/y
ELLKAYa day ago
Highlight
HybridFull-timeSenior
Summary
ELLKAY is seeking a Data Architect to join their team in Elmwood Park, NJ. The role involves designing cloud data platforms and building/orchestrating ETL/ELT pipelines on Snowflake.
About the Role
As a Data Architect, you 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. Your responsibilities will include architecting ETL/ELT data pipelines, establishing data quality frameworks, and mentoring data engineers.
About You
Required:
- 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, preferably Airflow and/or dbt.
- 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.
- Strong communication skills and ability to lead cross-functional technical discussions.
Preferred:
- SnowPro certification (Core or Advanced).
- Experience with healthcare technology and software-as-a-service platforms.
Benefits
- Medical, Dental, and Vision benefits
- Employer-paid Life and LTD
- 401k with matching once eligibility is met
- Work/life balance
- Paid Volunteer Program
- Flexible working hours
- Generous FTO
- Remote work options
- Employee Discounts
- Parental Leave
ELLKAY
ELLKAY is a trusted enterprise data management partner, driving innovation and connectivity across the healthcare ecosystem. Since 2002, ELLKAY has empowered hospitals, laboratories, payers, healthcare IT vendors, and more with unmatched data management expertise. With connections to over 58,000 practices and interoperability with 750+ EHR/PM systems across 1,100+ versions, ELLKAY delivers solutions that streamline data exchange, fuel value-based care, and drive smarter decision making. Join us virtually August 5-6 https://ellkayusergroup.ellkay.com/
Elmwood Park, NJ