ICONMA
Our Client, a Health Insurance company, is looking for a Senior Data Engineer for their Columbia, MD/ Hybrid location.
Responsibilities
Design, develop, and optimize data pipelines and transformations within Snowflake using SQL and Snowpark (Python).
Build and maintain Streams, Tasks, Materialized Views, and Dashboards to enable real-time and scheduled data operations.
Develop and automate CI/CD pipelines for Snowflake deployments (Jenkins).
Collaborate with data architects, analysts, and cloud engineers to design scalable and efficient data models.
Implement data quality, lineage, and governance frameworks aligned with enterprise standards and compliance (e.g., HIPAA, PHI/PII).
Monitor data pipelines for performance, reliability, and cost efficiency; proactively optimize workloads and resource utilization.
Integrate Snowflake with dbt, Kafka for end-to-end orchestration and streaming workflows.
Conduct root cause analysis and troubleshooting for complex data and performance issues in production.
Collaborate across technology and business teams to translate complex data needs into elegant, maintainable solutions.
Requirements
5+ years of experience in data engineering or equivalent field.
3+ years hands‑on experience with Snowflake Data Cloud, including:
Streams, Tasks, Dashboards, and Materialized Views.
Performance tuning, resource monitors, and warehouse optimization.
Strong proficiency in SQL (complex queries, stored procedures, optimization).
Proficiency in Python, with demonstrated experience using Snowpark for data transformations.
Experience building CI/CD pipelines for Snowflake using modern DevOps tooling.
Solid understanding of data modeling methodologies (Kimball, Data Vault, or 3NF).
Experience with data governance, lineage, and metadata tools (Collibra, Alation, or Azure Purview).
Strong troubleshooting, analytical, and communication skills with the ability to engage both technical and business audiences.
Excellent problem‑solving and root‑cause analysis capabilities.
Strong communication and documentation skills across technical and non‑technical audiences.
Proven ability to work collaboratively in Agile or cross‑functional DevOps teams.
A growth mindset with a commitment to continuous learning and process improvement.
Ability to thrive in a fast‑paced, mission‑driven environment supporting critical healthcare data operations.
Preferred
Experience with dbt or Kafka for orchestration and streaming.
Exposure to data quality frameworks such as Great Expectations or Monte Carlo.
Understanding of real‑time and batch data ingestion architectures.
Snowflake Certification (SnowPro Core or Advanced).
Prior experience in healthcare, insurance, or other regulated data environments.
Why Should You Apply?
Health Benefits
Referral Program
Excellent growth and advancement opportunities
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or expression, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
#J-18808-Ljbffr
Responsibilities
Design, develop, and optimize data pipelines and transformations within Snowflake using SQL and Snowpark (Python).
Build and maintain Streams, Tasks, Materialized Views, and Dashboards to enable real-time and scheduled data operations.
Develop and automate CI/CD pipelines for Snowflake deployments (Jenkins).
Collaborate with data architects, analysts, and cloud engineers to design scalable and efficient data models.
Implement data quality, lineage, and governance frameworks aligned with enterprise standards and compliance (e.g., HIPAA, PHI/PII).
Monitor data pipelines for performance, reliability, and cost efficiency; proactively optimize workloads and resource utilization.
Integrate Snowflake with dbt, Kafka for end-to-end orchestration and streaming workflows.
Conduct root cause analysis and troubleshooting for complex data and performance issues in production.
Collaborate across technology and business teams to translate complex data needs into elegant, maintainable solutions.
Requirements
5+ years of experience in data engineering or equivalent field.
3+ years hands‑on experience with Snowflake Data Cloud, including:
Streams, Tasks, Dashboards, and Materialized Views.
Performance tuning, resource monitors, and warehouse optimization.
Strong proficiency in SQL (complex queries, stored procedures, optimization).
Proficiency in Python, with demonstrated experience using Snowpark for data transformations.
Experience building CI/CD pipelines for Snowflake using modern DevOps tooling.
Solid understanding of data modeling methodologies (Kimball, Data Vault, or 3NF).
Experience with data governance, lineage, and metadata tools (Collibra, Alation, or Azure Purview).
Strong troubleshooting, analytical, and communication skills with the ability to engage both technical and business audiences.
Excellent problem‑solving and root‑cause analysis capabilities.
Strong communication and documentation skills across technical and non‑technical audiences.
Proven ability to work collaboratively in Agile or cross‑functional DevOps teams.
A growth mindset with a commitment to continuous learning and process improvement.
Ability to thrive in a fast‑paced, mission‑driven environment supporting critical healthcare data operations.
Preferred
Experience with dbt or Kafka for orchestration and streaming.
Exposure to data quality frameworks such as Great Expectations or Monte Carlo.
Understanding of real‑time and batch data ingestion architectures.
Snowflake Certification (SnowPro Core or Advanced).
Prior experience in healthcare, insurance, or other regulated data environments.
Why Should You Apply?
Health Benefits
Referral Program
Excellent growth and advancement opportunities
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or expression, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
#J-18808-Ljbffr