POSITION: Lead Snowflake Data Engineer LOCATION: Charlotte, NC 28217 (Hybrid 3 times per week) PAY RANGE: $76.00 - $84.00 per hour W2 DURATION: 6-Month Contract-To-Hire (100% career opportunity) MUST-HAVES: 10 years of experience in a data engineering role, with expertise in designing and building ETL pipelines, data models, and warehouses. Extensive experience working with Snowflake, specifically the Data Lakehouse Solutions. Must have proficiency in Snowpipes, Snowpark, etc. Strong proficiency in Azure and Databricks. SQL, Python, and Spark. Experience working with Apache Iceberg and distributed computing frameworks. Strong communication skills & demonstrated leadership ability to manage relationships across cross-functional teams and global stakeholders. Hands-on experience with CI/CD tools and DevOps practices for automation. Retail industry experience with familiarity in processing transaction data, inventory data, and customer insights. SUMMARY: A top Insight Global client in Charlotte, NC is looking for a Lead Snowflake Data Engineer to join their team. As the Tech Lead Data Engineer, your primary responsibility will be to lead the design, development, and implementation of data solutions while driving strategic initiatives across the enterprise. This role requires you to guide a team of 20 data engineers, facilitate cross-functional collaboration, and act as a subject matter expert to ensure seamless integration between business objectives and technical implementations. Responsibilities are shown below: Provide day-to-day technical leadership for key company initiatives. Lead design and development efforts for scalable data pipelines and solutions leveraging Azure, Databricks, Snowflake, and Apache Iceberg. Collaborate with business teams, architects, business analysts, source system owners, and business stakeholders to ensure enterprise data requirements are met. Guide and mentor data engineers to align with organizational standards and best practices. Drive critical conversations across platform, business, and technical teams to ensure timely and efficient delivery of projects. Lead data modeling efforts to design and optimize schemas, ensuring data integrity and performance. Oversee the documentation of engineering processes to ensure knowledge retention and scalability. Actively participate in architectural and strategic decisions while ensuring compliance with data governance, security, and privacy requirements. Establish CI/CD pipelines and DevOps practices for automating deployment and ensuring operational excellence. Act as the primary point of contact for cross-regional teams, facilitating knowledge transfer and resolving dependencies. Compensation: $76.00 - $84.00/hr Exact compensation may vary based on several factors, including skills, experience, and education. Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.
