At The Atlanta Journal-Constitution (AJC), our mission is to be the most essential and engaging source of news for the people of Atlanta, Georgia and the South. As we transition from a historic daily newspaper to a dynamic modern media company, we are seeking a talented Analytics Engineerto join our team. The AJC believes that when you cover the South, you uncover the nation. It's a belief that's produced award-winning journalism, elevated our community, and captured the substance and soul of our hometown.
If you're ready to make headlines with your talent and drive, we want you on our team. Apply now and be a part of the next chapter in the AJC's transformation.
WHAT YOU'LL DO
Key Responsibilities:
- Develop and maintain scalable dbt models, following best practices for modularity and performance.
- Apply Kimball-style dimensional modeling techniques (star schema, slowly changing dimensions, fact and dimension tables) to structure data for analysis and reporting.
- Explore, analyze, and validate data to ensure accuracy, consistency, and completeness of dbt models.
- Implement and maintain automated dbt tests to ensure data quality, including checks for anomalies, nulls, duplicates, and referential integrity.
- Investigate and troubleshoot data anomalies, pipeline errors, and model discrepancies, collaborating with teams to resolve issues promptly.
- Partner closely with data analysts to build reliable reporting models and ensure the data feeding reports is accurate, actionable, and aligned with business needs.
- Ensure the availability, consistency, and accessibility of data for analytics teams working with Tableau and other BI tools.
- Participate in code and PR reviews to maintain high-quality, consistent dbt models and data pipeline code.
- Monitor and optimize data pipeline performance, leveraging tools on AWS such as Lambda, SQS, Athena, EC2, and Kinesis.
- Follow data governance standards to ensure data integrity, security, and compliance.
WHO YOU ARE
Required Qualifications:
- REQUIRED- must live within a commutable distance to AJC Midtown Atlanta office.
- Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. No OPT, CPT, STEM/OPT or visa sponsorship now or in future.
- 2-4 years of experience as an Analytics Engineer or in a related role.
- Bachelor's degree in Computer Science, Data Science, Statistics, or a related field with 2+ years experience or 14 years equivalent working experience
- Good understanding of data quality, validation, and governance practices.
- Experience working with data analysts or BI teams to build accurate reporting datasets.
- Proficiency with Snowflake or similar cloud data warehouse technologies
- Solid understanding of dimensional modeling concepts (star schemas, fact and dimension tables, slowly changing dimensions).
Preferred Qualifications
- Experience using dbt for building, testing, and maintaining data models.
- Experience collaborating with data analysts to build accurate, actionable reporting models.
- Proficiency with Snowflake and building scalable data warehouses.
- Familiarity with AWS services (Lambda, SQS, Athena, EC2, Kinesis) and cloud-based data pipelines.
- Understanding of event and web analytics data from tools like Amplitude and Google Analytics.
- Experience with real-time data streams and troubleshooting data pipeline issues.
USD 89,400.00 - 134,000.00 per year
Compensation:
Compensation includes a base salary in the range of $89,400.00 - $134,000.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.
Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship.
Top Skills
What the Team is Saying
What We Do
For well over a century, Cox Enterprises has been shaping the future with daring ideas and values-driven thinking. Since our founding in 1898, our relentless spirit of innovation has driven us to disrupt industries and enhance the quality of life in the communities we serve. Through our major divisions — Cox Communications, Cox Automotive and Cox Farms — our people have countless opportunities to grow and make an impact in the communications and automotive industries, as well as in new ventures in agriculture, cleantech, digital media and more. As a privately-held, family-owned business, we know that people are our most valuable asset. We offer a supportive and inclusive environment with flexible career growth, amazing benefits and work-life balance at the forefront. Our mission, our ways of working and our commitment to people are what make our workplace culture remarkably flexible and resilient. Join us to build a better future and make your mark.
Why Work With Us
At our core, Cox is a technology company that values human relationships. We know people feel most empowered when their work has meaning, when they feel respected and have opportunities to grow. “Career satisfaction” is not enough at Cox — we’re here to help you find balance, live well and achieve your career goals even as they change over time.
Gallery
Cox Enterprises Teams
Cox Enterprises Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Every person has different working styles and preferences — and we aim to empower teams to work where they are most comfortable. Some roles require in-person work, but for those that can be performed remotely, we offer flexibility.
