Senior Data Engineer

Join our dynamic team as a Senior Data Engineer! We are looking for a passionate and experienced professional to help us structure and optimize our data for impactful analytics and reporting. In this pivotal role, you will design, build, and maintain robust data pipelines and systems, ensuring that our data remains accurate, accessible, and consistent for analysis. Our technology stack includes Snowflake as our primary Data Warehouse, along with dbt, AWS, GCP, and other innovative tools to enhance our data capabilities. This is your chance to thrive in a fast-paced environment and make a significant difference in our business strategy. Key Responsibilities: Lead the design, development, and maintenance of efficient dbt models, emphasizing modularity and performance. Utilize Kimball-style dimensional modeling techniques to structure data optimally for reporting and analysis. Conduct data exploration, analysis, and validation to ensure the reliability of dbt models. Set up and manage automated dbt tests to maintain high standards of data quality, including checks for anomalies and duplicates. Investigate and resolve data anomalies and pipeline errors while collaborating with relevant teams. Work effectively with data analysts to create dependable reporting models that align with business objectives. Guarantee the availability and consistency of data for analytics teams utilizing Tableau, PowerBI, Amplitude, Google Analytics, and more. Engage in code and PR reviews to uphold the quality of dbt models and code for data pipelines. Monitor and optimize data pipeline performance using AWS tools like Lambda, SQS, Athena, EC2, and Kinesis. Enforce data governance policies to ensure data integrity and compliance with security standards. Qualifications: 4+ years of experience as a Data Engineer or a similar role. Degree in a related field such as Computer Science, Statistics, or Data Science; an advanced degree is preferred. Proven experience with dbt for building and managing data models and transformations. Strong understanding of data quality, validation, and governance best practices. Experience collaborating with data analysts on actionable reporting models. Proficiency with Snowflake and expertise in building scalable data warehouses. Expertise in Kimball-style dimensional modeling. Strong SQL skills for querying, automation, and validation. Proficient in Python for scripting and automation tasks. Familiarity with AWS tools and cloud-based data pipelines. Knowledge of event and web analytics data tools such as Amplitude and Google Analytics. Experience with real-time data streams and troubleshooting pipeline issues. Must be located near Atlanta, GA, with the ability to come onsite 2-3 times a week to our Midtown office. Compensation: The compensation package includes a base salary range of $99,000.00 - $165,000.00 per year, which may vary based on the candidate's knowledge, skills, and abilities. Benefits: We offer flexibility in taking vacation days, seven paid holidays, and up to 160 hours of wellness leave annually for personal or family health. Additional paid time off is available for bereavement, jury duty, volunteer work, military service, and parental leave.