Job Description
<h3>📋 Description</h3> • You are someone who takes full ownership of your work and thrives on delivering solutions.
• If there’s a problem in our system, no matter where the root cause lies, you pursue it until it’s resolved — ensuring our customers experience a seamless service.
• You never compromise on quality and are always looking for ways to improve performance, scalability, and efficiency.
• With a proactive mindset, you aim to not just meet, but exceed customer expectations.
• Your can-do attitude drives you to find answers and make an impact, no matter the challenge.
• Lead the development, testing, and maintenance of scalable Python code for complex data ingestion, transformation, and processing across streaming and batch architectures.
• Architect and implement sophisticated data transformation models utilizing dbt for AWS Redshift, ensuring data quality and performance.
• Drive the design and optimization of robust data models that proactively support advanced analytics and evolving business intelligence needs.
• Spearhead the development and optimization of high-performance ETL/ELT workflows leveraging AWS DMS, Kinesis, and other cutting-edge data integration technologies.
• Proactively identify, diagnose, and resolve critical data pipeline issues, implementing preventative measures to guarantee data integrity and reliability.
• Collaborate with and mentor junior engineers, fostering best practices in advanced data engineering principles and data modeling techniques.
• Establish comprehensive documentation standards for code, models, and processes to enable seamless team collaboration and knowledge transfer. <h3>🎯 Requirements</h3> • Advanced Programming Proficiency: Expert-level skills in Python and SQL (including advanced optimization techniques in MySQL, Postgres, and SQL Server), coupled with extensive experience using DBT for complex transformations and a strong command of AWS services (DMS, S3, Airflow, Kinesis, DocumentDB, CloudWatch, Kubernetes, Glue).
• Advanced Data Warehousing Principles: Comprehensive understanding of data warehousing best practices for highly scalable, performant, and secure implementations in complex multi-tenant environments, including data governance and data quality frameworks.
• Data Engineering Mastery: 5+ years of progressive full-time experience in data engineering, demonstrating expertise in designing, conducting rigorous code reviews, and managing complex, large-scale ETL/ELT pipelines.
• Expertise in Cloud Data Platforms: Deep understanding and hands-on experience with enterprise-grade cloud data platforms such as AWS Redshift, BigQuery, and Snowflake, including their architectural nuances and performance optimization strategies.
• CI/CD and Infrastructure-as-Code Leadership: Proven ability to establish and maintain robust version control (GitHub) workflows, architect and implement sophisticated CI/CD pipelines for data infrastructure, and a strong advocate for infrastructure-as-code principles and tools. <h3>🏖️ Benefits</h3> • Medical with Blue Cross Blue Shield NC (2 options)
• Dental and Vision with Unum
• Company-paid Life insurance, STD and LTD
• Voluntary benefits including Supplemental Life Insurance, HSA, FSA and Dependant Care, Critical Illness, Accident and Pet Insurance
• 401(k) with up to 3% employer match and NO vesting period
• Flexible PTO policy
• 10 company holidays
• Parental Leave
• Community Impact Program (Volunteer)
• Tech and Wellness Stipend