Lead Data Engineer

3B Staffing LLC

Kansas City, MO

Apply

JOB DETAILS

SKILLS

Agile Programming Methodologies, Amazon Web Services (AWS), Cloud Computing, Communication Skills, Computer Science, Cost Control, Cross-Functional, Data Management, Data Migration, Data Quality, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Database Programming, Detail Oriented, GSP (Good Safety Practices), Government, Healthcare, Informatica, Information/Data Security (InfoSec), Insurance, Leadership, Market Analysis, Microsoft Windows Azure, Oracle, Oracle Applications, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Production Systems, Python Programming/Scripting Language, Regulations, Regulatory Compliance, Regulatory Reports, Risk Analysis, SQL (Structured Query Language), Scrum Project Management and Software Development, Security Protocols, Snowflake Schema, Sprint Planning, System Migration, Team Lead/Manager, Technical Writing, Telephone Skills, Traceability, Unix Shell Programming

LOCATION

Kansas City, MO

POSTED

Today

LinkedIn Must needed Direct line phone no must needed

Lead Data Engineer - - Hybird Kansas City -

Job Description - Lead Data Engineer - Oracle to Snowflake Migration

• (I added LEAD, client did not say this, but it certainly sounded like the Lead to me)

Duration - we'll start with 12 months, we'll likely extend to 24 months. Potential for-hire.

Location - Hybrid. Build relations on the front-end. I get the impression this is more remote than onsite.

Interview - 90 minutes onsite. They are seeking candidates that reside in the KC area

Job Summary

We are seeking a skilled Lead Data Engineer to support the migration of core data systems from Oracle to Snowflake. This role is critical for modernizing the data infrastructure to support a highly regulated reporting program, data sharing among large enterprise entities, risk analysis, and advanced analytics. The ideal candidate will architect and implement secure, scalable cloud data solutions while preserving regulatory compliance and data integrity.

Key Responsibilities
• Design and implement scalable ETL/ELT pipelines to migrate large volumes of regulatory data from Oracle to Snowflake.
• Translate Oracle PL/SQL procedures into Snowflake SQL and Snowpark logic.
• Collaborate with teams managing data calls, statutory reporting, and market analysis tools.
• Implement cost-optimized Snowflake solutions that meet data security and compliance standards.
• Perform data validation, schema conversion, and audit tracking to ensure accuracy and traceability.
• Automate data workflows and integrate with tools supporting data platforms.
• Maintain clear technical documentation and participate in Agile sprint planning.

Required Qualifications
• Bachelor's degree in Computer Science, Data Science, or related field desired.
• 7+ years of experience in data engineering or database development.
• Deep expertise with Oracle databases (PL/SQL, performance tuning).
• Hands-on experience with Snowflake data warehousing in a production environment.
• Proficient in Python or Shell scripting.
• Familiarity with data tools like dbt, Airflow, Informatica, or Matillion.
• Experience working in highly regulated data environments (e.g., insurance, healthcare, government).

Preferred Qualifications
• SnowPro Certification.
• Experience supporting regulatory bodies.
• Cloud expertise (GSP, Azure or AWS) and knowledge of security protocols.

Soft Skills
• Strong attention to detail and regulatory accuracy.
• Excellent communication with cross functional stakeholders.
• Adaptability in a fast-moving regulatory tech environment.

Call Notes/Updates: We'll discuss in Fri 6/27 Scrum

Job Description - Lead Data Engineer - Oracle to Snowflake Migration
• (I added LEAD, Client did not say this, but it certainly sounded like the Lead to me)

Lead Data Engineer

3B Staffing LLC

Kansas City, MO

About the Company

3B Staffing LLC

Similar Job Searches