Engineer, Data Sr

Job Title

Engineer, Data Sr

Duration

06 Months

Location

Columbia, MD (Hybrid)

The ideal candidate will demonstrate deep Snowflake and SQL expertise, hands-on experience with Snowpark (Python), and a strong foundation in data architecture, governance, and automation.

Key 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.

Required Skills & Experience

• 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.

Preferred Qualifications

• 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.

Soft Skills & Professional Attributes

• 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.