Kforce Inc is seeking a Data Engineer with exceptional SQL expertise to build scalable data transformation pipelines. The role involves translating business logic into SQL pipelines and optimizing complex transformation logic in a cloud data environment.
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:
- DE III: 7+ years of experience in data engineering
- DE II: 3-7+ years of experience in data engineering
- 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