Lead Data Engineer

Lead Data Engineer Reports To: Principal Data EngineerLocation: Chicago, ILEnvironment: RemoteStatus: Exempt, SalariedRecognized by Gartner in their Modern 4PL Market Guide, Redwood Logistics is at the forefront of industry innovation. Our cutting-edge supply chain technology pairs with the expertise of our brilliant minds to empower logistics execution across North America and Mexico.Leveraging a comprehensive range of services, data-centric network solutions, and a seamlessly integrated platform, we have established our prominence as a key player in the mid-market segment within the freight tech industry.Whether you're just starting your career or are an established professional looking for your next opportunity, Redwood inspires innovation across teams to provide transformative solutions for our customers.Purpose of Your Work As Lead Data Engineer working within Shared Services (one of our entities), you will be responsible for leading a team of data engineers working on designing, developing, and maintaining scalable data pipelines, a data vault, and various data warehouses and marts. You will work with stakeholders across all departments to deliver key metrics across a variety of functional areas, as well as participate in establishing data strategy.How You Make a Difference Everyday Lead and mentor a team of data engineers, providing guidance, support, and technical expertiseCollaborate with business and technical leaders to set and execute both strategic and tactical initiativesStay current with emerging trends and technologies in data engineering. Identify and evaluate new platforms and tools to enhance the tech stack and improve data infrastructure and processesDesign, develop, and maintain robust data pipelines from various TMS and other data sources.Design and implement new data structures or extend existing structures to support evolving business requirementsEnsure the accuracy, reliability, and completeness of data through effective data validation and monitoring processesDevelop and maintain our Data Vault, Data Warehouse, and Data Marts to deliver key metrics to operational and business stakeholdersCollaborate with a wide variety of users, including internal stakeholders, executives, clients, engineers, and external vendorsImprove and harden processes like code deployments, data validation, error handling/alerting, data democratization, and modernizing tech debtYou've Got This? Bachelor's Degree required (or equivalent experience); preference in Business Administration, Mathematics, Computer Science, or related fieldCreative thinker who is intellectually curious, with a passion for solving puzzles and continuous learning8+ years technology experience with one or more of the following:Amazon Relational Database Service (Aurora, MySQL)Microsoft SQL ServerSnowflakeExceptional SQL development and performance tuning skillsStrong experience with Python language, libraries, applications, and concepts:PandasStreamlitNumPyUnderstanding of JSON and CSVRequestsExperience with the following is a strong plus:TMS, WMS, or other enterprise logistics platformsData Vault 2.0FivetranAzure Data FactoryREST APIProficiency in clouds platforms such as AWS, Azure, or Google CloudCoalesce.ioYAMLExperience with git, DevOps, and CI/CD is a strong plusSelf-starter, entrepreneurial, highly adaptable who can take initiative in a fast-moving environment.Strong communication and leadership skillsWhat We Offer Access to experts and resources for your Learning & Development journeyOpportunity for internal mobilityEmployee referral bonus programEmployee Resource Groups (ERGs)Annual fundraising and volunteer events to give back to communitiesPaid time off, floating holidays, time off to volunteer and rolloverPaid parental leaveMedical, dental, vision and 401k plans (with match)Flexible spending account, mass transit and dependent care plans availableHealth savings account, with a annual company contribution for plan participantsShort-term and long-term disability; life insurance policies subsidized by companyAdditional benefits including pet insurance, accident care, access to legal advice and moreWork Schedule:This position is full-time and remote Monday through Friday from 8:00 AM to 5:00 PM with an hour break, but flexibility is available based on coverage.Compensation Range:Salary Range: $120,000 - $140,000This position is eligible to earn annual incentives based on individual and company performance.The estimated pay range reflects an anticipated range for this position. The actual base salary offered will depend on a variety of factors, including the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, certifications or other professional licenses held, and the geographical location in which the applicant lives and/or which they will be performing the job.Redwood is an equal opportunity employer. Employment decisions at the Company are based on individual merit, qualifications, abilities, and the Company's needs and resources. The Company does not discriminate in recruiting, hiring, compensation, promotions, discipline, termination or any other aspect of employment on the basis of an individual's actual or perceived race, color, creed, religion, sex (including pregnancy, childbirth and related medical conditions), sexual orientation, gender identity, national origin, ancestry, citizenship status, age, disability, marital status, military service or status, genetic information, arrest and conviction record, credit history, or any other basis protected by applicable law.