Data Engineer

Kforce Inc is seeking a Data Engineer with exceptional SQL expertise and experience in building scalable data transformation pipelines. The role involves designing and optimizing complex transformation logic and translating business logic into efficient SQL pipelines.

Responsibilities:

• Query performance, analytical functions, set-based operations, and data modeling techniques
• Translate business logic into efficient, maintainable SQL pipelines
• Dimensional modeling (star, snowflake, denormalized)
• Designing and optimizing complex transformation logic at scale

Requirements:

• 7+ years of experience in data engineering (DE III)
• 3-7+ years of experience in data engineering (DE II)
• Advanced to expert-level SQL with a consistent track record of designing and optimizing complex transformation logic at scale
• Practical Snowflake experience working within an EDW or analytics environment
• Experience with Git-based workflows (GitHub preferred)
• Exposure to orchestration tools (Snowflake Tasks required; Airflow/MWAA nice to have)
• Strong grounding in data quality frameworks, automated validation, and testing
• Familiarity with: COPY INTO and Snowflake-native ingestion patterns; Snowflake Tasks for orchestration and scheduling
• Strong, clear communicator; able to simplify complex concepts
• Analytical thinker with a structured, methodical problem solving approach
• Comfortable working autonomously and engaging cross-functional teams
• Detail-oriented, proactive, and accountable with production systems
• Hands-on Python for data processing and automation
• Familiarity with CI/CD patterns (GitHub Actions preferred)
• Experience with AWS (S3, Glue)
• Exposure to Airflow DAG development
• Experience in large, complex enterprise data ecosystems
• Background in SRE-style automation, monitoring, observability
• Healthcare data experience, including PHI/PII handling, claims lifecycle, and EDI 835/837 formats