Lead Data Engineer

Job Description:

• Develop, test, maintain, and support an enterprise data warehouse system and corresponding data
• Design and implement database standards
• Modernize and transform data and reporting capabilities across multiple verticals
• Collaborate with analytics and business teams to improve data models feeding business intelligence tools
• Build and implement scalable solutions for data integrations, storage, reporting, and analytics
• Design, develop, and test data integration solutions
• Write, automate, and document unit, integration, and functional tests
• Manage automated deployments using Git pipelines
• Collaborate with multiple teams to streamline deployment workflows
• Monitor and troubleshoot pipelines for reliability and performance
• Perform data analysis to troubleshoot data-related issues
• Build a data quality framework and assist with resolving data issues
• Mentor less experienced team members through code reviews, pair programming, and hands-on interactions
• Work as an individual contributor under limited supervision

Requirements:

• 4-year college degree or equivalent combination of education and experience
• 10 years of relevant work experience in data engineering, business intelligence or related field
• Experience with database technologies and data warehouse schema design patterns, particularly snowflake and star
• Experience with cloud-based databases and AWS technologies, including Redshift, RDS, S3, EC2, EKS, and Zero ETL
• Advanced SQL query writing and optimization experience with large-scale, complex datasets
• Proficient in object-oriented programming
• Required coding experience in Python
• Experience creating ETL and/or ELT jobs
• Experience with Agile software development methodologies
• Experience with DevOps methodologies and tools, including Git and Artifactory
• Process-oriented with strong documentation skills
• Strong problem-solving and troubleshooting skills
• Authorized to work in the United States
• Ability to work a rotational weekend support schedule once every 8 weeks
• Experience with DBT is preferred
• Experience developing integrations across multiple systems and APIs is a plus

Benefits:

• Medical, Dental Vision plans
• Health Spending Accounts & Flexible Spending Accounts
• PTO: Starting at 19 days a year; based on type of job and tenure
• 11 paid holidays comprised of six core holidays and five floating holidays
• 401K with up to 6% match
• Paid Family Leave
• Employee Assistance
• Short + Long Term Disability and Insurance
• Service Awards and recognition
• Competitive compensation and benefits
• Mentors who empower your growth along a purposeful career path