Data Engineer - Nashville, TN

Job Title: Data Engineer
Location: Remote in Nashville, TN
Can do Only W2, No C2C

Job Summary:

• Kforce is seeking an experienced Data Engineer to support a modern cloud data environment. The ideal candidate will have exceptional SQL expertise and proven experience designing, building, and optimizing scalable, complex data transformation pipelines.
• This role requires strong hands-on experience with SQL, Snowflake, Data Warehousing, Data Modeling, and Data Engineering practices. The candidate will work independently, support production-grade data workflows, and collaborate with cross-functional teams to deliver reliable analytics solutions.

Key Responsibilities:

• Design, develop, and optimize complex SQL-based data transformation pipelines at enterprise scale.
• Translate business requirements and logic into efficient, maintainable, and scalable SQL workflows.
• Perform advanced SQL development including:
• Query optimization
• Analytical functions
• Set-based operations
• Complex transformations
• Build and maintain enterprise data warehouse solutions using modern data engineering practices.
• Develop and implement data models including:
• Star schema
• Snowflake schema
• Denormalized data models
• Design, develop, and maintain scalable data processing workflows.
• Implement data quality frameworks, automated validation processes, and testing strategies.
• Support production-grade data pipelines, monitoring, troubleshooting, and issue resolution.
• Work with orchestration and scheduling frameworks for automated data workflows.
• Collaborate with business stakeholders, analysts, and engineering teams to simplify complex technical concepts.
• Follow Git-based development workflows and CI/CD practices.
• Ensure data integrity, reliability, performance, and availability across platforms.

Required Skills:

• 7+ years of experience in Data Engineering (DE III level)
• 3+ years of experience in Data Engineering (DE II level)
• Advanced to expert-level SQL development experience.
• Strong experience designing and optimizing complex SQL transformation logic.
• Hands-on experience with Snowflake in enterprise data warehouse or analytics environments.
• Strong knowledge of:
• Data Engineering concepts
• Data Warehousing
• Data Modeling
• Dimensional Modeling
• Data Processing
• Analytics platforms
• Experience with:
• Snowflake Tasks
• Data pipeline orchestration
• Workflow scheduling
• Production data workflows
• Experience with Git-based workflows (GitHub preferred).
• Strong understanding of:
• Data quality frameworks
• Automated testing
• Data validation processes
• Familiarity with:
• COPY INTO
• Snowflake-native ingestion patterns
• Snowflake scheduling and orchestration capabilities
• Strong analytical and problem-solving skills.
• Ability to work independently and manage production systems.

Preferred Qualifications:

• Hands-on experience with Python for:
• Data processing
• Automation
• Pipeline development
• Experience with CI/CD implementation patterns.
• Experience with GitHub Actions.
• Experience with AWS cloud services, including:
• Amazon S3
• AWS Glue
• Exposure to:
• Apache Airflow DAG development
• Managed Airflow environments (MWAA)
• Experience working in large-scale enterprise data ecosystems.
• Experience with:
• SRE-style automation
• Monitoring
• Observability frameworks
• Healthcare domain experience including:
• PHI/PII data handling
• Healthcare claims lifecycle
• EDI 835/837 formats
• Exposure to Artificial Intelligence and modern analytics environments.

Soft Skills:

• Excellent verbal and written communication skills.
• Ability to explain complex technical concepts clearly.
• Strong analytical mindset with structured problem-solving approach.
• Detail-oriented with strong focus on data accuracy.
• Proactive and accountable when managing production systems.
• Ability to collaborate effectively with cross-functional teams.
• Strong ownership mindset and ability to work autonomously.
• Effective conflict resolution and stakeholder management skills.

Mandatory Skills:

Must Have:

• Advanced SQL / Expert SQL
• Data Engineering
• Snowflake
• Data Transformation Pipelines
• Data Warehousing
• Dimensional Modeling
• Data Modeling
• Snowflake Tasks
• COPY INTO
• Data Quality & Validation
• Testing Frameworks
• Git / GitHub Workflows
• Workflow Orchestration
• Scheduling
• Cloud Data Platforms
• Production Data Support