New

Senior Manager, Data Engineering and Architecture

Cox
$144,900.00 - $241,500.00 / yr
parental leave, paid time off, paid holidays, sick time, 401(k)
United States, Georgia, Avondale Estates
Jan 10, 2025
The Atlanta Journal-Constitution is seeking an experienced and dynamic Sr. Manager, Data Engineering and Architecture to join our Analytics and Research team. In this role, you will lead the development, optimization, and maintenance of our consumer data ecosystem. This role will be pivotal in driving the next phase of our organization's growth, shaping the strategic direction of our data operations, and implementing best practices to ensure scalable, cutting-edge data management solutions. The ideal candidate will bring expertise in managing Snowflake environments, developing ETL processes, overseeing raw data loads, and advancing data warehousing capabilities. This role will also oversee the implementation of a new web analytics tool to support data-driven decision-making and audience segmentation. Key Responsibilities: Oversee the configuration, optimization, and scalability of our Snowflake environment to ensure data integrity and accessibility. Design and manage ETL pipelines for seamless data integration and transformation across platforms like Snowflake and AWS, using functions, stored procedures, and orchestration tools such as Airflow or Prefect. Leverage AWS tools, including EC2, Athena, and Kinesis, to optimize data ingestion, storage, and streaming pipelines. Implement and manage CI/CD pipelines to automate code deployment, testing, and quality assurance, ensuring efficient version control using tools like GitHub. Design and optimize data transformation workflows using dbt to model, clean, and enrich datasets, ensuring high-quality, maintainable, and testable data structures that support analytics and reporting needs. Lead the design and evolution of a robust data warehouse architecture to support reporting, analytics, and business intelligence needs. Manage the ingestion of raw data from various sources, ensuring timely and accurate integration into Snowflake. Integrate and optimize data pipelines from web analytics platforms (e.g., Google Analytics, Amplitude) into the data ecosystem. Manage and mentor a team of data engineers, fostering collaboration, growth, and high performance. Collaborate with analytics, research, and business teams to understand data needs and deliver scalable solutions. Champion best practices in data governance, security, compliance, and quality management. Technical Skills: Proven experience in designing and managing scalable data architectures, with expertise in Snowflake and AWS. Proficiency in AWS tools (e.g., EC2, Athena, Kinesis) and cloud-based infrastructure. Strong experience with CI/CD processes, version control systems like GitHub, and orchestration tools like Apache Airflow or Prefect. Expertise in building and maintaining ETL pipelines and data transformation workflows with dbt. Deep understanding of data warehouse design and optimization. Strong programming skills in SQL and Python; familiarity with other scripting languages is a plus. Demonstrated leadership in managing and mentoring data engineering teams. Excellent communication and collaboration skills. Experience: Bachelor's degree in computer science, engineering, or related field; advanced degree preferred. With a BA/BS, must have 8+ years of experience with at least 3 years of experience in a management/ leadership role. Those candidates with an advanced degree will need 6+ years of experience with a master's degree or 3+ years of experience with a Ph.D. Without a degree would need 12+ years of experience. Preferred candidates will have 10+ years of experience; 7+ years in data engineering, data architecture, or related roles. Proven track record managing Snowflake environments and ETL pipelines. Extensive experience designing and maintaining data warehouses. Hands-on experience with web analytics tools and integrating them into data ecosystems. USD 144,900.00 - 241,500.00 per year Compensation: Compensation includes a base salary of $144,900.00 - $241,500.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program. Benefits: The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company's needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave. About Cox Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today! Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page . Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.